PREVIEW / etf_30min / 2021-03-23

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-03-23.parquet
  size:    630 KB
  rows:    23,682

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-03-23 04:00:00	SPY	ETF	391.78	391.78	390.95	391.46	20125.0
2021-03-23 04:30:00	SPY	ETF	391.43	391.67	391.1	391.63	20448.0
2021-03-23 05:00:00	SPY	ETF	391.6	391.72	390.93	390.95	22069.0
2021-03-23 05:30:00	SPY	ETF	390.93	391.08	390.79	390.82	114095.0
2021-03-23 06:00:00	SPY	ETF	390.72	391.08	390.4	390.7	73189.0
2021-03-23 06:30:00	SPY	ETF	390.64	391.11	390.53	391.09	111494.0
2021-03-23 07:00:00	SPY	ETF	391.1	391.54	390.85	391.34	121158.0
2021-03-23 07:30:00	SPY	ETF	391.42	391.65	391.17	391.17	157493.0
2021-03-23 08:00:00	SPY	ETF	391.1201	392.0	390.81	391.3	99178.0
2021-03-23 08:30:00	SPY	ETF	391.31	391.76	391.2	391.7	126882.0
2021-03-23 09:00:00	SPY	ETF	391.73	391.89	391.56	391.89	162296.0
2021-03-23 09:30:00	SPY	ETF	391.9	392.445	391.56	392.44	5177841.0
2021-03-23 10:00:00	SPY	ETF	392.44	393.0	392.24	392.675	3660591.0
2021-03-23 10:30:00	SPY	ETF	392.6842	392.76	391.24	392.3467	5229077.0
2021-03-23 11:00:00	SPY	ETF	392.35	393.42	392.18	393.3189	3329487.0
2021-03-23 11:30:00	SPY	ETF	393.32	393.46	392.37	392.83	3388986.0
2021-03-23 12:00:00	SPY	ETF	392.869	393.35	392.06	392.575	3876998.0
2021-03-23 12:30:00	SPY	ETF	392.59	392.97	392.2	392.968	2055399.0
2021-03-23 13:00:00	SPY	ETF	392.95	393.31	392.82	392.98	2096931.0
2021-03-23 13:30:00	SPY	ETF	392.99	393.029	391.63	391.85	3222428.0
2021-03-23 14:00:00	SPY	ETF	391.855	392.1919	391.47	392.09	3873018.0
2021-03-23 14:30:00	SPY	ETF	392.085	392.245	390.46	390.49	4359394.0
2021-03-23 15:00:00	SPY	ETF	390.49	390.95	389.02	389.39	7541102.0
2021-03-23 15:30:00	SPY	ETF	389.39	389.7819	388.66	389.51	16528339.0
2021-03-23 16:00:00	SPY	ETF	389.51	390.17	389.5	389.95	3172747.0
2021-03-23 16:30:00	SPY	ETF	389.97	390.07	389.562	389.98	210770.0
2021-03-23 17:00:00	SPY	ETF	390.07	390.07	389.77	389.95	56640.0
2021-03-23 17:30:00	SPY	ETF	389.94	390.24	389.9	390.19	47993.0
2021-03-23 18:00:00	SPY	ETF	390.11	390.11	389.47	389.55	81344.0
2021-03-23 18:30:00	SPY	ETF	389.5	389.99	389.5	389.8	39891.0
2021-03-23 19:00:00	SPY	ETF	389.8	389.8	389.33	389.44	16766.0
2021-03-23 19:30:00	SPY	ETF	389.47	389.54	389.15	389.43	237457.0
2021-03-23 04:00:00	QQQ	ETF	318.1	318.25	317.35	317.75	57658.0
2021-03-23 04:30:00	QQQ	ETF	317.62	318.28	317.5	318.26	20969.0
2021-03-23 05:00:00	QQQ	ETF	318.12	318.49	317.57	317.57	15963.0
2021-03-23 05:30:00	QQQ	ETF	317.46	317.86	317.37	317.83	32989.0
2021-03-23 06:00:00	QQQ	ETF	317.65	318.39	317.4	317.74	45453.0
2021-03-23 06:30:00	QQQ	ETF	317.74	318.3	317.67	318.16	41065.0
2021-03-23 07:00:00	QQQ	ETF	318.23	319.12	318.2	319.0	177658.0
2021-03-23 07:30:00	QQQ	ETF	319.02	319.16	318.83	318.88	196298.0
2021-03-23 08:00:00	QQQ	ETF	318.24	319.14	317.05	318.94	212767.0
2021-03-23 08:30:00	QQQ	ETF	318.9	319.76	318.89	319.57	199504.0
2021-03-23 09:00:00	QQQ	ETF	319.6	319.86	319.35	319.75	300801.0
2021-03-23 09:30:00	QQQ	ETF	319.75	319.86	318.18	318.88	5508180.0
2021-03-23 10:00:00	QQQ	ETF	318.81	320.185	318.525	319.49	3510533.0
2021-03-23 10:30:00	QQQ	ETF	319.51	319.97	318.17	319.96	3529778.0
2021-03-23 11:00:00	QQQ	ETF	319.96	321.09	319.645	320.585	3295716.0
2021-03-23 11:30:00	QQQ	ETF	320.585	320.88	319.335	319.7	2778978.0
2021-03-23 12:00:00	QQQ	ETF	319.71	320.28	318.5	319.28	2991566.0
2021-03-23 12:30:00	QQQ	ETF	319.29	319.86	318.84	319.86	1823112.0

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

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