PREVIEW / etf_1hour / 2008-03-05

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-03-05.parquet
  size:    104 KB
  rows:    3,555

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-03-05 04:00:00	SPY	ETF	132.86	132.86	132.86	132.86	100.0
2008-03-05 05:00:00	SPY	ETF	133.2	133.2	133.15	133.16	13000.0
2008-03-05 06:00:00	SPY	ETF	133.25	133.68	133.25	133.68	160600.0
2008-03-05 07:00:00	SPY	ETF	133.69	133.84	133.41	133.77	1019700.0
2008-03-05 08:00:00	SPY	ETF	133.77	133.81	133.1	133.35	4819798.0
2008-03-05 09:00:00	SPY	ETF	133.31	133.78	132.99	133.68	19267620.0
2008-03-05 10:00:00	SPY	ETF	133.68	134.51	133.63	134.02	41135649.0
2008-03-05 11:00:00	SPY	ETF	134.02	134.3	133.8	134.06	19495198.0
2008-03-05 12:00:00	SPY	ETF	134.06	134.77	133.52	133.85	49842949.0
2008-03-05 13:00:00	SPY	ETF	133.87	134.1	132.34	132.73	56477976.0
2008-03-05 14:00:00	SPY	ETF	132.74	133.84	132.44	133.33	30122247.0
2008-03-05 15:00:00	SPY	ETF	133.34	133.73	132.7	133.7	34108878.0
2008-03-05 16:00:00	SPY	ETF	133.72	134.0	133.01	133.83	8071800.0
2008-03-05 17:00:00	SPY	ETF	133.83	134.07	133.26	133.93	434000.0
2008-03-05 18:00:00	SPY	ETF	133.98	134.01	133.542	133.72	102400.0
2008-03-05 19:00:00	SPY	ETF	133.71	133.76	133.66	133.69	22000.0
2008-03-05 06:00:00	QQQ	ETF	43.1	43.18	43.1	43.18	5100.0
2008-03-05 07:00:00	QQQ	ETF	43.19	43.25	43.16	43.22	886530.0
2008-03-05 08:00:00	QQQ	ETF	43.22	43.22	43.01	43.13	4364375.0
2008-03-05 09:00:00	QQQ	ETF	43.11	43.25	42.96	43.15	21310711.0
2008-03-05 10:00:00	QQQ	ETF	43.15	43.39	43.15	43.26	34979023.0
2008-03-05 11:00:00	QQQ	ETF	43.26	43.35	43.19	43.25	11273078.0
2008-03-05 12:00:00	QQQ	ETF	43.259	43.54	43.14	43.25	29453163.0
2008-03-05 13:00:00	QQQ	ETF	43.25	43.35	42.76	42.86	28055999.0
2008-03-05 14:00:00	QQQ	ETF	42.86	43.24	42.75	43.11	18686394.0
2008-03-05 15:00:00	QQQ	ETF	43.11	43.13	42.92	43.13	27756069.0
2008-03-05 16:00:00	QQQ	ETF	43.13	43.25	43.0735	43.2	9608803.0
2008-03-05 17:00:00	QQQ	ETF	43.21	43.25	43.02	43.21	233682.0
2008-03-05 18:00:00	QQQ	ETF	43.23	43.24	43.022	43.21	38963.0
2008-03-05 19:00:00	QQQ	ETF	43.2	43.22	43.19	43.22	18585.0
2008-03-05 06:00:00	IWM	ETF	68.21	68.23	68.21	68.23	17500.0
2008-03-05 07:00:00	IWM	ETF	68.21	68.5	68.21	68.49	417100.0
2008-03-05 08:00:00	IWM	ETF	68.43	68.7	68.2	68.28	1760100.0
2008-03-05 09:00:00	IWM	ETF	67.8	68.37	67.8	68.09	7871376.0
2008-03-05 10:00:00	IWM	ETF	68.08	68.52	67.9	68.24	16624096.0
2008-03-05 11:00:00	IWM	ETF	68.23	68.42	68.1	68.27	6173922.0
2008-03-05 12:00:00	IWM	ETF	68.27	68.7	68.09	68.32	12938452.0
2008-03-05 13:00:00	IWM	ETF	68.31	68.51	67.43	67.72	15413832.0
2008-03-05 14:00:00	IWM	ETF	67.72	68.34	67.58	68.13	9791406.0
2008-03-05 15:00:00	IWM	ETF	68.12	68.26	67.76	68.25	11933159.0
2008-03-05 16:00:00	IWM	ETF	68.26	68.48	67.76	68.45	3186900.0
2008-03-05 17:00:00	IWM	ETF	68.39	68.39	68.08	68.35	7213200.0
2008-03-05 18:00:00	IWM	ETF	68.44	68.44	68.44	68.44	700.0
2008-03-05 06:00:00	DIA	ETF	122.7	122.7	122.7	122.7	100.0
2008-03-05 07:00:00	DIA	ETF	122.75	122.85	122.57	122.65	13900.0
2008-03-05 08:00:00	DIA	ETF	122.78	122.86	122.4	122.6	69500.0
2008-03-05 09:00:00	DIA	ETF	122.55	122.82	122.33	122.8	1062301.0
2008-03-05 10:00:00	DIA	ETF	122.78	123.44	122.76	123.06	2435963.0
2008-03-05 11:00:00	DIA	ETF	123.05	123.28	122.87	123.08	1039506.0
2008-03-05 12:00:00	DIA	ETF	123.1	123.59	122.55	122.82	3160192.0

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

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