PREVIEW / etf_1hour / 2008-11-03

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-11-03.parquet
  size:    110 KB
  rows:    3,632

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-11-03 04:00:00	SPY	ETF	97.3	97.41	97.18	97.18	3138.0
2008-11-03 05:00:00	SPY	ETF	97.14	97.21	96.79	96.86	2000.0
2008-11-03 06:00:00	SPY	ETF	96.83	97.41	96.79	97.32	29100.0
2008-11-03 07:00:00	SPY	ETF	97.41	97.63	97.16	97.19	832560.0
2008-11-03 08:00:00	SPY	ETF	97.55	98.15	96.51	96.68	2916086.0
2008-11-03 09:00:00	SPY	ETF	96.69	97.69	96.42	96.98	25938819.0
2008-11-03 10:00:00	SPY	ETF	96.98	97.33	96.3	96.97	42609115.0
2008-11-03 11:00:00	SPY	ETF	96.97	97.46	96.6	97.32	18154268.0
2008-11-03 12:00:00	SPY	ETF	97.3285	97.42	96.76	96.84	18141013.0
2008-11-03 13:00:00	SPY	ETF	96.83	97.22	96.39	96.52	15835029.0
2008-11-03 14:00:00	SPY	ETF	96.5299	96.76	96.0	96.25	30878538.0
2008-11-03 15:00:00	SPY	ETF	96.25	97.22	95.95	96.76	39858767.0
2008-11-03 16:00:00	SPY	ETF	96.71	97.3	96.402	97.25	8262248.0
2008-11-03 17:00:00	SPY	ETF	97.23	97.3	96.91	97.29	1577433.0
2008-11-03 18:00:00	SPY	ETF	97.24	97.35	96.97	97.0	113224.0
2008-11-03 19:00:00	SPY	ETF	97.09	97.35	96.69	96.88	76926.0
2008-11-03 05:00:00	QQQ	ETF	32.87	32.92	32.87	32.92	2100.0
2008-11-03 06:00:00	QQQ	ETF	32.78	32.79	32.69	32.79	17939.0
2008-11-03 07:00:00	QQQ	ETF	32.86	32.96	32.85	32.88	217964.0
2008-11-03 08:00:00	QQQ	ETF	33.15	33.45	32.75	32.85	3108037.0
2008-11-03 09:00:00	QQQ	ETF	32.84	33.12	32.67	32.97	18508450.0
2008-11-03 10:00:00	QQQ	ETF	32.97	33.14	32.79	32.932	24651310.0
2008-11-03 11:00:00	QQQ	ETF	32.94	33.2941	32.82	33.01	12045168.0
2008-11-03 12:00:00	QQQ	ETF	33.01	33.09	32.94	32.98	14675144.0
2008-11-03 13:00:00	QQQ	ETF	32.9874	33.1	32.82	32.85	8568431.0
2008-11-03 14:00:00	QQQ	ETF	32.85	32.87	32.61	32.63	11703353.0
2008-11-03 15:00:00	QQQ	ETF	32.63	32.96	32.51	32.83	26394577.0
2008-11-03 16:00:00	QQQ	ETF	32.81	33.01	32.7	33.0	6613360.0
2008-11-03 17:00:00	QQQ	ETF	33.0	33.0	32.82	32.96	111746.0
2008-11-03 18:00:00	QQQ	ETF	32.97	33.01	32.9	32.9	33031.0
2008-11-03 19:00:00	QQQ	ETF	32.94	32.97	32.83	32.9	29560.0
2008-11-03 07:00:00	IWM	ETF	53.94	53.94	53.67	53.67	29800.0
2008-11-03 08:00:00	IWM	ETF	53.7	53.76	53.35	53.5	291134.0
2008-11-03 09:00:00	IWM	ETF	53.49	54.36	53.38	54.25	7652071.0
2008-11-03 10:00:00	IWM	ETF	54.26	54.6	53.91	54.33	11806057.0
2008-11-03 11:00:00	IWM	ETF	54.34	54.54	54.09	54.4	4278388.0
2008-11-03 12:00:00	IWM	ETF	54.41	54.45	54.02	54.13	4621551.0
2008-11-03 13:00:00	IWM	ETF	54.13	54.39	53.69	53.81	4706136.0
2008-11-03 14:00:00	IWM	ETF	53.8	53.95	53.38	53.68	5764504.0
2008-11-03 15:00:00	IWM	ETF	53.67	54.1	53.39	53.78	9978683.0
2008-11-03 16:00:00	IWM	ETF	53.8	54.35	53.76	54.3	3459516.0
2008-11-03 17:00:00	IWM	ETF	54.26	54.26	53.78	53.78	101500.0
2008-11-03 18:00:00	IWM	ETF	54.05	54.05	54.05	54.05	100.0
2008-11-03 06:00:00	DIA	ETF	93.35	93.35	93.35	93.35	100.0
2008-11-03 07:00:00	DIA	ETF	93.69	93.87	93.55	93.55	24218.0
2008-11-03 08:00:00	DIA	ETF	93.57	93.59	92.98	93.14	43318.0
2008-11-03 09:00:00	DIA	ETF	93.11	94.08	92.92	93.46	2465187.0
2008-11-03 10:00:00	DIA	ETF	93.45	93.81	92.75	93.42	4483157.0
2008-11-03 11:00:00	DIA	ETF	93.42	93.88	93.0	93.77	2049407.0
2008-11-03 12:00:00	DIA	ETF	93.79	93.84	93.29	93.34	1986837.0

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

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