PREVIEW / etf_30min / 2023-01-30

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-01-30.parquet
  size:    694 KB
  rows:    28,095

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
2023-01-30 04:00:00	SPY	ETF	402.68	404.44	402.57	402.6	255593.0
2023-01-30 04:30:00	SPY	ETF	402.59	402.74	401.85	402.36	129281.0
2023-01-30 05:00:00	SPY	ETF	402.31	402.4	402.05	402.24	16581.0
2023-01-30 05:30:00	SPY	ETF	402.18	402.6	402.17	402.3	12292.0
2023-01-30 06:00:00	SPY	ETF	402.5	402.54	401.75	401.88	20492.0
2023-01-30 06:30:00	SPY	ETF	401.82	401.98	401.42	401.77	68519.0
2023-01-30 07:00:00	SPY	ETF	401.86	402.32	401.86	402.27	381372.0
2023-01-30 07:30:00	SPY	ETF	402.3	402.51	401.96	402.32	115174.0
2023-01-30 08:00:00	SPY	ETF	401.96	404.56	401.525	402.68	250623.0
2023-01-30 08:30:00	SPY	ETF	402.65	402.74	402.05	402.6	298858.0
2023-01-30 09:00:00	SPY	ETF	402.63	402.97	402.42	402.8	293123.0
2023-01-30 09:30:00	SPY	ETF	402.8	404.6	402.66	404.34	5034712.0
2023-01-30 10:00:00	SPY	ETF	404.325	405.13	403.19	403.9	4500316.0
2023-01-30 10:30:00	SPY	ETF	403.91	403.925	401.93	403.01	5254528.0
2023-01-30 11:00:00	SPY	ETF	403.01	403.88	402.59	403.26	3516764.0
2023-01-30 11:30:00	SPY	ETF	403.27	403.585	402.005	403.1981	2383515.0
2023-01-30 12:00:00	SPY	ETF	403.192	403.41	402.27	402.8942	1790899.0
2023-01-30 12:30:00	SPY	ETF	402.8799	402.94	401.925	402.09	1796178.0
2023-01-30 13:00:00	SPY	ETF	402.09	403.065	401.7	402.6412	2191410.0
2023-01-30 13:30:00	SPY	ETF	402.6399	402.6399	401.7022	402.25	1970934.0
2023-01-30 14:00:00	SPY	ETF	402.25	402.43	401.41	401.47	3139129.0
2023-01-30 14:30:00	SPY	ETF	401.47	401.84	400.92	401.3201	3065956.0
2023-01-30 15:00:00	SPY	ETF	401.32	401.79	400.54	400.67	3727743.0
2023-01-30 15:30:00	SPY	ETF	400.68	401.56	400.28	400.63	11316347.0
2023-01-30 16:00:00	SPY	ETF	400.63	401.49	400.551	401.41	6000532.0
2023-01-30 16:30:00	SPY	ETF	401.41	401.49	400.59	401.33	347785.0
2023-01-30 17:00:00	SPY	ETF	401.32	401.38	401.24	401.24	34113.0
2023-01-30 17:30:00	SPY	ETF	401.25	401.28	401.07	401.19	59213.0
2023-01-30 18:00:00	SPY	ETF	401.22	401.4	401.08	401.4	128962.0
2023-01-30 18:30:00	SPY	ETF	401.4	401.7	401.32	401.7	29156.0
2023-01-30 19:00:00	SPY	ETF	401.69	401.69	401.18	401.35	32947.0
2023-01-30 19:30:00	SPY	ETF	401.37	401.5	401.3	401.44	35913.0
2023-01-30 04:00:00	QQQ	ETF	293.1	295.37	292.83	292.88	50528.0
2023-01-30 04:30:00	QQQ	ETF	292.94	292.94	292.25	292.68	42001.0
2023-01-30 05:00:00	QQQ	ETF	292.55	292.75	292.41	292.49	17541.0
2023-01-30 05:30:00	QQQ	ETF	292.47	292.84	292.47	292.63	8012.0
2023-01-30 06:00:00	QQQ	ETF	292.76	292.76	292.19	292.31	35734.0
2023-01-30 06:30:00	QQQ	ETF	292.25	292.47	291.87	292.36	79278.0
2023-01-30 07:00:00	QQQ	ETF	292.32	292.83	292.32	292.7	203892.0
2023-01-30 07:30:00	QQQ	ETF	292.84	293.07	292.5	292.92	115483.0
2023-01-30 08:00:00	QQQ	ETF	292.43	296.482	291.94	293.18	265954.0
2023-01-30 08:30:00	QQQ	ETF	293.18	293.18	292.44	292.98	336831.0
2023-01-30 09:00:00	QQQ	ETF	292.97	293.09	292.74	292.93	225023.0
2023-01-30 09:30:00	QQQ	ETF	292.93	294.0925	292.33	293.8	4573059.0
2023-01-30 10:00:00	QQQ	ETF	293.76	294.38	291.5664	292.18	3201122.0
2023-01-30 10:30:00	QQQ	ETF	292.17	292.19	290.46	291.5501	3705318.0
2023-01-30 11:00:00	QQQ	ETF	291.56	292.46	291.2	292.2349	2279530.0
2023-01-30 11:30:00	QQQ	ETF	292.22	292.63	291.14	292.345	1630703.0
2023-01-30 12:00:00	QQQ	ETF	292.35	292.54	291.46	292.0999	1415893.0
2023-01-30 12:30:00	QQQ	ETF	292.08	292.179	291.02	291.37	1204081.0

> showing 50 of 28,095 rows — these rows as CSV

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