PREVIEW / etf_30min / 2022-05-17

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-05-17.parquet
  size:    682 KB
  rows:    27,185

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-05-17 04:00:00	SPY	ETF	402.02	405.45	402.02	405.37	46865.0
2022-05-17 04:30:00	SPY	ETF	405.42	406.6	405.39	405.8	77457.0
2022-05-17 05:00:00	SPY	ETF	405.8	406.39	405.75	406.39	22357.0
2022-05-17 05:30:00	SPY	ETF	406.27	407.43	406.23	407.24	49681.0
2022-05-17 06:00:00	SPY	ETF	407.27	407.87	406.97	407.0	122854.0
2022-05-17 06:30:00	SPY	ETF	406.97	407.17	406.55	406.65	109312.0
2022-05-17 07:00:00	SPY	ETF	406.55	407.08	406.05	407.08	324155.0
2022-05-17 07:30:00	SPY	ETF	406.89	406.89	405.9	405.93	177996.0
2022-05-17 08:00:00	SPY	ETF	406.2075	407.53	400.84	406.0	529024.0
2022-05-17 08:30:00	SPY	ETF	405.98	406.37	405.16	406.2	281504.0
2022-05-17 09:00:00	SPY	ETF	406.22	406.78	406.13	406.46	488938.0
2022-05-17 09:30:00	SPY	ETF	406.53	406.63	404.4	405.195	6989862.0
2022-05-17 10:00:00	SPY	ETF	405.18	406.15	404.12	404.23	3971018.0
2022-05-17 10:30:00	SPY	ETF	404.22	404.72	402.5824	403.79	4736640.0
2022-05-17 11:00:00	SPY	ETF	403.81	405.36	403.65	405.19	3078252.0
2022-05-17 11:30:00	SPY	ETF	405.2	406.03	405.0107	405.4599	2811262.0
2022-05-17 12:00:00	SPY	ETF	405.45	406.18	404.59	405.85	2400569.0
2022-05-17 12:30:00	SPY	ETF	405.875	406.92	405.635	406.2354	2962262.0
2022-05-17 13:00:00	SPY	ETF	406.24	407.15	405.46	406.46	2649901.0
2022-05-17 13:30:00	SPY	ETF	406.463	406.937	406.16	406.31	2404340.0
2022-05-17 14:00:00	SPY	ETF	406.3	407.5	403.5	404.74	6717891.0
2022-05-17 14:30:00	SPY	ETF	404.73	407.754	403.75	407.07	5236373.0
2022-05-17 15:00:00	SPY	ETF	407.1	408.57	406.98	408.11	4779400.0
2022-05-17 15:30:00	SPY	ETF	408.1	408.38	406.79	408.27	9252975.0
2022-05-17 16:00:00	SPY	ETF	408.25	408.73	407.4	408.64	3408437.0
2022-05-17 16:30:00	SPY	ETF	408.67	408.71	408.32	408.66	128550.0
2022-05-17 17:00:00	SPY	ETF	408.66	408.72	408.6	408.63	24276.0
2022-05-17 17:30:00	SPY	ETF	408.69	408.75	408.62	408.67	23495.0
2022-05-17 18:00:00	SPY	ETF	408.75	409.1	408.71	408.98	51606.0
2022-05-17 18:30:00	SPY	ETF	408.98	409.05	408.66	408.67	30529.0
2022-05-17 19:00:00	SPY	ETF	408.67	408.71	408.5	408.59	28933.0
2022-05-17 19:30:00	SPY	ETF	408.59	408.71	408.15	408.19	33787.0
2022-05-17 04:00:00	QQQ	ETF	301.36	303.82	301.36	303.72	78913.0
2022-05-17 04:30:00	QQQ	ETF	303.8	305.36	303.57	304.6	130836.0
2022-05-17 05:00:00	QQQ	ETF	304.51	304.84	304.37	304.77	32071.0
2022-05-17 05:30:00	QQQ	ETF	304.85	305.6	304.71	305.5	74987.0
2022-05-17 06:00:00	QQQ	ETF	305.47	305.73	304.6	304.75	97242.0
2022-05-17 06:30:00	QQQ	ETF	304.75	304.97	304.32	304.32	81253.0
2022-05-17 07:00:00	QQQ	ETF	304.36	304.88	303.87	304.74	283369.0
2022-05-17 07:30:00	QQQ	ETF	304.66	304.7	304.0	304.02	196572.0
2022-05-17 08:00:00	QQQ	ETF	304.06	305.5496	300.0	304.02	288505.0
2022-05-17 08:30:00	QQQ	ETF	304.02	304.44	303.16	304.06	382723.0
2022-05-17 09:00:00	QQQ	ETF	304.07	304.56	303.93	304.43	389000.0
2022-05-17 09:30:00	QQQ	ETF	304.42	305.54	303.02	303.35	6509410.0
2022-05-17 10:00:00	QQQ	ETF	303.32	304.51	302.354	302.41	3855371.0
2022-05-17 10:30:00	QQQ	ETF	302.3981	302.89	300.55	301.39	3693156.0
2022-05-17 11:00:00	QQQ	ETF	301.37	303.28	301.135	303.2067	3136290.0
2022-05-17 11:30:00	QQQ	ETF	303.24	304.44	303.21	303.86	2547594.0
2022-05-17 12:00:00	QQQ	ETF	303.86	304.22	302.96	304.035	1656822.0
2022-05-17 12:30:00	QQQ	ETF	304.02	304.69	303.7	303.85	1648591.0

> showing 50 of 27,185 rows — these rows as CSV

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