PREVIEW / etf_1hour / 2008-12-01

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-12-01.parquet
  size:    117 KB
  rows:    3,864

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-12-01 04:00:00	SPY	ETF	88.71	88.71	88.1	88.1	4050.0
2008-12-01 05:00:00	SPY	ETF	88.1	88.17	87.6	87.94	6320.0
2008-12-01 06:00:00	SPY	ETF	87.88	88.13	87.71	88.0	107000.0
2008-12-01 07:00:00	SPY	ETF	88.09	88.14	87.37	87.7	958849.0
2008-12-01 08:00:00	SPY	ETF	87.7	90.09	87.47	87.74	1760937.0
2008-12-01 09:00:00	SPY	ETF	87.74	87.87	85.68	85.83	54823464.0
2008-12-01 10:00:00	SPY	ETF	85.83	87.45	85.25	85.27	52746454.0
2008-12-01 11:00:00	SPY	ETF	85.27	87.39	84.94	85.28	31453868.0
2008-12-01 12:00:00	SPY	ETF	85.29	85.46	84.39	84.53	29830192.0
2008-12-01 13:00:00	SPY	ETF	84.52	87.19	84.4	84.85	29243140.0
2008-12-01 14:00:00	SPY	ETF	84.85	86.21	84.26	84.84	42737145.0
2008-12-01 15:00:00	SPY	ETF	84.83	85.0	81.97	82.09	98182915.0
2008-12-01 16:00:00	SPY	ETF	82.1	90.0257	81.82	82.05	26085710.0
2008-12-01 17:00:00	SPY	ETF	82.05	82.14	81.86	82.08	1041336.0
2008-12-01 18:00:00	SPY	ETF	82.08	82.19	81.99	82.0	800419.0
2008-12-01 19:00:00	SPY	ETF	82.01	82.4	82.0	82.39	344588.0
2008-12-01 20:00:00	SPY	ETF	82.4	82.4	82.4	82.4	500.0
2008-12-01 04:00:00	QQQ	ETF	28.82	28.82	28.64	28.64	3750.0
2008-12-01 06:00:00	QQQ	ETF	28.56	28.56	28.56	28.56	100.0
2008-12-01 07:00:00	QQQ	ETF	28.56	28.58	28.38	28.5	229435.0
2008-12-01 08:00:00	QQQ	ETF	28.5	28.75	28.42	28.54	1761921.0
2008-12-01 09:00:00	QQQ	ETF	28.55	28.65	27.95	27.98	26845357.0
2008-12-01 10:00:00	QQQ	ETF	27.98	28.0801	27.65	27.65	20728792.0
2008-12-01 11:00:00	QQQ	ETF	27.65	27.79	27.56	27.7001	11613333.0
2008-12-01 12:00:00	QQQ	ETF	27.7	27.74	27.44	27.47	10205692.0
2008-12-01 13:00:00	QQQ	ETF	27.48	27.7	27.42	27.57	12515175.0
2008-12-01 14:00:00	QQQ	ETF	27.58	27.77	27.44	27.64	17821445.0
2008-12-01 15:00:00	QQQ	ETF	27.63	27.67	26.89	26.93	39430982.0
2008-12-01 16:00:00	QQQ	ETF	26.93	26.99	26.86	26.88	3789421.0
2008-12-01 17:00:00	QQQ	ETF	26.87	26.91	26.83	26.88	40697.0
2008-12-01 18:00:00	QQQ	ETF	26.87	26.93	26.86	26.89	140590.0
2008-12-01 19:00:00	QQQ	ETF	26.91	26.99	26.9	26.99	103860.0
2008-12-01 07:00:00	IWM	ETF	46.33	46.33	46.12	46.24	14624.0
2008-12-01 08:00:00	IWM	ETF	46.29	46.75	46.09	46.33	149175.0
2008-12-01 09:00:00	IWM	ETF	46.35	46.4	44.89	44.9	9560373.0
2008-12-01 10:00:00	IWM	ETF	44.89	45.39	44.84	44.88	6858397.0
2008-12-01 11:00:00	IWM	ETF	44.88	44.88	44.29	44.48	6105112.0
2008-12-01 12:00:00	IWM	ETF	44.48	44.54	43.97	44.06	8157357.0
2008-12-01 13:00:00	IWM	ETF	44.06	44.42	43.8	44.14	6201212.0
2008-12-01 14:00:00	IWM	ETF	44.14	44.25	43.58	43.82	9786424.0
2008-12-01 15:00:00	IWM	ETF	43.82	43.86	41.5	42.02	28920170.0
2008-12-01 16:00:00	IWM	ETF	42.03	47.42	41.82	41.82	12737470.0
2008-12-01 17:00:00	IWM	ETF	41.93	42.1	41.92	41.95	124117.0
2008-12-01 18:00:00	IWM	ETF	41.95	41.95	41.85	41.85	1400.0
2008-12-01 19:00:00	IWM	ETF	42.18	42.18	42.18	42.18	200.0
2008-12-01 06:00:00	DIA	ETF	86.77	86.81	86.53	86.53	5092.0
2008-12-01 07:00:00	DIA	ETF	86.78	86.78	86.23	86.43	19816.0
2008-12-01 08:00:00	DIA	ETF	86.43	86.59	86.31	86.58	47864.0
2008-12-01 09:00:00	DIA	ETF	86.55	86.57	84.73	84.79	5551476.0
2008-12-01 10:00:00	DIA	ETF	84.77	85.11	84.31	84.36	4064353.0

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

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