PREVIEW / etf_30min / 2022-07-29

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-07-29.parquet
  size:    657 KB
  rows:    26,091

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
2022-07-29 04:00:00	SPY	ETF	408.71	409.2	408.71	409.1	43128.0
2022-07-29 04:30:00	SPY	ETF	409.0	409.06	408.35	408.55	9881.0
2022-07-29 05:00:00	SPY	ETF	408.5	408.7	408.34	408.7	63003.0
2022-07-29 05:30:00	SPY	ETF	408.83	409.14	408.81	409.14	7881.0
2022-07-29 06:00:00	SPY	ETF	409.17	409.2	408.85	408.93	45556.0
2022-07-29 06:30:00	SPY	ETF	408.95	409.37	408.95	409.16	43784.0
2022-07-29 07:00:00	SPY	ETF	409.16	409.26	408.54	408.55	65887.0
2022-07-29 07:30:00	SPY	ETF	408.63	408.7	408.39	408.57	31947.0
2022-07-29 08:00:00	SPY	ETF	409.14	409.5	408.01	408.01	223697.0
2022-07-29 08:30:00	SPY	ETF	408.01	408.35	407.3	407.97	387444.0
2022-07-29 09:00:00	SPY	ETF	408.0	408.0	407.17	407.62	418979.0
2022-07-29 09:30:00	SPY	ETF	407.58	409.47	406.77	409.18	5575691.0
2022-07-29 10:00:00	SPY	ETF	409.21	410.99	408.68	410.58	4774409.0
2022-07-29 10:30:00	SPY	ETF	410.58	410.93	409.39	409.4299	2772767.0
2022-07-29 11:00:00	SPY	ETF	409.4	409.65	408.05	408.3	3091931.0
2022-07-29 11:30:00	SPY	ETF	408.28	409.79	408.01	409.56	2419321.0
2022-07-29 12:00:00	SPY	ETF	409.57	409.88	408.83	409.6	1915914.0
2022-07-29 12:30:00	SPY	ETF	409.61	410.73	409.37	410.48	1738255.0
2022-07-29 13:00:00	SPY	ETF	410.49	410.56	410.01	410.0857	1515099.0
2022-07-29 13:30:00	SPY	ETF	410.06	411.22	410.05	410.89	2033904.0
2022-07-29 14:00:00	SPY	ETF	410.9	411.62	410.63	411.57	3547185.0
2022-07-29 14:30:00	SPY	ETF	411.57	412.02	411.37	411.87	3187614.0
2022-07-29 15:00:00	SPY	ETF	411.88	412.69	411.79	412.67	4320199.0
2022-07-29 15:30:00	SPY	ETF	412.67	413.03	411.78	412.06	15586005.0
2022-07-29 16:00:00	SPY	ETF	412.04	412.25	411.75	411.91	5353863.0
2022-07-29 16:30:00	SPY	ETF	411.88	412.0	411.84	411.94	123185.0
2022-07-29 17:00:00	SPY	ETF	411.81	412.0	411.74	411.85	63093.0
2022-07-29 17:30:00	SPY	ETF	411.85	411.85	411.63	411.7	25242.0
2022-07-29 18:00:00	SPY	ETF	411.67	411.67	411.45	411.45	25607.0
2022-07-29 18:30:00	SPY	ETF	411.5	411.52	411.43	411.45	10233.0
2022-07-29 19:00:00	SPY	ETF	411.51	411.52	411.4	411.4	15153.0
2022-07-29 19:30:00	SPY	ETF	411.4	411.5	411.35	411.46	28453.0
2022-07-29 04:00:00	QQQ	ETF	313.81	314.08	313.58	313.92	51511.0
2022-07-29 04:30:00	QQQ	ETF	313.71	313.71	312.62	313.06	37078.0
2022-07-29 05:00:00	QQQ	ETF	312.99	313.33	312.75	313.31	33617.0
2022-07-29 05:30:00	QQQ	ETF	313.5	313.57	313.25	313.56	17848.0
2022-07-29 06:00:00	QQQ	ETF	313.44	313.54	313.09	313.18	39165.0
2022-07-29 06:30:00	QQQ	ETF	313.21	313.65	313.2	313.2	36036.0
2022-07-29 07:00:00	QQQ	ETF	313.21	313.31	312.71	312.75	88131.0
2022-07-29 07:30:00	QQQ	ETF	312.71	312.86	312.36	312.81	163679.0
2022-07-29 08:00:00	QQQ	ETF	313.23	314.61	310.042	312.51	312740.0
2022-07-29 08:30:00	QQQ	ETF	312.25	312.59	311.39	312.15	549209.0
2022-07-29 09:00:00	QQQ	ETF	312.11	312.12	311.12	311.38	400649.0
2022-07-29 09:30:00	QQQ	ETF	311.38	313.36	309.931	312.86	7048345.0
2022-07-29 10:00:00	QQQ	ETF	312.87	314.46	312.38	314.13	4355028.0
2022-07-29 10:30:00	QQQ	ETF	314.12	314.44	312.76	312.82	2822418.0
2022-07-29 11:00:00	QQQ	ETF	312.7901	312.95	311.13	311.305	3258606.0
2022-07-29 11:30:00	QQQ	ETF	311.31	312.89	310.96	312.74	2341882.0
2022-07-29 12:00:00	QQQ	ETF	312.75	313.09	312.121	312.75	1275558.0
2022-07-29 12:30:00	QQQ	ETF	312.75	313.77	312.42	313.64	1542779.0

> showing 50 of 26,091 rows — these rows as CSV

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