PREVIEW / etf_30min / 2019-12-24

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-12-24.parquet
  size:    309 KB
  rows:    10,599

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-12-24 04:00:00	SPY	ETF	321.47	321.57	321.47	321.57	751.0
2019-12-24 04:30:00	SPY	ETF	321.59	321.59	321.57	321.57	1103.0
2019-12-24 05:00:00	SPY	ETF	321.57	321.57	321.52	321.57	2320.0
2019-12-24 05:30:00	SPY	ETF	321.57	321.6	321.55	321.55	500.0
2019-12-24 06:00:00	SPY	ETF	321.55	321.57	321.55	321.57	1882.0
2019-12-24 06:30:00	SPY	ETF	321.54	321.6	321.54	321.6	2300.0
2019-12-24 07:00:00	SPY	ETF	321.571	321.73	321.57	321.73	3722.0
2019-12-24 07:30:00	SPY	ETF	321.75	321.75	321.59	321.64	8068.0
2019-12-24 08:00:00	SPY	ETF	321.62	321.7299	321.38	321.59	37950.0
2019-12-24 08:30:00	SPY	ETF	321.6	321.62	321.45	321.51	20980.0
2019-12-24 09:00:00	SPY	ETF	321.51	321.53	321.41	321.48	50720.0
2019-12-24 09:30:00	SPY	ETF	321.47	321.52	320.9	321.035	3497482.0
2019-12-24 10:00:00	SPY	ETF	321.04	321.23	321.02	321.21	2305669.0
2019-12-24 10:30:00	SPY	ETF	321.22	321.29	321.09	321.1401	1913965.0
2019-12-24 11:00:00	SPY	ETF	321.155	321.28	321.12	321.18	1567871.0
2019-12-24 11:30:00	SPY	ETF	321.19	321.28	321.14	321.145	2446972.0
2019-12-24 12:00:00	SPY	ETF	321.15	321.19	321.08	321.15	1234510.0
2019-12-24 12:30:00	SPY	ETF	321.15	321.28	321.05	321.26	3101212.0
2019-12-24 13:00:00	SPY	ETF	321.24	321.34	321.2	321.3049	1124524.0
2019-12-24 13:30:00	SPY	ETF	321.3	321.3	321.17	321.2	162554.0
2019-12-24 14:00:00	SPY	ETF	321.2	321.2499	321.18	321.2499	16494.0
2019-12-24 14:30:00	SPY	ETF	321.24	321.24	321.2	321.2	697.0
2019-12-24 15:00:00	SPY	ETF	321.26	321.27	321.24	321.27	900.0
2019-12-24 15:30:00	SPY	ETF	321.24	321.27	321.16	321.16	2527.0
2019-12-24 16:00:00	SPY	ETF	321.25	321.25	321.2	321.21	2386.0
2019-12-24 16:30:00	SPY	ETF	321.25	321.28	321.21	321.24	3935.0
2019-12-24 04:00:00	QQQ	ETF	211.92	212.0	211.92	211.98	3400.0
2019-12-24 04:30:00	QQQ	ETF	211.97	212.0	211.95	212.0	2200.0
2019-12-24 05:00:00	QQQ	ETF	212.0	212.0	211.97	211.99	2190.0
2019-12-24 05:30:00	QQQ	ETF	211.98	212.02	211.97	211.99	2298.0
2019-12-24 06:00:00	QQQ	ETF	212.02	212.04	212.02	212.02	3700.0
2019-12-24 06:30:00	QQQ	ETF	212.03	212.07	212.03	212.07	700.0
2019-12-24 07:00:00	QQQ	ETF	212.05	212.11	212.05	212.11	5838.0
2019-12-24 07:30:00	QQQ	ETF	212.11	212.12	212.0	212.03	10930.0
2019-12-24 08:00:00	QQQ	ETF	212.07	212.1	211.96	212.03	25032.0
2019-12-24 08:30:00	QQQ	ETF	212.05	212.05	211.99	212.05	15092.0
2019-12-24 09:00:00	QQQ	ETF	212.05	212.06	211.93	212.0	14514.0
2019-12-24 09:30:00	QQQ	ETF	211.97	212.09	211.44	211.65	1411548.0
2019-12-24 10:00:00	QQQ	ETF	211.64	211.83	211.64	211.82	728114.0
2019-12-24 10:30:00	QQQ	ETF	211.81	211.85	211.665	211.76	762930.0
2019-12-24 11:00:00	QQQ	ETF	211.77	211.89	211.75	211.83	326386.0
2019-12-24 11:30:00	QQQ	ETF	211.84	211.91	211.8	211.85	327740.0
2019-12-24 12:00:00	QQQ	ETF	211.85	211.86	211.76	211.806	285664.0
2019-12-24 12:30:00	QQQ	ETF	211.81	211.92	211.75	211.87	1050384.0
2019-12-24 13:00:00	QQQ	ETF	211.87	212.01	211.8082	211.93	682024.0
2019-12-24 13:30:00	QQQ	ETF	211.92	211.93	211.83	211.875	27562.0
2019-12-24 14:00:00	QQQ	ETF	211.86	211.9	211.86	211.9	2752.0
2019-12-24 14:30:00	QQQ	ETF	211.92	211.92	211.92	211.92	100.0
2019-12-24 15:00:00	QQQ	ETF	211.8956	211.9	211.8956	211.9	336.0
2019-12-24 15:30:00	QQQ	ETF	211.92	211.92	211.92	211.92	100.0

> showing 50 of 10,599 rows — these rows as CSV

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