PREVIEW / etf_1hour / 2008-12-03

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-12-03.parquet
  size:    115 KB
  rows:    3,758

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-03 04:00:00	SPY	ETF	83.72	83.92	83.69	83.82	3800.0
2008-12-03 05:00:00	SPY	ETF	83.89	83.9	83.75	83.9	28200.0
2008-12-03 06:00:00	SPY	ETF	84.21	84.4	83.7	84.09	194684.0
2008-12-03 07:00:00	SPY	ETF	84.2	84.73	83.97	84.12	1173819.0
2008-12-03 08:00:00	SPY	ETF	84.11	84.51	83.39	83.64	4819952.0
2008-12-03 09:00:00	SPY	ETF	83.62	84.15	83.1	83.49	37746827.0
2008-12-03 10:00:00	SPY	ETF	83.5	86.23	83.14	86.18	75900259.0
2008-12-03 11:00:00	SPY	ETF	86.18	86.95	85.82	86.86	65149339.0
2008-12-03 12:00:00	SPY	ETF	86.86	86.87	85.55	86.07	48589345.0
2008-12-03 13:00:00	SPY	ETF	86.08	86.14	83.97	84.23	49063214.0
2008-12-03 14:00:00	SPY	ETF	84.23	86.63	83.9	85.7612	94628780.0
2008-12-03 15:00:00	SPY	ETF	85.76	87.83	85.18	87.5	108185309.0
2008-12-03 16:00:00	SPY	ETF	87.49	87.6258	85.3392	87.35	32469540.0
2008-12-03 17:00:00	SPY	ETF	87.34	87.35	85.3392	87.08	1215353.0
2008-12-03 18:00:00	SPY	ETF	87.09	87.39	87.07	87.1	166593.0
2008-12-03 19:00:00	SPY	ETF	87.1	87.16	86.99	87.06	97897.0
2008-12-03 04:00:00	QQQ	ETF	27.39	27.39	27.39	27.39	1150.0
2008-12-03 06:00:00	QQQ	ETF	27.45	27.52	27.4	27.4	15078.0
2008-12-03 07:00:00	QQQ	ETF	27.5	27.58	27.24	27.25	646551.0
2008-12-03 08:00:00	QQQ	ETF	27.26	27.32	27.14	27.2	2431247.0
2008-12-03 09:00:00	QQQ	ETF	27.19	27.49	26.99	27.33	16910112.0
2008-12-03 10:00:00	QQQ	ETF	27.32	28.32	27.2	28.29	38763002.0
2008-12-03 11:00:00	QQQ	ETF	28.29	28.53	28.16	28.4321	33055158.0
2008-12-03 12:00:00	QQQ	ETF	28.44	28.45	28.05	28.24	18034427.0
2008-12-03 13:00:00	QQQ	ETF	28.24	28.25	27.57	27.65	18749036.0
2008-12-03 14:00:00	QQQ	ETF	27.65	28.47	27.51	28.2095	36253730.0
2008-12-03 15:00:00	QQQ	ETF	28.2	28.71	28.0	28.6	52221903.0
2008-12-03 16:00:00	QQQ	ETF	28.6	28.62	28.46	28.52	4263604.0
2008-12-03 17:00:00	QQQ	ETF	28.49	28.49	28.41	28.43	78545.0
2008-12-03 18:00:00	QQQ	ETF	28.43	28.48	28.38	28.41	54702.0
2008-12-03 19:00:00	QQQ	ETF	28.41	28.42	28.35	28.35	40660.0
2008-12-03 06:00:00	IWM	ETF	43.8	43.8	43.8	43.8	500.0
2008-12-03 07:00:00	IWM	ETF	43.9	44.04	43.89	44.04	13300.0
2008-12-03 08:00:00	IWM	ETF	43.65	43.65	43.28	43.41	167809.0
2008-12-03 09:00:00	IWM	ETF	43.4	44.02	43.02	43.61	7087426.0
2008-12-03 10:00:00	IWM	ETF	43.61	45.6	43.31	45.53	17094915.0
2008-12-03 11:00:00	IWM	ETF	45.53	45.89	45.08	45.55	11053540.0
2008-12-03 12:00:00	IWM	ETF	45.56	45.58	44.44	44.88	9786162.0
2008-12-03 13:00:00	IWM	ETF	44.88	44.94	43.45	43.58	9669684.0
2008-12-03 14:00:00	IWM	ETF	43.58	45.37	43.51	44.8	15807162.0
2008-12-03 15:00:00	IWM	ETF	44.8	45.69	44.32	45.54	23934914.0
2008-12-03 16:00:00	IWM	ETF	45.53	45.59	44.5	45.45	5090092.0
2008-12-03 17:00:00	IWM	ETF	45.41	45.45	45.37	45.37	5254.0
2008-12-03 18:00:00	IWM	ETF	45.37	45.37	45.37	45.37	195.0
2008-12-03 19:00:00	IWM	ETF	45.38	45.38	45.38	45.38	1000.0
2008-12-03 06:00:00	DIA	ETF	83.3	83.32	83.08	83.08	344.0
2008-12-03 07:00:00	DIA	ETF	83.42	83.84	83.28	83.41	9544.0
2008-12-03 08:00:00	DIA	ETF	83.37	83.41	82.72	83.0	64518.0
2008-12-03 09:00:00	DIA	ETF	82.92	83.4	82.46	82.76	4647139.0
2008-12-03 10:00:00	DIA	ETF	82.72	84.98	82.44	84.94	6318421.0

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

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