PREVIEW / etf_30min / 2020-08-12

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-08-12.parquet
  size:    562 KB
  rows:    20,924

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-08-12 04:00:00	SPY	ETF	335.4	335.66	335.12	335.36	40843.0
2020-08-12 04:30:00	SPY	ETF	335.36	335.48	335.29	335.32	6586.0
2020-08-12 05:00:00	SPY	ETF	335.44	335.8	335.43	335.75	4755.0
2020-08-12 05:30:00	SPY	ETF	335.68	335.89	335.4	335.5	8740.0
2020-08-12 06:00:00	SPY	ETF	335.42	336.06	335.42	335.8	29680.0
2020-08-12 06:30:00	SPY	ETF	335.8	335.8	335.55	335.6	26482.0
2020-08-12 07:00:00	SPY	ETF	335.56	335.56	335.15	335.36	134704.0
2020-08-12 07:30:00	SPY	ETF	335.38	335.53	335.22	335.37	135869.0
2020-08-12 08:00:00	SPY	ETF	335.5	335.55	333.0	335.35	175642.0
2020-08-12 08:30:00	SPY	ETF	335.27	335.72	334.9	335.54	521044.0
2020-08-12 09:00:00	SPY	ETF	335.53	335.69	335.35	335.48	237270.0
2020-08-12 09:30:00	SPY	ETF	335.44	336.47	335.43	336.39	6079832.0
2020-08-12 10:00:00	SPY	ETF	336.39	337.16	336.12	337.11	3092718.0
2020-08-12 10:30:00	SPY	ETF	337.12	337.495	336.8735	337.265	2905790.0
2020-08-12 11:00:00	SPY	ETF	337.26	337.64	336.9066	337.176	2642359.0
2020-08-12 11:30:00	SPY	ETF	337.18	337.48	336.911	337.23	2277320.0
2020-08-12 12:00:00	SPY	ETF	337.23	337.81	337.2	337.65	2270722.0
2020-08-12 12:30:00	SPY	ETF	337.65	337.81	337.01	337.07	2997994.0
2020-08-12 13:00:00	SPY	ETF	337.07	337.3	336.56	336.67	2573273.0
2020-08-12 13:30:00	SPY	ETF	336.67	337.92	336.65	337.89	2725478.0
2020-08-12 14:00:00	SPY	ETF	337.88	337.98	337.61	337.73	2387339.0
2020-08-12 14:30:00	SPY	ETF	337.74	337.95	337.555	337.87	2554637.0
2020-08-12 15:00:00	SPY	ETF	337.87	338.28	337.69	338.055	4658458.0
2020-08-12 15:30:00	SPY	ETF	338.06	338.107	337.25	337.42	9108755.0
2020-08-12 16:00:00	SPY	ETF	337.41	337.4863	336.96	337.15	4142667.0
2020-08-12 16:30:00	SPY	ETF	337.17	337.44	336.9	337.01	256665.0
2020-08-12 17:00:00	SPY	ETF	336.95	337.44	336.9	336.99	104139.0
2020-08-12 17:30:00	SPY	ETF	337.0	337.04	336.91	336.92	34744.0
2020-08-12 18:00:00	SPY	ETF	336.88	337.19	336.69	337.07	64821.0
2020-08-12 18:30:00	SPY	ETF	337.08	337.14	337.06	337.06	7894.0
2020-08-12 19:00:00	SPY	ETF	337.03	337.13	336.93	337.13	8377.0
2020-08-12 19:30:00	SPY	ETF	337.07	337.22	337.03	337.11	26780.0
2020-08-12 04:00:00	QQQ	ETF	267.62	267.99	267.4	267.62	48157.0
2020-08-12 04:30:00	QQQ	ETF	267.62	267.75	267.5	267.61	13888.0
2020-08-12 05:00:00	QQQ	ETF	267.6	267.94	267.6	267.81	6882.0
2020-08-12 05:30:00	QQQ	ETF	268.02	268.02	267.59	267.69	7526.0
2020-08-12 06:00:00	QQQ	ETF	267.7	268.14	267.69	267.99	34604.0
2020-08-12 06:30:00	QQQ	ETF	267.95	268.12	267.92	267.94	11755.0
2020-08-12 07:00:00	QQQ	ETF	267.9	267.91	267.46	267.57	62610.0
2020-08-12 07:30:00	QQQ	ETF	267.62	268.0	267.33	267.45	72174.0
2020-08-12 08:00:00	QQQ	ETF	267.48	268.0204	266.07	267.52	113649.0
2020-08-12 08:30:00	QQQ	ETF	267.51	267.59	266.8	267.15	335712.0
2020-08-12 09:00:00	QQQ	ETF	267.11	267.39	266.83	267.35	317022.0
2020-08-12 09:30:00	QQQ	ETF	267.37	269.98	267.37	269.87	4645377.0
2020-08-12 10:00:00	QQQ	ETF	269.88	270.83	269.6	270.62	2730092.0
2020-08-12 10:30:00	QQQ	ETF	270.64	271.16	270.25	270.96	2520244.0
2020-08-12 11:00:00	QQQ	ETF	270.94	271.43	270.725	271.19	1531783.0
2020-08-12 11:30:00	QQQ	ETF	271.18	271.67	270.84	271.56	1213640.0
2020-08-12 12:00:00	QQQ	ETF	271.57	272.335	271.53	272.19	1754492.0
2020-08-12 12:30:00	QQQ	ETF	272.195	272.37	271.41	271.48	1529858.0

> showing 50 of 20,924 rows — these rows as CSV

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