PREVIEW / etf_30min / 2021-04-29

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-04-29.parquet
  size:    613 KB
  rows:    23,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
2021-04-29 04:00:00	SPY	ETF	419.76	420.25	419.76	419.9	8354.0
2021-04-29 04:30:00	SPY	ETF	419.83	420.0	419.81	419.98	5583.0
2021-04-29 05:00:00	SPY	ETF	419.93	419.93	419.8	419.91	3498.0
2021-04-29 05:30:00	SPY	ETF	419.91	420.04	419.88	419.99	9153.0
2021-04-29 06:00:00	SPY	ETF	420.06	420.26	420.0	420.25	15531.0
2021-04-29 06:30:00	SPY	ETF	420.29	420.36	420.07	420.07	11342.0
2021-04-29 07:00:00	SPY	ETF	420.05	420.29	420.03	420.05	42100.0
2021-04-29 07:30:00	SPY	ETF	420.05	420.19	419.92	419.92	130376.0
2021-04-29 08:00:00	SPY	ETF	420.1999	420.29	418.8	420.17	249783.0
2021-04-29 08:30:00	SPY	ETF	420.2	420.44	420.12	420.4	208055.0
2021-04-29 09:00:00	SPY	ETF	420.4	420.45	419.97	420.32	250242.0
2021-04-29 09:30:00	SPY	ETF	420.33	420.72	419.49	419.57	7069917.0
2021-04-29 10:00:00	SPY	ETF	419.56	419.57	418.67	418.92	5363695.0
2021-04-29 10:30:00	SPY	ETF	418.93	418.97	417.54	418.27	5821433.0
2021-04-29 11:00:00	SPY	ETF	418.26	418.87	418.08	418.46	2857658.0
2021-04-29 11:30:00	SPY	ETF	418.48	418.49	417.387	417.5499	3339001.0
2021-04-29 12:00:00	SPY	ETF	417.54	417.63	416.44	417.135	5529851.0
2021-04-29 12:30:00	SPY	ETF	417.135	418.25	416.86	418.115	2665213.0
2021-04-29 13:00:00	SPY	ETF	418.12	418.53	417.78	418.465	2390313.0
2021-04-29 13:30:00	SPY	ETF	418.48	418.81	418.13	418.615	2184714.0
2021-04-29 14:00:00	SPY	ETF	418.6	419.39	418.55	419.29	2348448.0
2021-04-29 14:30:00	SPY	ETF	419.29	420.49	419.29	420.01	5020497.0
2021-04-29 15:00:00	SPY	ETF	420.02	420.45	419.57	419.58	4319881.0
2021-04-29 15:30:00	SPY	ETF	419.58	420.29	419.51	420.0	9041069.0
2021-04-29 16:00:00	SPY	ETF	419.99	420.11	417.1366	419.5	3618503.0
2021-04-29 16:30:00	SPY	ETF	419.55	419.67	419.49	419.65	295503.0
2021-04-29 17:00:00	SPY	ETF	419.65	419.71	419.62	419.67	56729.0
2021-04-29 17:30:00	SPY	ETF	419.67	419.73	419.64	419.64	6804.0
2021-04-29 18:00:00	SPY	ETF	419.71	419.72	419.43	419.58	90343.0
2021-04-29 18:30:00	SPY	ETF	420.06	420.06	419.36	419.49	30901.0
2021-04-29 19:00:00	SPY	ETF	419.5	419.66	419.46	419.6	109279.0
2021-04-29 19:30:00	SPY	ETF	419.6	419.61	419.06	419.35	69500.0
2021-04-29 04:00:00	QQQ	ETF	340.72	342.21	340.72	341.98	29844.0
2021-04-29 04:30:00	QQQ	ETF	341.97	342.12	341.85	342.12	12476.0
2021-04-29 05:00:00	QQQ	ETF	342.05	342.11	341.85	341.92	67895.0
2021-04-29 05:30:00	QQQ	ETF	341.92	342.0	341.84	341.86	24539.0
2021-04-29 06:00:00	QQQ	ETF	341.86	342.09	341.74	342.06	39227.0
2021-04-29 06:30:00	QQQ	ETF	342.09	342.13	341.92	341.92	30406.0
2021-04-29 07:00:00	QQQ	ETF	341.92	342.47	341.87	342.28	167444.0
2021-04-29 07:30:00	QQQ	ETF	342.33	342.37	342.05	342.09	125178.0
2021-04-29 08:00:00	QQQ	ETF	342.06	342.47	341.25	342.11	208429.0
2021-04-29 08:30:00	QQQ	ETF	342.15	342.88	342.08	342.62	154342.0
2021-04-29 09:00:00	QQQ	ETF	342.621	342.621	342.11	342.33	364350.0
2021-04-29 09:30:00	QQQ	ETF	342.35	342.8	340.1	340.5	5203727.0
2021-04-29 10:00:00	QQQ	ETF	340.5	340.54	339.42	339.95	2890542.0
2021-04-29 10:30:00	QQQ	ETF	339.96	340.002	338.47	339.53	3326555.0
2021-04-29 11:00:00	QQQ	ETF	339.53	339.94	339.16	339.52	1305263.0
2021-04-29 11:30:00	QQQ	ETF	339.54	339.55	337.61	337.98	1701227.0
2021-04-29 12:00:00	QQQ	ETF	337.955	338.03	336.9001	337.6598	2636933.0
2021-04-29 12:30:00	QQQ	ETF	337.63	338.65	337.335	338.49	1531457.0

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

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