PREVIEW / etf_1hour / 2008-11-18

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-11-18.parquet
  size:    114 KB
  rows:    3,713

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-18 04:00:00	SPY	ETF	83.81	84.08	83.6	83.7	10873.0
2008-11-18 05:00:00	SPY	ETF	83.68	84.14	83.68	84.13	4750.0
2008-11-18 06:00:00	SPY	ETF	84.1	84.11	83.4	83.92	47150.0
2008-11-18 07:00:00	SPY	ETF	83.89	84.27	83.8	84.05	763014.0
2008-11-18 08:00:00	SPY	ETF	84.06	85.38	83.75	84.98	8923728.0
2008-11-18 09:00:00	SPY	ETF	84.98	86.24	84.76	85.5888	51302820.0
2008-11-18 10:00:00	SPY	ETF	85.58	86.85	84.84	86.16	62745177.0
2008-11-18 11:00:00	SPY	ETF	86.16	87.0	85.48	86.9	40697845.0
2008-11-18 12:00:00	SPY	ETF	86.9	86.9	85.1	85.38	37490442.0
2008-11-18 13:00:00	SPY	ETF	85.37	85.39	83.48	84.64	75535982.0
2008-11-18 14:00:00	SPY	ETF	84.64	86.35	82.91	83.21	77421050.0
2008-11-18 15:00:00	SPY	ETF	83.2	86.26	83.1	86.2	145537287.0
2008-11-18 16:00:00	SPY	ETF	86.2	87.25	83.955	86.8	19868436.0
2008-11-18 17:00:00	SPY	ETF	86.8	86.9	85.3871	86.65	1264676.0
2008-11-18 18:00:00	SPY	ETF	86.65	86.69	86.42	86.42	744204.0
2008-11-18 19:00:00	SPY	ETF	86.4	86.5	86.12	86.18	114911.0
2008-11-18 04:00:00	QQQ	ETF	27.97	27.99	27.97	27.99	200.0
2008-11-18 05:00:00	QQQ	ETF	27.94	27.94	27.93	27.93	1250.0
2008-11-18 06:00:00	QQQ	ETF	27.95	27.96	27.83	27.9	17000.0
2008-11-18 07:00:00	QQQ	ETF	27.9	28.1	27.9	28.01	363872.0
2008-11-18 08:00:00	QQQ	ETF	28.02	28.68	27.94	28.54	5244154.0
2008-11-18 09:00:00	QQQ	ETF	28.54	28.75	28.28	28.41	26080505.0
2008-11-18 10:00:00	QQQ	ETF	28.41	28.71	28.19	28.53	32515063.0
2008-11-18 11:00:00	QQQ	ETF	28.53	28.65	28.25	28.6399	24503781.0
2008-11-18 12:00:00	QQQ	ETF	28.63	28.63	28.11	28.15	19166184.0
2008-11-18 13:00:00	QQQ	ETF	28.15	28.15	27.55	27.77	36957375.0
2008-11-18 14:00:00	QQQ	ETF	27.77	27.92	27.39	27.47	32055345.0
2008-11-18 15:00:00	QQQ	ETF	27.47	28.39	27.44	28.34	62995608.0
2008-11-18 16:00:00	QQQ	ETF	28.34	28.91	27.9978	28.72	10287758.0
2008-11-18 17:00:00	QQQ	ETF	28.72	28.74	28.66	28.71	463577.0
2008-11-18 18:00:00	QQQ	ETF	28.71	28.71	28.67	28.68	72511.0
2008-11-18 19:00:00	QQQ	ETF	28.68	28.69	28.52	28.52	74327.0
2008-11-18 05:00:00	IWM	ETF	44.44	44.44	44.44	44.44	2500.0
2008-11-18 07:00:00	IWM	ETF	44.49	44.54	44.28	44.39	18825.0
2008-11-18 08:00:00	IWM	ETF	44.38	45.35	44.38	45.05	554106.0
2008-11-18 09:00:00	IWM	ETF	45.1	45.83	44.96	45.35	8982856.0
2008-11-18 10:00:00	IWM	ETF	45.34	45.57	44.89	45.25	8666145.0
2008-11-18 11:00:00	IWM	ETF	45.27	45.99	44.97	45.83	9034300.0
2008-11-18 12:00:00	IWM	ETF	45.83	45.86	44.53	44.77	7723786.0
2008-11-18 13:00:00	IWM	ETF	44.75	44.75	43.61	43.98	12879689.0
2008-11-18 14:00:00	IWM	ETF	43.98	44.12	43.1	43.29	13680829.0
2008-11-18 15:00:00	IWM	ETF	43.29	45.02	43.2	44.93	28601906.0
2008-11-18 16:00:00	IWM	ETF	44.92	45.65	44.02	45.52	7472721.0
2008-11-18 17:00:00	IWM	ETF	45.48	45.48	45.4	45.4	32500.0
2008-11-18 18:00:00	IWM	ETF	45.34	45.52	45.34	45.52	3915.0
2008-11-18 19:00:00	IWM	ETF	45.33	45.33	44.81	44.81	8340.0
2008-11-18 04:00:00	DIA	ETF	82.09	82.09	82.09	82.09	100.0
2008-11-18 06:00:00	DIA	ETF	81.88	81.89	81.88	81.89	1000.0
2008-11-18 07:00:00	DIA	ETF	81.86	81.92	81.72	81.87	3300.0
2008-11-18 08:00:00	DIA	ETF	81.87	83.26	81.83	82.92	279366.0

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

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