PREVIEW / etf_30min / 2023-01-27

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-01-27.parquet
  size:    691 KB
  rows:    27,515

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-27 04:00:00	SPY	ETF	403.42	404.0	403.2	403.32	75249.0
2023-01-27 04:30:00	SPY	ETF	403.3	403.69	403.3	403.64	15652.0
2023-01-27 05:00:00	SPY	ETF	403.5	403.86	403.5	403.73	11503.0
2023-01-27 05:30:00	SPY	ETF	403.69	403.82	403.56	403.8	10847.0
2023-01-27 06:00:00	SPY	ETF	403.81	404.08	403.74	403.77	8522.0
2023-01-27 06:30:00	SPY	ETF	403.81	404.14	403.74	403.85	71456.0
2023-01-27 07:00:00	SPY	ETF	403.9	404.29	403.67	403.71	197719.0
2023-01-27 07:30:00	SPY	ETF	403.7	403.86	403.26	403.33	114044.0
2023-01-27 08:00:00	SPY	ETF	404.06	404.25	403.21	403.75	330229.0
2023-01-27 08:30:00	SPY	ETF	403.75	404.14	403.11	403.32	473896.0
2023-01-27 09:00:00	SPY	ETF	403.31	403.75	403.14	403.65	252787.0
2023-01-27 09:30:00	SPY	ETF	403.65	405.52	403.44	404.99	4618375.0
2023-01-27 10:00:00	SPY	ETF	405.05	406.63	404.47	405.71	4924857.0
2023-01-27 10:30:00	SPY	ETF	405.729	405.8	403.57	404.1455	4342024.0
2023-01-27 11:00:00	SPY	ETF	404.1515	405.1313	403.75	404.98	2985826.0
2023-01-27 11:30:00	SPY	ETF	405.0	406.15	404.89	405.8606	2856729.0
2023-01-27 12:00:00	SPY	ETF	405.865	406.55	405.522	405.96	2913092.0
2023-01-27 12:30:00	SPY	ETF	405.97	406.76	405.85	406.43	2467021.0
2023-01-27 13:00:00	SPY	ETF	406.44	406.61	405.6499	406.06	1995070.0
2023-01-27 13:30:00	SPY	ETF	406.04	406.54	406.01	406.42	1468322.0
2023-01-27 14:00:00	SPY	ETF	406.415	407.2	406.26	407.05	2432219.0
2023-01-27 14:30:00	SPY	ETF	407.045	407.58	406.9201	407.455	2258303.0
2023-01-27 15:00:00	SPY	ETF	407.46	408.16	407.021	407.62	3635446.0
2023-01-27 15:30:00	SPY	ETF	407.63	407.885	405.55	405.68	9879497.0
2023-01-27 16:00:00	SPY	ETF	405.69	405.86	405.38	405.68	3564728.0
2023-01-27 16:30:00	SPY	ETF	405.64	405.68	405.53	405.65	105998.0
2023-01-27 17:00:00	SPY	ETF	405.54	405.68	405.54	405.62	45966.0
2023-01-27 17:30:00	SPY	ETF	405.62	405.7	405.59	405.6	24518.0
2023-01-27 18:00:00	SPY	ETF	405.61	405.61	405.56	405.6	11473.0
2023-01-27 18:30:00	SPY	ETF	405.6	405.69	405.56	405.63	7366.0
2023-01-27 19:00:00	SPY	ETF	405.63	405.67	405.6	405.61	2700.0
2023-01-27 19:30:00	SPY	ETF	405.62	405.64	405.0	405.35	32520.0
2023-01-27 04:00:00	QQQ	ETF	291.5	291.79	291.34	291.48	25850.0
2023-01-27 04:30:00	QQQ	ETF	291.5	291.9	291.47	291.78	24750.0
2023-01-27 05:00:00	QQQ	ETF	291.85	292.1	291.72	292.0	9342.0
2023-01-27 05:30:00	QQQ	ETF	291.99	292.05	291.87	291.95	9936.0
2023-01-27 06:00:00	QQQ	ETF	291.94	292.26	291.86	291.92	15583.0
2023-01-27 06:30:00	QQQ	ETF	291.97	292.15	291.85	292.12	43265.0
2023-01-27 07:00:00	QQQ	ETF	292.12	292.6	291.99	292.0	79896.0
2023-01-27 07:30:00	QQQ	ETF	291.99	292.2	291.64	291.64	136861.0
2023-01-27 08:00:00	QQQ	ETF	292.23	293.56	291.54	292.56	183922.0
2023-01-27 08:30:00	QQQ	ETF	292.6	292.61	291.46	291.88	414340.0
2023-01-27 09:00:00	QQQ	ETF	291.9	292.11	291.66	291.98	265860.0
2023-01-27 09:30:00	QQQ	ETF	292.0	294.4199	291.88	293.87	4630742.0
2023-01-27 10:00:00	QQQ	ETF	293.9	295.5	293.4	294.89	4393753.0
2023-01-27 10:30:00	QQQ	ETF	294.9	295.23	293.08	293.65	3758437.0
2023-01-27 11:00:00	QQQ	ETF	293.63	294.79	293.29	294.66	2230799.0
2023-01-27 11:30:00	QQQ	ETF	294.67	295.885	294.54	295.58	2586362.0
2023-01-27 12:00:00	QQQ	ETF	295.59	296.34	295.34	295.92	2536624.0
2023-01-27 12:30:00	QQQ	ETF	295.915	296.67	295.81	296.27	1585196.0

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

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