PREVIEW / etf_30min / 2019-12-20

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-12-20.parquet
  size:    527 KB
  rows:    18,526

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-20 04:00:00	SPY	ETF	319.7	319.7	319.41	319.41	12190.0
2019-12-20 04:30:00	SPY	ETF	319.41	319.44	319.33	319.36	8879.0
2019-12-20 05:00:00	SPY	ETF	319.35	319.41	319.35	319.41	5760.0
2019-12-20 05:30:00	SPY	ETF	319.34	319.57	319.34	319.57	18051.0
2019-12-20 06:00:00	SPY	ETF	319.57	319.7	319.57	319.59	8972.0
2019-12-20 06:30:00	SPY	ETF	319.57	319.6	319.53	319.58	24621.0
2019-12-20 07:00:00	SPY	ETF	319.6	319.61	319.46	319.49	50123.0
2019-12-20 07:30:00	SPY	ETF	319.46	319.75	319.46	319.72	43711.0
2019-12-20 08:00:00	SPY	ETF	319.6201	319.83	319.38	319.8	122767.0
2019-12-20 08:30:00	SPY	ETF	319.79	320.0	319.75	319.96	165699.0
2019-12-20 09:00:00	SPY	ETF	319.98	320.76	319.97	320.49	1169047.0
2019-12-20 09:30:00	SPY	ETF	320.46	320.9	320.37	320.59	16328494.0
2019-12-20 10:00:00	SPY	ETF	320.59	320.82	320.5	320.8	4950428.0
2019-12-20 10:30:00	SPY	ETF	320.7933	321.9742	320.745	320.9	29748518.0
2019-12-20 11:00:00	SPY	ETF	320.9	321.22	320.88	321.11	5165717.0
2019-12-20 11:30:00	SPY	ETF	321.11	321.37	321.11	321.155	4960620.0
2019-12-20 12:00:00	SPY	ETF	321.15	321.17	321.0	321.167	4390179.0
2019-12-20 12:30:00	SPY	ETF	321.1699	321.25	321.085	321.13	2391120.0
2019-12-20 13:00:00	SPY	ETF	321.13	321.27	321.12	321.16	2235578.0
2019-12-20 13:30:00	SPY	ETF	321.165	321.2	321.06	321.0885	1850290.0
2019-12-20 14:00:00	SPY	ETF	321.09	321.9517	320.96	321.05	5186559.0
2019-12-20 14:30:00	SPY	ETF	321.06	321.45	321.01	321.36	6819735.0
2019-12-20 15:00:00	SPY	ETF	321.36	321.37	321.14	321.1668	6263118.0
2019-12-20 15:30:00	SPY	ETF	321.17	321.26	320.84	320.95	13395049.0
2019-12-20 16:00:00	SPY	ETF	320.95	321.26	320.73	321.1	21142321.0
2019-12-20 16:30:00	SPY	ETF	321.1	321.1	320.73	321.0	3044955.0
2019-12-20 17:00:00	SPY	ETF	321.01	321.03	320.93	320.97	275108.0
2019-12-20 17:30:00	SPY	ETF	320.97	321.14	320.73	321.12	3251250.0
2019-12-20 18:00:00	SPY	ETF	321.14	321.22	321.03	321.22	57190.0
2019-12-20 18:30:00	SPY	ETF	321.24	321.28	321.1	321.1	19431.0
2019-12-20 19:00:00	SPY	ETF	321.15	321.16	321.12	321.15	3783.0
2019-12-20 19:30:00	SPY	ETF	321.15	321.3	321.12	321.3	22918.0
2019-12-20 04:00:00	QQQ	ETF	210.8	210.96	210.8	210.9	22300.0
2019-12-20 04:30:00	QQQ	ETF	210.92	210.93	210.87	210.87	14500.0
2019-12-20 05:00:00	QQQ	ETF	210.9	210.92	210.9	210.9	3510.0
2019-12-20 05:30:00	QQQ	ETF	210.93	211.05	210.92	211.01	2921.0
2019-12-20 06:00:00	QQQ	ETF	211.09	211.26	211.09	211.12	14314.0
2019-12-20 06:30:00	QQQ	ETF	211.15	211.15	211.12	211.12	574.0
2019-12-20 07:00:00	QQQ	ETF	211.13	211.15	211.06	211.06	11205.0
2019-12-20 07:30:00	QQQ	ETF	211.07	211.32	211.07	211.31	17438.0
2019-12-20 08:00:00	QQQ	ETF	211.13	211.4	210.85	211.32	117232.0
2019-12-20 08:30:00	QQQ	ETF	211.34	211.55	211.3	211.5	95130.0
2019-12-20 09:00:00	QQQ	ETF	211.51	212.24	211.5	211.83	1036150.0
2019-12-20 09:30:00	QQQ	ETF	211.81	211.93	211.27	211.2902	4473347.0
2019-12-20 10:00:00	QQQ	ETF	211.31	211.68	211.3	211.65	1578317.0
2019-12-20 10:30:00	QQQ	ETF	211.65	211.71	211.52	211.6	729348.0
2019-12-20 11:00:00	QQQ	ETF	211.59	211.84	211.585	211.75	1389750.0
2019-12-20 11:30:00	QQQ	ETF	211.75	211.92	211.75	211.78	906439.0
2019-12-20 12:00:00	QQQ	ETF	211.77	211.855	211.74	211.85	559531.0
2019-12-20 12:30:00	QQQ	ETF	211.86	211.95	211.84	211.89	586172.0

> showing 50 of 18,526 rows — these rows as CSV

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