PREVIEW / etf_1hour / 2023-01-27

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-01-27.parquet
  size:    468 KB
  rows:    17,001

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.64	90901.0
2023-01-27 05:00:00	SPY	ETF	403.5	403.86	403.5	403.8	22350.0
2023-01-27 06:00:00	SPY	ETF	403.81	404.14	403.74	403.85	79978.0
2023-01-27 07:00:00	SPY	ETF	403.9	404.29	403.26	403.33	311763.0
2023-01-27 08:00:00	SPY	ETF	404.06	404.25	403.11	403.32	804125.0
2023-01-27 09:00:00	SPY	ETF	403.31	405.52	403.14	404.99	4871162.0
2023-01-27 10:00:00	SPY	ETF	405.05	406.63	403.57	404.1455	9266881.0
2023-01-27 11:00:00	SPY	ETF	404.1515	406.15	403.75	405.8606	5842555.0
2023-01-27 12:00:00	SPY	ETF	405.865	406.76	405.522	406.43	5380113.0
2023-01-27 13:00:00	SPY	ETF	406.44	406.61	405.6499	406.42	3463392.0
2023-01-27 14:00:00	SPY	ETF	406.415	407.58	406.26	407.455	4690522.0
2023-01-27 15:00:00	SPY	ETF	407.46	408.16	405.55	405.68	13514943.0
2023-01-27 16:00:00	SPY	ETF	405.69	405.86	405.38	405.65	3670726.0
2023-01-27 17:00:00	SPY	ETF	405.54	405.7	405.54	405.6	70484.0
2023-01-27 18:00:00	SPY	ETF	405.61	405.69	405.56	405.63	18839.0
2023-01-27 19:00:00	SPY	ETF	405.63	405.67	405.0	405.35	35220.0
2023-01-27 04:00:00	QQQ	ETF	291.5	291.9	291.34	291.78	50600.0
2023-01-27 05:00:00	QQQ	ETF	291.85	292.1	291.72	291.95	19278.0
2023-01-27 06:00:00	QQQ	ETF	291.94	292.26	291.85	292.12	58848.0
2023-01-27 07:00:00	QQQ	ETF	292.12	292.6	291.64	291.64	216757.0
2023-01-27 08:00:00	QQQ	ETF	292.23	293.56	291.46	291.88	598262.0
2023-01-27 09:00:00	QQQ	ETF	291.9	294.4199	291.66	293.87	4896602.0
2023-01-27 10:00:00	QQQ	ETF	293.9	295.5	293.08	293.65	8152190.0
2023-01-27 11:00:00	QQQ	ETF	293.63	295.885	293.29	295.58	4817161.0
2023-01-27 12:00:00	QQQ	ETF	295.59	296.67	295.34	296.27	4121820.0
2023-01-27 13:00:00	QQQ	ETF	296.28	297.2	295.68	297.0289	3589648.0
2023-01-27 14:00:00	QQQ	ETF	297.02	297.65	296.7	297.479	3726155.0
2023-01-27 15:00:00	QQQ	ETF	297.48	298.26	296.11	296.2	8993385.0
2023-01-27 16:00:00	QQQ	ETF	296.21	296.4099	295.94	296.18	2833738.0
2023-01-27 17:00:00	QQQ	ETF	296.14	296.26	295.99	296.09	78578.0
2023-01-27 18:00:00	QQQ	ETF	296.08	296.09	296.01	296.05	12878.0
2023-01-27 19:00:00	QQQ	ETF	296.26	296.26	295.99	295.99	258759.0
2023-01-27 04:00:00	IWM	ETF	187.91	188.26	187.91	188.21	10333.0
2023-01-27 05:00:00	IWM	ETF	188.18	188.33	188.18	188.28	3592.0
2023-01-27 06:00:00	IWM	ETF	188.25	188.5	188.25	188.26	41976.0
2023-01-27 07:00:00	IWM	ETF	188.3	188.49	188.02	188.09	85535.0
2023-01-27 08:00:00	IWM	ETF	188.41	188.48	188.0	188.06	89757.0
2023-01-27 09:00:00	IWM	ETF	188.12	189.25	187.85	188.96	1568150.0
2023-01-27 10:00:00	IWM	ETF	188.98	189.78	187.82	188.08	2589305.0
2023-01-27 11:00:00	IWM	ETF	188.09	188.965	187.79	188.855	1299623.0
2023-01-27 12:00:00	IWM	ETF	188.855	189.49	188.72	189.41	1270253.0
2023-01-27 13:00:00	IWM	ETF	189.405	189.77	189.265	189.7	888257.0
2023-01-27 14:00:00	IWM	ETF	189.705	189.99	189.69	189.845	726594.0
2023-01-27 15:00:00	IWM	ETF	189.845	190.3	189.41	189.56	3507837.0
2023-01-27 16:00:00	IWM	ETF	189.54	190.058	189.34	189.4	2307516.0
2023-01-27 17:00:00	IWM	ETF	189.46	189.48	189.25	189.32	9840.0
2023-01-27 18:00:00	IWM	ETF	189.32	189.44	189.32	189.44	4976.0
2023-01-27 19:00:00	IWM	ETF	189.44	189.5	189.35	189.48	16077.0
2023-01-27 04:00:00	DIA	ETF	338.95	338.96	338.92	338.95	4400.0
2023-01-27 06:00:00	DIA	ETF	339.33	339.33	339.13	339.13	4080.0

> showing 50 of 17,001 rows — these rows as CSV

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