PREVIEW / etf_1hour / 2008-01-08

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-01-08.parquet
  size:    101 KB
  rows:    3,375

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-08 04:00:00	SPY	ETF	141.89	141.89	141.89	141.89	200.0
2008-01-08 06:00:00	SPY	ETF	141.9	142.02	141.89	141.95	150500.0
2008-01-08 07:00:00	SPY	ETF	141.95	142.48	141.93	142.48	1074900.0
2008-01-08 08:00:00	SPY	ETF	142.43	142.5	141.95	142.1	4344400.0
2008-01-08 09:00:00	SPY	ETF	142.09	142.63	141.86	142.36	34484591.0
2008-01-08 10:00:00	SPY	ETF	142.36	142.9	142.1	142.27	34841754.0
2008-01-08 11:00:00	SPY	ETF	142.27	142.38	140.88	141.18	35989875.0
2008-01-08 12:00:00	SPY	ETF	141.18	141.51	140.92	141.25	22919790.0
2008-01-08 13:00:00	SPY	ETF	141.245	142.05	140.9	142.04	44386039.0
2008-01-08 14:00:00	SPY	ETF	142.03	142.36	140.63	140.7	40392327.0
2008-01-08 15:00:00	SPY	ETF	140.7	141.55	138.63	138.81	93362794.0
2008-01-08 16:00:00	SPY	ETF	138.85	141.3	138.44	138.84	9322700.0
2008-01-08 17:00:00	SPY	ETF	138.82	141.31	138.78	138.86	323500.0
2008-01-08 18:00:00	SPY	ETF	138.89	138.92	138.67	138.67	59700.0
2008-01-08 19:00:00	SPY	ETF	138.74	138.99	138.72	138.91	15800.0
2008-01-08 05:00:00	QQQ	ETF	48.39	48.41	48.39	48.41	25300.0
2008-01-08 06:00:00	QQQ	ETF	48.35	48.38	48.35	48.38	3200.0
2008-01-08 07:00:00	QQQ	ETF	48.37	48.62	48.37	48.59	1258634.0
2008-01-08 08:00:00	QQQ	ETF	48.59	48.61	48.35	48.38	4332810.0
2008-01-08 09:00:00	QQQ	ETF	48.38	48.45	48.11	48.33	20421454.0
2008-01-08 10:00:00	QQQ	ETF	48.33	48.76	48.28	48.54	30678505.0
2008-01-08 11:00:00	QQQ	ETF	48.54	48.58	47.99	48.17	26592932.0
2008-01-08 12:00:00	QQQ	ETF	48.19	48.39	48.05	48.3	19967263.0
2008-01-08 13:00:00	QQQ	ETF	48.3	48.64	48.13	48.53	25220433.0
2008-01-08 14:00:00	QQQ	ETF	48.52	48.76	48.04	48.07	35038354.0
2008-01-08 15:00:00	QQQ	ETF	48.07	48.76	46.97	46.98	80274795.0
2008-01-08 16:00:00	QQQ	ETF	46.97	48.1281	46.9	47.06	18222217.0
2008-01-08 17:00:00	QQQ	ETF	47.07	47.1	46.92	47.1	319477.0
2008-01-08 18:00:00	QQQ	ETF	47.09	47.1	47.04	47.05	245044.0
2008-01-08 19:00:00	QQQ	ETF	47.05	47.11	47.04	47.09	99688.0
2008-01-08 04:00:00	IWM	ETF	72.25	72.25	72.25	72.25	200.0
2008-01-08 07:00:00	IWM	ETF	72.45	72.81	72.45	72.75	82400.0
2008-01-08 08:00:00	IWM	ETF	72.77	72.86	72.37	72.43	2146400.0
2008-01-08 09:00:00	IWM	ETF	72.38	73.0	72.24	72.73	17570156.0
2008-01-08 10:00:00	IWM	ETF	72.73	73.27	72.47	72.56	14426722.0
2008-01-08 11:00:00	IWM	ETF	72.56	72.63	71.21	71.45	18271135.0
2008-01-08 12:00:00	IWM	ETF	71.46	71.8	71.23	71.65	11061338.0
2008-01-08 13:00:00	IWM	ETF	71.64	71.96	71.38	71.9	17938490.0
2008-01-08 14:00:00	IWM	ETF	71.88	72.42	71.09	71.14	21484607.0
2008-01-08 15:00:00	IWM	ETF	71.14	71.35	70.09	70.17	45141050.0
2008-01-08 16:00:00	IWM	ETF	70.16	72.07	69.82	69.94	9526500.0
2008-01-08 17:00:00	IWM	ETF	69.94	70.07	69.93	70.0	7700.0
2008-01-08 18:00:00	IWM	ETF	69.97	69.99	69.87	69.87	65400.0
2008-01-08 19:00:00	IWM	ETF	69.99	70.0	69.95	69.95	2300.0
2008-01-08 07:00:00	DIA	ETF	128.66	128.97	128.66	128.97	3900.0
2008-01-08 08:00:00	DIA	ETF	128.56	128.94	128.25	128.6	28300.0
2008-01-08 09:00:00	DIA	ETF	128.48	128.85	128.46	128.64	1912301.0
2008-01-08 10:00:00	DIA	ETF	128.65	129.0	128.43	128.49	2805494.0
2008-01-08 11:00:00	DIA	ETF	128.49	128.57	127.62	127.82	2394770.0
2008-01-08 12:00:00	DIA	ETF	127.81	127.99	127.57	127.8	1424617.0

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

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