PREVIEW / etf_30min / 2019-07-15

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-07-15.parquet
  size:    492 KB
  rows:    17,475

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2019-07-15 04:00:00	SPY	ETF	301.16	301.25	301.01	301.01	2743.0
2019-07-15 04:30:00	SPY	ETF	301.0	301.0	300.95	300.95	1063.0
2019-07-15 05:00:00	SPY	ETF	300.87	301.0	300.8	300.8	400.0
2019-07-15 05:30:00	SPY	ETF	300.74	300.87	300.62	300.79	9205.0
2019-07-15 06:00:00	SPY	ETF	300.83	301.05	300.82	300.95	8088.0
2019-07-15 06:30:00	SPY	ETF	300.9	301.0	300.9	300.94	8204.0
2019-07-15 07:00:00	SPY	ETF	300.97	301.08	300.96	301.05	55024.0
2019-07-15 07:30:00	SPY	ETF	301.06	301.2	301.04	301.15	57214.0
2019-07-15 08:00:00	SPY	ETF	301.08	301.25	300.65	301.13	198793.0
2019-07-15 08:30:00	SPY	ETF	301.13	301.26	301.06	301.1799	87711.0
2019-07-15 09:00:00	SPY	ETF	301.17	301.2101	301.08	301.11	79561.0
2019-07-15 09:30:00	SPY	ETF	301.13	301.13	300.42	300.59	4372367.0
2019-07-15 10:00:00	SPY	ETF	300.59	300.81	300.45	300.71	2577876.0
2019-07-15 10:30:00	SPY	ETF	300.72	300.8465	300.37	300.69	2387479.0
2019-07-15 11:00:00	SPY	ETF	300.69	300.76	300.54	300.58	1693095.0
2019-07-15 11:30:00	SPY	ETF	300.58	300.59	300.35	300.4	1235349.0
2019-07-15 12:00:00	SPY	ETF	300.4	300.47	300.3	300.37	1675057.0
2019-07-15 12:30:00	SPY	ETF	300.38	300.42	300.19	300.31	1189855.0
2019-07-15 13:00:00	SPY	ETF	300.31	300.39	300.23	300.355	2873824.0
2019-07-15 13:30:00	SPY	ETF	300.36	300.54	300.32	300.43	1042270.0
2019-07-15 14:00:00	SPY	ETF	300.435	300.78	300.43	300.64	1611375.0
2019-07-15 14:30:00	SPY	ETF	300.64	300.69	300.5	300.62	963866.0
2019-07-15 15:00:00	SPY	ETF	300.62	300.74	300.44	300.55	1655458.0
2019-07-15 15:30:00	SPY	ETF	300.54	300.77	300.49	300.76	4440933.0
2019-07-15 16:00:00	SPY	ETF	300.77	300.85	300.61	300.73	4824069.0
2019-07-15 16:30:00	SPY	ETF	300.73	300.81	300.69	300.72	140671.0
2019-07-15 17:00:00	SPY	ETF	300.72	300.75	300.61	300.69	157564.0
2019-07-15 17:30:00	SPY	ETF	300.7	300.75	300.65	300.65	18083.0
2019-07-15 18:00:00	SPY	ETF	300.69	300.69	300.61	300.65	38593.0
2019-07-15 18:30:00	SPY	ETF	300.65	300.74	300.63	300.74	28414.0
2019-07-15 19:00:00	SPY	ETF	300.74	300.74	300.67	300.7	2281.0
2019-07-15 19:30:00	SPY	ETF	300.7	300.94	300.7	300.92	37377.0
2019-07-15 04:00:00	QQQ	ETF	193.58	193.85	193.45	193.5	5600.0
2019-07-15 04:30:00	QQQ	ETF	193.53	193.69	193.53	193.67	2918.0
2019-07-15 05:00:00	QQQ	ETF	193.65	193.68	193.45	193.54	8300.0
2019-07-15 05:30:00	QQQ	ETF	193.51	193.55	193.4	193.51	5269.0
2019-07-15 06:00:00	QQQ	ETF	193.49	193.63	193.49	193.55	5800.0
2019-07-15 06:30:00	QQQ	ETF	193.55	193.64	193.55	193.64	850.0
2019-07-15 07:00:00	QQQ	ETF	193.62	193.77	193.62	193.76	18827.0
2019-07-15 07:30:00	QQQ	ETF	193.76	193.85	193.72	193.85	19369.0
2019-07-15 08:00:00	QQQ	ETF	193.64	193.93	193.46	193.8999	61287.0
2019-07-15 08:30:00	QQQ	ETF	193.87	194.01	193.82	193.97	121174.0
2019-07-15 09:00:00	QQQ	ETF	193.97	194.02	193.88	193.97	72768.0
2019-07-15 09:30:00	QQQ	ETF	193.97	194.0	193.47	193.67	2017896.0
2019-07-15 10:00:00	QQQ	ETF	193.66	193.81	193.44	193.73	1190909.0
2019-07-15 10:30:00	QQQ	ETF	193.73	193.8033	193.5	193.705	975204.0
2019-07-15 11:00:00	QQQ	ETF	193.71	193.91	193.63	193.75	1043247.0
2019-07-15 11:30:00	QQQ	ETF	193.75	193.79	193.57	193.64	686080.0
2019-07-15 12:00:00	QQQ	ETF	193.64	193.74	193.58	193.6	478515.0
2019-07-15 12:30:00	QQQ	ETF	193.6	193.62	193.45	193.53	517351.0

> showing 50 of 17,475 rows — these rows as CSV

> unlock the full archive -- $79 one-time