PREVIEW / etf_30min / 2021-06-23

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-06-23.parquet
  size:    587 KB
  rows:    22,595

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
2021-06-23 04:00:00	SPY	ETF	423.32	423.6	423.32	423.56	2610.0
2021-06-23 04:30:00	SPY	ETF	423.4	423.52	423.28	423.4	8381.0
2021-06-23 05:00:00	SPY	ETF	423.4	423.4	423.03	423.25	9962.0
2021-06-23 05:30:00	SPY	ETF	423.21	423.44	423.21	423.31	9882.0
2021-06-23 06:00:00	SPY	ETF	423.23	423.55	423.07	423.49	11072.0
2021-06-23 06:30:00	SPY	ETF	423.44	423.44	423.06	423.06	3985.0
2021-06-23 07:00:00	SPY	ETF	423.2	423.21	422.5	422.73	79875.0
2021-06-23 07:30:00	SPY	ETF	422.71	423.17	422.7	423.11	34470.0
2021-06-23 08:00:00	SPY	ETF	423.07	423.97	422.54	423.47	218979.0
2021-06-23 08:30:00	SPY	ETF	423.52	423.61	423.39	423.57	53257.0
2021-06-23 09:00:00	SPY	ETF	423.57	423.59	423.15	423.19	142639.0
2021-06-23 09:30:00	SPY	ETF	423.19	423.8	423.05	423.64	4889990.0
2021-06-23 10:00:00	SPY	ETF	423.64	424.05	423.28	423.655	3446702.0
2021-06-23 10:30:00	SPY	ETF	423.67	423.71	423.26	423.58	2079651.0
2021-06-23 11:00:00	SPY	ETF	423.58	423.71	422.93	423.21	2302195.0
2021-06-23 11:30:00	SPY	ETF	423.22	423.37	422.92	423.3	1354028.0
2021-06-23 12:00:00	SPY	ETF	423.29	423.46	423.2	423.39	1293528.0
2021-06-23 12:30:00	SPY	ETF	423.385	423.3899	422.69	423.145	1743731.0
2021-06-23 13:00:00	SPY	ETF	423.16	423.59	423.07	423.535	1327818.0
2021-06-23 13:30:00	SPY	ETF	423.54	423.6	423.37	423.56	1295191.0
2021-06-23 14:00:00	SPY	ETF	423.56	423.5681	423.215	423.248	1756203.0
2021-06-23 14:30:00	SPY	ETF	423.25	423.435	423.18	423.37	1167645.0
2021-06-23 15:00:00	SPY	ETF	423.37	423.82	423.19	423.71	1631008.0
2021-06-23 15:30:00	SPY	ETF	423.7	423.73	422.51	422.6	8499363.0
2021-06-23 16:00:00	SPY	ETF	422.61	422.9	422.5749	422.77	3267991.0
2021-06-23 16:30:00	SPY	ETF	422.76	422.84	422.6	422.82	233492.0
2021-06-23 17:00:00	SPY	ETF	422.96	422.96	422.7	422.78	32413.0
2021-06-23 17:30:00	SPY	ETF	422.8	422.9	422.78	422.85	19168.0
2021-06-23 18:00:00	SPY	ETF	422.84	422.98	422.7	422.9	27993.0
2021-06-23 18:30:00	SPY	ETF	422.6	423.06	422.6	423.04	25777.0
2021-06-23 19:00:00	SPY	ETF	423.01	423.15	422.97	423.13	11864.0
2021-06-23 19:30:00	SPY	ETF	423.13	423.15	423.06	423.11	46109.0
2021-06-23 04:00:00	QQQ	ETF	347.78	347.93	347.7	347.79	9094.0
2021-06-23 04:30:00	QQQ	ETF	347.76	347.89	347.54	347.6	8582.0
2021-06-23 05:00:00	QQQ	ETF	347.68	347.78	347.4	347.66	6673.0
2021-06-23 05:30:00	QQQ	ETF	347.72	347.86	347.69	347.7	8422.0
2021-06-23 06:00:00	QQQ	ETF	347.7	348.06	347.58	348.04	9935.0
2021-06-23 06:30:00	QQQ	ETF	348.03	348.04	347.76	347.78	8969.0
2021-06-23 07:00:00	QQQ	ETF	347.79	347.82	347.08	347.24	176335.0
2021-06-23 07:30:00	QQQ	ETF	347.24	347.77	347.17	347.63	59315.0
2021-06-23 08:00:00	QQQ	ETF	347.6204	348.59	347.13	347.84	90865.0
2021-06-23 08:30:00	QQQ	ETF	347.88	347.89	347.61	347.81	93367.0
2021-06-23 09:00:00	QQQ	ETF	347.88	347.92	347.42	347.51	149554.0
2021-06-23 09:30:00	QQQ	ETF	347.51	348.83	347.43	348.69	3422722.0
2021-06-23 10:00:00	QQQ	ETF	348.69	348.92	348.34	348.56	1867835.0
2021-06-23 10:30:00	QQQ	ETF	348.57	348.57	347.7	347.98	1816688.0
2021-06-23 11:00:00	QQQ	ETF	347.98	348.1	347.34	347.83	1680225.0
2021-06-23 11:30:00	QQQ	ETF	347.83	348.27	347.54	348.19	926412.0
2021-06-23 12:00:00	QQQ	ETF	348.1907	348.31	347.87	347.979	703152.0
2021-06-23 12:30:00	QQQ	ETF	347.97	347.99	346.88	347.59	1740781.0

> showing 50 of 22,595 rows — these rows as CSV

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