PREVIEW / etf_30min / 2021-01-12

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-01-12.parquet
  size:    625 KB
  rows:    23,311

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-01-12 04:00:00	SPY	ETF	379.29	379.87	379.2	379.69	20891.0
2021-01-12 04:30:00	SPY	ETF	379.75	380.2	379.64	379.82	16039.0
2021-01-12 05:00:00	SPY	ETF	379.94	379.94	379.67	379.85	5917.0
2021-01-12 05:30:00	SPY	ETF	379.85	379.92	379.66	379.7	4616.0
2021-01-12 06:00:00	SPY	ETF	379.7	379.79	379.43	379.79	10280.0
2021-01-12 06:30:00	SPY	ETF	379.83	379.83	379.59	379.67	5333.0
2021-01-12 07:00:00	SPY	ETF	379.58	379.97	379.49	379.9	55789.0
2021-01-12 07:30:00	SPY	ETF	379.92	379.97	379.62	379.68	54106.0
2021-01-12 08:00:00	SPY	ETF	379.69	379.93	378.58	379.31	151571.0
2021-01-12 08:30:00	SPY	ETF	379.35	379.52	378.2	378.66	167386.0
2021-01-12 09:00:00	SPY	ETF	378.55	379.04	378.36	378.85	228187.0
2021-01-12 09:30:00	SPY	ETF	378.89	379.29	377.75	378.82	5028882.0
2021-01-12 10:00:00	SPY	ETF	378.82	379.73	378.28	379.3	2980757.0
2021-01-12 10:30:00	SPY	ETF	379.3	379.53	378.85	379.1393	2828089.0
2021-01-12 11:00:00	SPY	ETF	379.14	379.86	378.8	378.9701	2114773.0
2021-01-12 11:30:00	SPY	ETF	378.97	379.04	377.85	378.29	2537492.0
2021-01-12 12:00:00	SPY	ETF	378.28	378.33	376.36	377.51	4938799.0
2021-01-12 12:30:00	SPY	ETF	377.5	378.0878	377.01	378.01	2667459.0
2021-01-12 13:00:00	SPY	ETF	378.02	378.55	377.77	378.51	2180073.0
2021-01-12 13:30:00	SPY	ETF	378.53	379.16	378.4	378.8801	2241495.0
2021-01-12 14:00:00	SPY	ETF	378.895	379.46	378.78	378.81	2461812.0
2021-01-12 14:30:00	SPY	ETF	378.82	379.31	378.15	378.74	2982646.0
2021-01-12 15:00:00	SPY	ETF	378.745	379.21	378.58	378.7899	4380142.0
2021-01-12 15:30:00	SPY	ETF	378.78	379.5	378.59	378.81	8127584.0
2021-01-12 16:00:00	SPY	ETF	378.78	378.89	378.62	378.75	4509112.0
2021-01-12 16:30:00	SPY	ETF	378.77	379.1	378.64	378.81	401325.0
2021-01-12 17:00:00	SPY	ETF	378.66	378.98	378.66	378.72	396451.0
2021-01-12 17:30:00	SPY	ETF	378.73	378.92	378.63	378.78	38737.0
2021-01-12 18:00:00	SPY	ETF	378.78	379.14	378.59	379.07	38206.0
2021-01-12 18:30:00	SPY	ETF	379.07	379.12	378.8	379.05	31865.0
2021-01-12 19:00:00	SPY	ETF	379.07	379.35	379.05	379.26	17447.0
2021-01-12 19:30:00	SPY	ETF	379.22	379.23	378.95	379.01	26746.0
2021-01-12 04:00:00	QQQ	ETF	315.19	315.64	315.18	315.35	11643.0
2021-01-12 04:30:00	QQQ	ETF	315.41	315.77	315.36	315.63	13145.0
2021-01-12 05:00:00	QQQ	ETF	315.66	315.7	315.49	315.52	4326.0
2021-01-12 05:30:00	QQQ	ETF	315.46	315.6	315.27	315.55	13623.0
2021-01-12 06:00:00	QQQ	ETF	315.51	315.64	315.3	315.48	11109.0
2021-01-12 06:30:00	QQQ	ETF	315.51	315.51	315.27	315.38	18322.0
2021-01-12 07:00:00	QQQ	ETF	315.38	315.62	315.32	315.56	68191.0
2021-01-12 07:30:00	QQQ	ETF	315.63	315.63	315.41	315.51	66204.0
2021-01-12 08:00:00	QQQ	ETF	315.52	315.6298	314.42	314.8	144917.0
2021-01-12 08:30:00	QQQ	ETF	314.73	314.94	313.66	314.11	217416.0
2021-01-12 09:00:00	QQQ	ETF	314.05	314.6	313.9	314.48	253112.0
2021-01-12 09:30:00	QQQ	ETF	314.46	315.58	313.05	314.19	3124208.0
2021-01-12 10:00:00	QQQ	ETF	314.19	314.87	313.5828	314.3533	1850211.0
2021-01-12 10:30:00	QQQ	ETF	314.38	314.76	313.91	314.08	1451267.0
2021-01-12 11:00:00	QQQ	ETF	314.08	315.08	313.8	314.48	1131069.0
2021-01-12 11:30:00	QQQ	ETF	314.51	314.62	313.28	313.67	1082471.0
2021-01-12 12:00:00	QQQ	ETF	313.662	313.7874	311.2	312.35	3427083.0
2021-01-12 12:30:00	QQQ	ETF	312.34	313.15	311.91	313.1	1763701.0

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

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