PREVIEW / etf_30min / 2019-10-24

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-10-24.parquet
  size:    494 KB
  rows:    17,088

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-10-24 04:00:00	SPY	ETF	300.36	300.36	299.88	299.95	2151.0
2019-10-24 04:30:00	SPY	ETF	300.21	300.33	300.2	300.33	4250.0
2019-10-24 05:00:00	SPY	ETF	300.39	300.45	300.31	300.31	7035.0
2019-10-24 05:30:00	SPY	ETF	300.32	300.42	300.3	300.42	3314.0
2019-10-24 06:00:00	SPY	ETF	300.4	300.49	300.4	300.46	8810.0
2019-10-24 06:30:00	SPY	ETF	300.47	300.56	300.44	300.55	16775.0
2019-10-24 07:00:00	SPY	ETF	300.51	300.68	300.47	300.67	57035.0
2019-10-24 07:30:00	SPY	ETF	300.66	300.78	300.6	300.76	33756.0
2019-10-24 08:00:00	SPY	ETF	300.76	300.85	300.0	300.65	156038.0
2019-10-24 08:30:00	SPY	ETF	300.66	300.83	300.53	300.7	128030.0
2019-10-24 09:00:00	SPY	ETF	300.72	300.91	300.64	300.89	208257.0
2019-10-24 09:30:00	SPY	ETF	300.91	301.07	299.81	299.88	4265754.0
2019-10-24 10:00:00	SPY	ETF	299.88	300.04	299.54	299.77	2891411.0
2019-10-24 10:30:00	SPY	ETF	299.76	300.0	299.4601	299.92	2116899.0
2019-10-24 11:00:00	SPY	ETF	299.92	300.5	299.92	300.47	2486947.0
2019-10-24 11:30:00	SPY	ETF	300.48	300.725	300.05	300.56	3293746.0
2019-10-24 12:00:00	SPY	ETF	300.56	300.72	299.52	299.99	3259319.0
2019-10-24 12:30:00	SPY	ETF	299.99	300.33	299.95	300.12	1422950.0
2019-10-24 13:00:00	SPY	ETF	300.11	300.16	299.81	300.02	1192427.0
2019-10-24 13:30:00	SPY	ETF	300.02	300.06	299.58	299.745	1299319.0
2019-10-24 14:00:00	SPY	ETF	299.745	300.01	299.69	300.0	1389892.0
2019-10-24 14:30:00	SPY	ETF	300.005	300.22	299.97	300.15	1336174.0
2019-10-24 15:00:00	SPY	ETF	300.15	300.46	300.11	300.345	1452350.0
2019-10-24 15:30:00	SPY	ETF	300.35	300.65	300.24	300.42	5325645.0
2019-10-24 16:00:00	SPY	ETF	300.42	300.62	299.9	300.0	2232205.0
2019-10-24 16:30:00	SPY	ETF	300.0	300.4423	299.8	299.81	275822.0
2019-10-24 17:00:00	SPY	ETF	299.76	299.94	299.76	299.85	16736.0
2019-10-24 17:30:00	SPY	ETF	299.86	299.92	299.76	299.85	11413.0
2019-10-24 18:00:00	SPY	ETF	299.89	300.37	299.81	299.83	111891.0
2019-10-24 18:30:00	SPY	ETF	299.81	299.98	299.81	299.89	18295.0
2019-10-24 19:00:00	SPY	ETF	299.96	299.96	299.92	299.95	1400.0
2019-10-24 19:30:00	SPY	ETF	299.95	299.95	299.62	299.73	36032.0
2019-10-24 04:00:00	QQQ	ETF	192.95	192.97	192.79	192.91	4555.0
2019-10-24 04:30:00	QQQ	ETF	192.91	193.06	192.9	193.06	6300.0
2019-10-24 05:00:00	QQQ	ETF	193.08	193.15	193.01	193.02	5119.0
2019-10-24 05:30:00	QQQ	ETF	193.11	193.15	193.11	193.12	1200.0
2019-10-24 06:00:00	QQQ	ETF	193.08	193.24	193.08	193.21	5565.0
2019-10-24 06:30:00	QQQ	ETF	193.22	193.27	193.19	193.25	6671.0
2019-10-24 07:00:00	QQQ	ETF	193.21	193.42	193.14	193.42	26821.0
2019-10-24 07:30:00	QQQ	ETF	193.43	193.51	193.37	193.51	31105.0
2019-10-24 08:00:00	QQQ	ETF	193.15	193.6	192.85	193.44	95292.0
2019-10-24 08:30:00	QQQ	ETF	193.47	193.59	193.33	193.45	67999.0
2019-10-24 09:00:00	QQQ	ETF	193.45	193.65	193.4	193.64	131166.0
2019-10-24 09:30:00	QQQ	ETF	193.64	193.8	192.99	193.1	2351502.0
2019-10-24 10:00:00	QQQ	ETF	193.09	193.25	192.74	193.13	1090343.0
2019-10-24 10:30:00	QQQ	ETF	193.11	193.38	192.86	193.33	703396.0
2019-10-24 11:00:00	QQQ	ETF	193.34	193.88	193.335	193.86	1194536.0
2019-10-24 11:30:00	QQQ	ETF	193.86	194.15	193.73	194.08	1688955.0
2019-10-24 12:00:00	QQQ	ETF	194.09	194.21	193.3	193.681	1317154.0
2019-10-24 12:30:00	QQQ	ETF	193.69	194.0	193.65	193.8375	578479.0

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

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