PREVIEW / etf_1hour / 2008-01-31

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-01-31.parquet
  size:    106 KB
  rows:    3,520

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
2008-01-31 04:00:00	SPY	ETF	134.15	134.55	134.15	134.55	20800.0
2008-01-31 05:00:00	SPY	ETF	134.66	134.95	134.42	134.53	62900.0
2008-01-31 06:00:00	SPY	ETF	134.34	134.62	134.21	134.62	135800.0
2008-01-31 07:00:00	SPY	ETF	134.46	134.65	134.28	134.5	892400.0
2008-01-31 08:00:00	SPY	ETF	134.52	135.09	133.02	133.22	9572000.0
2008-01-31 09:00:00	SPY	ETF	133.22	134.51	133.2	134.42	31765727.0
2008-01-31 10:00:00	SPY	ETF	134.42	135.22	134.0	135.17	45349772.0
2008-01-31 11:00:00	SPY	ETF	135.18	137.46	134.76	136.79	54788231.0
2008-01-31 12:00:00	SPY	ETF	136.79	136.91	135.84	136.15	32108304.0
2008-01-31 13:00:00	SPY	ETF	136.15	137.07	135.89	136.65	24262627.0
2008-01-31 14:00:00	SPY	ETF	136.65	137.57	136.51	137.53	29771252.0
2008-01-31 15:00:00	SPY	ETF	137.54	138.54	136.93	137.33	63171239.0
2008-01-31 16:00:00	SPY	ETF	137.33	138.25	134.38	137.21	35396611.0
2008-01-31 17:00:00	SPY	ETF	137.21	137.43	137.09	137.39	774300.0
2008-01-31 18:00:00	SPY	ETF	137.25	137.55	137.25	137.36	410200.0
2008-01-31 19:00:00	SPY	ETF	137.28	137.55	137.28	137.32	288500.0
2008-01-31 04:00:00	QQQ	ETF	44.05	44.05	44.05	44.05	22000.0
2008-01-31 05:00:00	QQQ	ETF	44.15	44.18	44.15	44.18	800.0
2008-01-31 06:00:00	QQQ	ETF	44.13	44.17	44.13	44.17	2500.0
2008-01-31 07:00:00	QQQ	ETF	44.17	44.22	44.08	44.19	417437.0
2008-01-31 08:00:00	QQQ	ETF	44.19	44.32	43.75	43.76	3974822.0
2008-01-31 09:00:00	QQQ	ETF	43.77	44.12	43.75	44.06	24080549.0
2008-01-31 10:00:00	QQQ	ETF	44.06	44.25	43.98	44.23	35850277.0
2008-01-31 11:00:00	QQQ	ETF	44.23	45.03	44.11	44.87	39185966.0
2008-01-31 12:00:00	QQQ	ETF	44.88	44.8919	44.58	44.68	18046613.0
2008-01-31 13:00:00	QQQ	ETF	44.69	45.01	44.59	44.88	19107472.0
2008-01-31 14:00:00	QQQ	ETF	44.87	45.21	44.85	45.2	24892082.0
2008-01-31 15:00:00	QQQ	ETF	45.19	45.59	45.07	45.13	58198689.0
2008-01-31 16:00:00	QQQ	ETF	45.13	45.52	44.39	44.94	21598137.0
2008-01-31 17:00:00	QQQ	ETF	44.94	45.1	44.93	45.02	1237559.0
2008-01-31 18:00:00	QQQ	ETF	45.01	45.1	44.99	45.1	80627.0
2008-01-31 19:00:00	QQQ	ETF	45.1	45.14	44.97	45.06	629980.0
2008-01-31 06:00:00	IWM	ETF	68.49	68.49	68.49	68.49	500.0
2008-01-31 07:00:00	IWM	ETF	68.6	68.6	68.39	68.5	157100.0
2008-01-31 08:00:00	IWM	ETF	68.51	68.54	67.99	68.04	1941900.0
2008-01-31 09:00:00	IWM	ETF	68.04	69.25	68.0	69.1	14440769.0
2008-01-31 10:00:00	IWM	ETF	69.1	69.62	68.81	69.6	16220406.0
2008-01-31 11:00:00	IWM	ETF	69.58	70.8	69.49	70.41	16254581.0
2008-01-31 12:00:00	IWM	ETF	70.41	70.7	69.87	70.18	11122355.0
2008-01-31 13:00:00	IWM	ETF	70.18	70.76	70.03	70.47	9888646.0
2008-01-31 14:00:00	IWM	ETF	70.49	71.13	70.44	71.1	11687850.0
2008-01-31 15:00:00	IWM	ETF	71.09	71.56	69.9	70.97	25353378.0
2008-01-31 16:00:00	IWM	ETF	70.97	71.28	70.15	70.86	9183673.0
2008-01-31 17:00:00	IWM	ETF	70.78	70.98	70.76	70.76	1266500.0
2008-01-31 18:00:00	IWM	ETF	70.94	70.94	70.87	70.9	158100.0
2008-01-31 19:00:00	IWM	ETF	70.9	71.0	70.9	70.9	7800.0
2008-01-31 07:00:00	DIA	ETF	123.42	123.42	123.25	123.3	3700.0
2008-01-31 08:00:00	DIA	ETF	123.41	124.0	122.36	122.51	198900.0
2008-01-31 09:00:00	DIA	ETF	122.58	123.5	122.41	123.42	2905238.0
2008-01-31 10:00:00	DIA	ETF	123.42	124.0	123.07	123.99	3491367.0

> showing 50 of 3,520 rows — these rows as CSV

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