PREVIEW / etf_1hour / 2008-08-22

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-08-22.parquet
  size:    105 KB
  rows:    3,386

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-08-22 05:00:00	SPY	ETF	128.02	128.18	128.02	128.02	1300.0
2008-08-22 06:00:00	SPY	ETF	128.0	128.02	128.0	128.02	3000.0
2008-08-22 07:00:00	SPY	ETF	128.01	129.09	128.01	128.85	2689337.0
2008-08-22 08:00:00	SPY	ETF	128.84	128.98	128.33	128.86	5200004.0
2008-08-22 09:00:00	SPY	ETF	128.84	129.24	128.56	129.15	27754829.0
2008-08-22 10:00:00	SPY	ETF	129.15	129.645	128.92	129.27	30824138.0
2008-08-22 11:00:00	SPY	ETF	129.28	129.4	128.93	129.05	19501244.0
2008-08-22 12:00:00	SPY	ETF	129.06	129.06	128.59	128.97	16568432.0
2008-08-22 13:00:00	SPY	ETF	128.97	129.391	128.93	129.28	14839868.0
2008-08-22 14:00:00	SPY	ETF	129.28	129.5	128.97	129.19	18870793.0
2008-08-22 15:00:00	SPY	ETF	129.19	129.56	129.02	129.52	24196128.0
2008-08-22 16:00:00	SPY	ETF	129.45	129.67	128.62	129.6	4642807.0
2008-08-22 17:00:00	SPY	ETF	129.61	129.65	129.5	129.54	50676.0
2008-08-22 18:00:00	SPY	ETF	129.53	129.54	129.46	129.49	19409.0
2008-08-22 19:00:00	SPY	ETF	129.49	129.58	129.49	129.58	27596.0
2008-08-22 04:00:00	QQQ	ETF	46.92	46.92	46.92	46.92	100.0
2008-08-22 05:00:00	QQQ	ETF	46.98	46.98	46.98	46.98	300.0
2008-08-22 06:00:00	QQQ	ETF	47.0	47.0	47.0	47.0	100.0
2008-08-22 07:00:00	QQQ	ETF	46.97	47.36	46.95	47.25	862616.0
2008-08-22 08:00:00	QQQ	ETF	47.26	47.27	47.06	47.17	2547620.0
2008-08-22 09:00:00	QQQ	ETF	47.16	47.4	47.08	47.31	15622120.0
2008-08-22 10:00:00	QQQ	ETF	47.32	47.56	47.24	47.3999	19241525.0
2008-08-22 11:00:00	QQQ	ETF	47.392	47.45	47.3	47.37	8772879.0
2008-08-22 12:00:00	QQQ	ETF	47.37	47.37	47.17	47.36	8486575.0
2008-08-22 13:00:00	QQQ	ETF	47.36	47.53	47.335	47.5	8371277.0
2008-08-22 14:00:00	QQQ	ETF	47.51	47.68	47.41	47.55	8885970.0
2008-08-22 15:00:00	QQQ	ETF	47.55	47.6	47.46	47.49	11875277.0
2008-08-22 16:00:00	QQQ	ETF	47.49	47.6	46.9083	47.45	9652475.0
2008-08-22 17:00:00	QQQ	ETF	47.46	47.49	47.45	47.48	50085.0
2008-08-22 18:00:00	QQQ	ETF	47.46	47.46	47.43	47.45	7580.0
2008-08-22 19:00:00	QQQ	ETF	47.45	47.45	47.45	47.45	2000.0
2008-08-22 05:00:00	IWM	ETF	72.32	72.32	72.32	72.32	100.0
2008-08-22 07:00:00	IWM	ETF	72.3	72.94	72.3	72.8	384407.0
2008-08-22 08:00:00	IWM	ETF	72.78	72.84	72.61	72.77	604309.0
2008-08-22 09:00:00	IWM	ETF	72.78	73.38	72.62	73.37	13604930.0
2008-08-22 10:00:00	IWM	ETF	73.37	73.68	73.2	73.33	15259731.0
2008-08-22 11:00:00	IWM	ETF	73.33	73.38	73.03	73.11	6739693.0
2008-08-22 12:00:00	IWM	ETF	73.11	73.12	72.74	73.12	6621855.0
2008-08-22 13:00:00	IWM	ETF	73.11	73.39	73.1	73.34	5725769.0
2008-08-22 14:00:00	IWM	ETF	73.35	73.63	73.12	73.41	9218558.0
2008-08-22 15:00:00	IWM	ETF	73.41	73.81	73.31	73.62	12114409.0
2008-08-22 16:00:00	IWM	ETF	73.66	73.77	72.4	73.65	6158529.0
2008-08-22 17:00:00	IWM	ETF	73.68	73.68	73.65	73.65	204.0
2008-08-22 18:00:00	IWM	ETF	73.64	73.66	73.64	73.66	200.0
2008-08-22 07:00:00	DIA	ETF	114.31	115.0	114.31	114.98	1600.0
2008-08-22 08:00:00	DIA	ETF	114.91	115.12	114.82	115.12	49362.0
2008-08-22 09:00:00	DIA	ETF	115.14	115.73	114.84	115.64	2359649.0
2008-08-22 10:00:00	DIA	ETF	115.64	116.37	115.32	116.2	4648748.0
2008-08-22 11:00:00	DIA	ETF	116.18	116.28	115.8	115.95	2375577.0
2008-08-22 12:00:00	DIA	ETF	115.95	115.96	115.55	115.87	2195034.0

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

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