PREVIEW / etf_30min / 2021-11-29

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-11-29.parquet
  size:    661 KB
  rows:    25,965

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-11-29 04:00:00	SPY	ETF	461.01	463.05	457.03	462.43	116305.0
2021-11-29 04:30:00	SPY	ETF	462.3	462.4	461.58	461.59	54002.0
2021-11-29 05:00:00	SPY	ETF	461.65	462.84	461.65	462.78	145852.0
2021-11-29 05:30:00	SPY	ETF	462.78	463.19	462.52	463.07	33007.0
2021-11-29 06:00:00	SPY	ETF	463.08	463.4	463.06	463.15	107063.0
2021-11-29 06:30:00	SPY	ETF	463.23	463.24	462.67	462.67	37324.0
2021-11-29 07:00:00	SPY	ETF	462.71	462.75	462.11	462.12	238280.0
2021-11-29 07:30:00	SPY	ETF	462.12	462.96	462.06	462.89	191811.0
2021-11-29 08:00:00	SPY	ETF	462.88	463.5	462.1	462.65	312094.0
2021-11-29 08:30:00	SPY	ETF	462.71	464.2	462.7	463.97	553329.0
2021-11-29 09:00:00	SPY	ETF	463.99	464.5	463.85	464.09	441285.0
2021-11-29 09:30:00	SPY	ETF	464.07	464.6	462.47	463.52	9334755.0
2021-11-29 10:00:00	SPY	ETF	463.51	463.82	462.59	462.6	5391154.0
2021-11-29 10:30:00	SPY	ETF	462.6	463.0872	461.73	462.57	3660348.0
2021-11-29 11:00:00	SPY	ETF	462.6	463.5399	462.26	463.06	3531497.0
2021-11-29 11:30:00	SPY	ETF	463.05	464.52	463.03	464.48	3181841.0
2021-11-29 12:00:00	SPY	ETF	464.49	465.79	464.47	465.67	3292032.0
2021-11-29 12:30:00	SPY	ETF	465.66	466.31	465.63	466.13	2599327.0
2021-11-29 13:00:00	SPY	ETF	466.14	466.56	465.75	466.0488	1997597.0
2021-11-29 13:30:00	SPY	ETF	466.04	466.325	465.61	466.24	2113384.0
2021-11-29 14:00:00	SPY	ETF	466.25	466.29	465.82	465.89	1290103.0
2021-11-29 14:30:00	SPY	ETF	465.91	466.06	465.42	465.6901	2545487.0
2021-11-29 15:00:00	SPY	ETF	465.69	466.37	465.465	465.76	3292703.0
2021-11-29 15:30:00	SPY	ETF	465.75	465.99	464.34	464.63	12092965.0
2021-11-29 16:00:00	SPY	ETF	464.63	465.5864	464.51	464.98	5910033.0
2021-11-29 16:30:00	SPY	ETF	465.0	465.32	464.6	465.14	683763.0
2021-11-29 17:00:00	SPY	ETF	465.15	465.16	465.0	465.15	200633.0
2021-11-29 17:30:00	SPY	ETF	465.12	465.38	465.08	465.38	310559.0
2021-11-29 18:00:00	SPY	ETF	465.32	466.04	464.6	465.86	519472.0
2021-11-29 18:30:00	SPY	ETF	464.6	466.06	464.6	465.85	44527.0
2021-11-29 19:00:00	SPY	ETF	465.84	465.99	465.69	465.91	27070.0
2021-11-29 19:30:00	SPY	ETF	465.91	466.24	465.89	466.12	45640.0
2021-11-29 04:00:00	QQQ	ETF	392.83	395.53	392.83	395.02	83086.0
2021-11-29 04:30:00	QQQ	ETF	395.09	395.1	394.23	394.23	12840.0
2021-11-29 05:00:00	QQQ	ETF	394.3	395.2	394.3	395.15	69593.0
2021-11-29 05:30:00	QQQ	ETF	394.93	395.35	394.78	395.35	22443.0
2021-11-29 06:00:00	QQQ	ETF	395.2	395.53	395.13	395.42	43713.0
2021-11-29 06:30:00	QQQ	ETF	395.36	395.36	394.87	395.01	23411.0
2021-11-29 07:00:00	QQQ	ETF	394.84	394.93	394.4	394.4	69471.0
2021-11-29 07:30:00	QQQ	ETF	394.36	395.12	394.35	395.12	42553.0
2021-11-29 08:00:00	QQQ	ETF	394.7999	396.0	394.2996	394.77	142170.0
2021-11-29 08:30:00	QQQ	ETF	394.8	395.95	394.8	395.83	432707.0
2021-11-29 09:00:00	QQQ	ETF	395.84	396.3	395.79	395.86	392679.0
2021-11-29 09:30:00	QQQ	ETF	395.86	397.52	395.14	397.33	7246047.0
2021-11-29 10:00:00	QQQ	ETF	397.33	397.72	396.46	396.49	3938855.0
2021-11-29 10:30:00	QQQ	ETF	396.465	396.99	395.61	396.8	3039968.0
2021-11-29 11:00:00	QQQ	ETF	396.8	397.809	396.4401	397.14	2497319.0
2021-11-29 11:30:00	QQQ	ETF	397.12	398.76	397.12	398.66	2391577.0
2021-11-29 12:00:00	QQQ	ETF	398.7	399.53	398.54	399.42	1988014.0
2021-11-29 12:30:00	QQQ	ETF	399.43	399.98	399.32	399.77	1727717.0

> showing 50 of 25,965 rows — these rows as CSV

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