PREVIEW / etf_30min / 2021-04-14

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-04-14.parquet
  size:    617 KB
  rows:    23,574

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-04-14 04:00:00	SPY	ETF	412.94	413.35	412.94	413.23	14088.0
2021-04-14 04:30:00	SPY	ETF	413.38	413.42	413.34	413.36	2100.0
2021-04-14 05:00:00	SPY	ETF	413.36	413.38	413.3	413.31	2478.0
2021-04-14 05:30:00	SPY	ETF	413.34	413.39	413.31	413.39	5595.0
2021-04-14 06:00:00	SPY	ETF	413.17	413.24	413.05	413.06	53726.0
2021-04-14 06:30:00	SPY	ETF	413.11	413.31	412.97	413.03	95242.0
2021-04-14 07:00:00	SPY	ETF	413.03	413.34	413.0	413.32	32013.0
2021-04-14 07:30:00	SPY	ETF	413.32	413.44	413.25	413.38	204349.0
2021-04-14 08:00:00	SPY	ETF	413.2799	413.44	412.76	413.23	55880.0
2021-04-14 08:30:00	SPY	ETF	413.21	413.23	412.65	412.74	93046.0
2021-04-14 09:00:00	SPY	ETF	412.74	412.88	412.59	412.85	223761.0
2021-04-14 09:30:00	SPY	ETF	412.83	413.83	412.55	413.83	5219786.0
2021-04-14 10:00:00	SPY	ETF	413.82	413.83	413.19	413.305	2786945.0
2021-04-14 10:30:00	SPY	ETF	413.3	413.96	413.29	413.41	3070390.0
2021-04-14 11:00:00	SPY	ETF	413.4	413.57	412.73	413.1509	2597448.0
2021-04-14 11:30:00	SPY	ETF	413.15	413.43	413.001	413.415	1517731.0
2021-04-14 12:00:00	SPY	ETF	413.4194	413.45	412.8899	413.095	2003576.0
2021-04-14 12:30:00	SPY	ETF	413.095	413.57	413.06	413.445	1121634.0
2021-04-14 13:00:00	SPY	ETF	413.45	413.48	413.12	413.28	1145027.0
2021-04-14 13:30:00	SPY	ETF	413.29	413.29	411.83	412.11	2849097.0
2021-04-14 14:00:00	SPY	ETF	412.11	412.59	411.19	412.385	6306564.0
2021-04-14 14:30:00	SPY	ETF	412.38	412.47	411.25	411.35	3227672.0
2021-04-14 15:00:00	SPY	ETF	411.33	411.97	410.88	411.945	4694111.0
2021-04-14 15:30:00	SPY	ETF	411.95	412.12	410.87	411.49	10744624.0
2021-04-14 16:00:00	SPY	ETF	411.48	411.94	411.45	411.76	2157579.0
2021-04-14 16:30:00	SPY	ETF	411.74	411.97	411.72	411.82	96068.0
2021-04-14 17:00:00	SPY	ETF	411.78	411.95	411.45	411.9	43574.0
2021-04-14 17:30:00	SPY	ETF	411.85	411.94	411.81	411.94	18677.0
2021-04-14 18:00:00	SPY	ETF	411.9	412.16	411.8	412.16	51069.0
2021-04-14 18:30:00	SPY	ETF	411.45	412.2	411.45	411.96	34868.0
2021-04-14 19:00:00	SPY	ETF	412.02	412.02	411.91	411.97	12380.0
2021-04-14 19:30:00	SPY	ETF	411.93	411.95	411.73	411.82	83897.0
2021-04-14 04:00:00	QQQ	ETF	340.61	341.17	340.6	341.0	45115.0
2021-04-14 04:30:00	QQQ	ETF	341.12	341.31	341.12	341.23	16693.0
2021-04-14 05:00:00	QQQ	ETF	341.23	341.42	341.12	341.16	16946.0
2021-04-14 05:30:00	QQQ	ETF	341.17	341.4	341.17	341.28	24390.0
2021-04-14 06:00:00	QQQ	ETF	341.23	341.26	341.1	341.17	30520.0
2021-04-14 06:30:00	QQQ	ETF	341.18	341.27	341.13	341.25	23058.0
2021-04-14 07:00:00	QQQ	ETF	341.22	341.68	341.22	341.6	45012.0
2021-04-14 07:30:00	QQQ	ETF	341.62	341.95	341.51	341.85	101005.0
2021-04-14 08:00:00	QQQ	ETF	341.22	341.96	340.36	341.71	94573.0
2021-04-14 08:30:00	QQQ	ETF	341.62	341.85	341.341	341.38	111343.0
2021-04-14 09:00:00	QQQ	ETF	341.32	341.38	340.84	340.84	143369.0
2021-04-14 09:30:00	QQQ	ETF	340.85	340.98	339.87	340.63	3861210.0
2021-04-14 10:00:00	QQQ	ETF	340.62	340.63	339.21	339.32	2750538.0
2021-04-14 10:30:00	QQQ	ETF	339.33	340.21	339.11	339.2	2546381.0
2021-04-14 11:00:00	QQQ	ETF	339.19	339.54	337.7	338.33	3101190.0
2021-04-14 11:30:00	QQQ	ETF	338.32	338.975	337.99	338.97	1573938.0
2021-04-14 12:00:00	QQQ	ETF	338.965	339.04	338.11	338.57	1450085.0
2021-04-14 12:30:00	QQQ	ETF	338.51	339.23	338.5	339.08	851556.0

> showing 50 of 23,574 rows — these rows as CSV

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