PREVIEW / etf_1hour / 2009-04-06

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-04-06.parquet
  size:    131 KB
  rows:    4,059

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
2009-04-06 04:00:00	SPY	ETF	84.99	85.08	84.79	84.93	11955.0
2009-04-06 05:00:00	SPY	ETF	84.81	85.0	84.71	84.71	6600.0
2009-04-06 06:00:00	SPY	ETF	84.71	84.81	84.64	84.69	8200.0
2009-04-06 07:00:00	SPY	ETF	84.7	84.7	83.96	84.0	811907.0
2009-04-06 08:00:00	SPY	ETF	84.945	85.1	83.42	83.55	3350728.0
2009-04-06 09:00:00	SPY	ETF	83.54	83.55	82.9	83.17	31011738.0
2009-04-06 10:00:00	SPY	ETF	83.17	84.2747	82.75	82.97	42067696.0
2009-04-06 11:00:00	SPY	ETF	82.97	82.98	82.45	82.5394	27096427.0
2009-04-06 12:00:00	SPY	ETF	82.53	82.77	82.29	82.7203	17765563.0
2009-04-06 13:00:00	SPY	ETF	82.73	82.99	82.42	82.88	23826793.0
2009-04-06 14:00:00	SPY	ETF	82.89	83.22	82.6	83.0	39559440.0
2009-04-06 15:00:00	SPY	ETF	83.0	83.81	82.79	83.51	66662852.0
2009-04-06 16:00:00	SPY	ETF	83.51	83.75	83.1	83.6	4163558.0
2009-04-06 17:00:00	SPY	ETF	83.61	83.78	83.61	83.7	257352.0
2009-04-06 18:00:00	SPY	ETF	83.69	83.76	83.6	83.6	35607.0
2009-04-06 19:00:00	SPY	ETF	83.6	83.65	83.44	83.65	111518.0
2009-04-06 04:00:00	QQQ	ETF	32.59	32.61	32.57	32.57	3831.0
2009-04-06 05:00:00	QQQ	ETF	32.5	32.6	32.5	32.55	2400.0
2009-04-06 06:00:00	QQQ	ETF	32.48	32.49	32.45	32.46	135500.0
2009-04-06 07:00:00	QQQ	ETF	32.44	32.45	32.18	32.18	625298.0
2009-04-06 08:00:00	QQQ	ETF	32.21	32.44	31.88	31.95	2323851.0
2009-04-06 09:00:00	QQQ	ETF	31.95	32.3766	31.75	31.87	22093551.0
2009-04-06 10:00:00	QQQ	ETF	31.86	32.0	31.67	31.75	19778780.0
2009-04-06 11:00:00	QQQ	ETF	31.75	31.85	31.65	31.74	16024217.0
2009-04-06 12:00:00	QQQ	ETF	31.74	31.89	31.66	31.89	9176372.0
2009-04-06 13:00:00	QQQ	ETF	31.89	32.08	31.78	32.0	22591267.0
2009-04-06 14:00:00	QQQ	ETF	32.01	32.16	31.88	32.11	18818123.0
2009-04-06 15:00:00	QQQ	ETF	32.11	32.33	31.9	32.27	30851075.0
2009-04-06 16:00:00	QQQ	ETF	32.27	32.36	31.7429	32.34	6464047.0
2009-04-06 17:00:00	QQQ	ETF	32.34	32.37	32.29	32.29	60782.0
2009-04-06 18:00:00	QQQ	ETF	32.32	32.36	32.27	32.27	40215.0
2009-04-06 19:00:00	QQQ	ETF	32.29	32.32	32.24	32.32	26558.0
2009-04-06 06:00:00	IWM	ETF	45.82	45.83	45.82	45.83	400.0
2009-04-06 07:00:00	IWM	ETF	45.83	45.83	45.45	45.45	24350.0
2009-04-06 08:00:00	IWM	ETF	45.44	45.89	44.95	45.04	160790.0
2009-04-06 09:00:00	IWM	ETF	45.03	45.11	44.46	44.8	8182327.0
2009-04-06 10:00:00	IWM	ETF	44.79	45.01	44.44	44.6	5865736.0
2009-04-06 11:00:00	IWM	ETF	44.6	44.6	44.13	44.19	5525251.0
2009-04-06 12:00:00	IWM	ETF	44.18	44.2726	44.03	44.2726	3841837.0
2009-04-06 13:00:00	IWM	ETF	44.27	44.45	44.05	44.3699	4056616.0
2009-04-06 14:00:00	IWM	ETF	44.37	44.5	44.05	44.35	8269908.0
2009-04-06 15:00:00	IWM	ETF	44.36	44.86	44.2	44.79	13416953.0
2009-04-06 16:00:00	IWM	ETF	44.78	45.5871	44.6797	44.9	11114447.0
2009-04-06 17:00:00	IWM	ETF	44.91	44.97	44.9	44.94	7620.0
2009-04-06 18:00:00	IWM	ETF	44.9	44.9	44.9	44.9	200.0
2009-04-06 19:00:00	IWM	ETF	44.8	44.8	44.76	44.76	1300.0
2009-04-06 05:00:00	DIA	ETF	80.74	80.74	80.74	80.74	100.0
2009-04-06 06:00:00	DIA	ETF	80.64	80.65	80.64	80.65	2600.0
2009-04-06 07:00:00	DIA	ETF	80.58	80.61	80.06	80.09	44655.0
2009-04-06 08:00:00	DIA	ETF	80.7	80.7	79.52	79.7	119372.0

> showing 50 of 4,059 rows — these rows as CSV

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