PREVIEW / etf_30min / 2020-06-12

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-06-12.parquet
  size:    566 KB
  rows:    21,385

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
2020-06-12 04:00:00	SPY	ETF	304.43	306.04	304.43	305.9	163599.0
2020-06-12 04:30:00	SPY	ETF	305.9	307.09	305.83	306.72	212555.0
2020-06-12 05:00:00	SPY	ETF	306.81	307.05	306.4	306.87	336817.0
2020-06-12 05:30:00	SPY	ETF	306.87	307.39	306.44	307.32	361332.0
2020-06-12 06:00:00	SPY	ETF	307.26	307.6	307.0	307.03	186122.0
2020-06-12 06:30:00	SPY	ETF	307.02	307.07	305.9	306.61	361540.0
2020-06-12 07:00:00	SPY	ETF	306.61	307.42	306.6	306.94	464851.0
2020-06-12 07:30:00	SPY	ETF	306.98	307.05	306.1	306.1	601594.0
2020-06-12 08:00:00	SPY	ETF	306.08	307.54	303.0	306.21	981872.0
2020-06-12 08:30:00	SPY	ETF	306.25	307.66	306.21	307.2	1051550.0
2020-06-12 09:00:00	SPY	ETF	307.21	308.57	307.12	308.23	1193860.0
2020-06-12 09:30:00	SPY	ETF	308.24	309.08	307.06	307.63	14799608.0
2020-06-12 10:00:00	SPY	ETF	307.63	308.42	306.06	306.07	9607870.0
2020-06-12 10:30:00	SPY	ETF	306.09	306.51	302.67	302.68	14577574.0
2020-06-12 11:00:00	SPY	ETF	302.67	303.73	300.46	302.38	17113607.0
2020-06-12 11:30:00	SPY	ETF	302.38	305.279	301.82	305.22	11625727.0
2020-06-12 12:00:00	SPY	ETF	305.21	305.89	303.84	304.31	7504037.0
2020-06-12 12:30:00	SPY	ETF	304.3	304.4	302.59	303.79	8002727.0
2020-06-12 13:00:00	SPY	ETF	303.81	304.01	301.47	301.85	6429688.0
2020-06-12 13:30:00	SPY	ETF	301.86	302.23	298.74	298.88	14212426.0
2020-06-12 14:00:00	SPY	ETF	298.88	301.29	298.6	301.08	13683092.0
2020-06-12 14:30:00	SPY	ETF	301.14	302.68	300.35	302.095	10417772.0
2020-06-12 15:00:00	SPY	ETF	302.09	303.73	301.06	301.705	13259555.0
2020-06-12 15:30:00	SPY	ETF	301.71	305.07	301.16	304.28	27268929.0
2020-06-12 16:00:00	SPY	ETF	304.26	307.2	303.45	303.99	16653782.0
2020-06-12 16:30:00	SPY	ETF	303.99	304.3688	300.4668	303.93	899625.0
2020-06-12 17:00:00	SPY	ETF	303.94	303.97	303.21	303.73	854591.0
2020-06-12 17:30:00	SPY	ETF	303.64	304.21	303.63	303.96	52626.0
2020-06-12 18:00:00	SPY	ETF	303.96	304.21	303.81	303.96	112735.0
2020-06-12 18:30:00	SPY	ETF	304.0	304.04	303.72	303.75	34739.0
2020-06-12 19:00:00	SPY	ETF	303.75	303.8	303.62	303.8	30133.0
2020-06-12 19:30:00	SPY	ETF	303.8	303.85	303.57	303.58	42717.0
2020-06-12 04:00:00	QQQ	ETF	237.04	238.13	236.94	238.13	37564.0
2020-06-12 04:30:00	QQQ	ETF	238.11	238.6	237.97	238.4	40883.0
2020-06-12 05:00:00	QQQ	ETF	238.1	238.64	237.98	238.38	49666.0
2020-06-12 05:30:00	QQQ	ETF	238.36	238.86	237.99	238.83	32024.0
2020-06-12 06:00:00	QQQ	ETF	238.84	239.0	238.42	238.43	84411.0
2020-06-12 06:30:00	QQQ	ETF	238.42	238.43	237.73	238.17	57998.0
2020-06-12 07:00:00	QQQ	ETF	238.17	238.6	238.09	238.6	115544.0
2020-06-12 07:30:00	QQQ	ETF	238.55	238.64	238.0	238.0	101870.0
2020-06-12 08:00:00	QQQ	ETF	238.0	238.9796	236.39	237.55	327656.0
2020-06-12 08:30:00	QQQ	ETF	237.66	238.33	237.59	238.14	160268.0
2020-06-12 09:00:00	QQQ	ETF	238.17	239.15	238.1402	239.09	296066.0
2020-06-12 09:30:00	QQQ	ETF	239.11	240.4	238.62	239.46	6463491.0
2020-06-12 10:00:00	QQQ	ETF	239.47	239.9133	238.06	238.08	3840093.0
2020-06-12 10:30:00	QQQ	ETF	238.081	238.44	235.36	235.3861	4709894.0
2020-06-12 11:00:00	QQQ	ETF	235.36	236.025	233.54	234.9894	6256167.0
2020-06-12 11:30:00	QQQ	ETF	234.99	237.22	234.516	237.17	3899900.0
2020-06-12 12:00:00	QQQ	ETF	237.16	237.65	236.04	236.46	2348106.0
2020-06-12 12:30:00	QQQ	ETF	236.44	236.5	235.04	236.04	3007376.0

> showing 50 of 21,385 rows — these rows as CSV

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