PREVIEW / etf_1hour / 2011-07-19

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-07-19.parquet
  size:    184 KB
  rows:    5,641

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
2011-07-19 04:00:00	SPY	ETF	131.21	131.35	131.2	131.35	4208.0
2011-07-19 05:00:00	SPY	ETF	131.37	131.58	131.3	131.3	3950.0
2011-07-19 06:00:00	SPY	ETF	131.3	131.45	131.3	131.38	18800.0
2011-07-19 07:00:00	SPY	ETF	131.39	131.53	131.27	131.44	944580.0
2011-07-19 08:00:00	SPY	ETF	131.42	131.57	131.0	131.32	6105810.0
2011-07-19 09:00:00	SPY	ETF	131.32	131.92	131.17	131.77	20471659.0
2011-07-19 10:00:00	SPY	ETF	131.77	132.11	131.73	131.94	17051264.0
2011-07-19 11:00:00	SPY	ETF	131.94	131.95	131.51	131.65	17907662.0
2011-07-19 12:00:00	SPY	ETF	131.65	131.93	131.6	131.82	13479834.0
2011-07-19 13:00:00	SPY	ETF	131.82	132.63	131.62	132.43	25345319.0
2011-07-19 14:00:00	SPY	ETF	132.42	132.82	132.24	132.73	22483585.0
2011-07-19 15:00:00	SPY	ETF	132.73	132.89	132.59	132.72	29559355.0
2011-07-19 16:00:00	SPY	ETF	132.74	132.95	132.1346	132.74	10854260.0
2011-07-19 17:00:00	SPY	ETF	132.75	132.81	132.66	132.78	492167.0
2011-07-19 18:00:00	SPY	ETF	132.79	132.79	132.69	132.73	561037.0
2011-07-19 19:00:00	SPY	ETF	132.73	132.89	132.69	132.89	108213.0
2011-07-19 20:00:00	SPY	ETF	132.86	132.86	132.86	132.86	200.0
2011-07-19 04:00:00	QQQ	ETF	57.79	57.79	57.79	57.79	300.0
2011-07-19 05:00:00	QQQ	ETF	57.93	57.99	57.91	57.94	25600.0
2011-07-19 06:00:00	QQQ	ETF	57.91	57.91	57.86	57.86	2400.0
2011-07-19 07:00:00	QQQ	ETF	57.9	57.96	57.9	57.93	12760.0
2011-07-19 08:00:00	QQQ	ETF	57.94	58.15	57.83	58.14	4049556.0
2011-07-19 09:00:00	QQQ	ETF	58.15	58.55	58.03	58.46	12001789.0
2011-07-19 10:00:00	QQQ	ETF	58.46	58.64	58.42	58.53	5614147.0
2011-07-19 11:00:00	QQQ	ETF	58.53	58.54	58.36	58.465	5840770.0
2011-07-19 12:00:00	QQQ	ETF	58.465	58.55	58.41	58.52	4334565.0
2011-07-19 13:00:00	QQQ	ETF	58.52	58.79	58.4	58.69	5459770.0
2011-07-19 14:00:00	QQQ	ETF	58.69	58.84	58.63	58.8	6275159.0
2011-07-19 15:00:00	QQQ	ETF	58.805	58.9	58.73	58.86	11943340.0
2011-07-19 16:00:00	QQQ	ETF	58.86	59.24	58.63	59.07	9568449.0
2011-07-19 17:00:00	QQQ	ETF	59.07	59.16	59.06	59.14	525303.0
2011-07-19 18:00:00	QQQ	ETF	59.13	59.13	58.6096	59.07	162591.0
2011-07-19 19:00:00	QQQ	ETF	59.07	59.12	59.05	59.11	39960.0
2011-07-19 04:00:00	IWM	ETF	81.99	81.99	81.97	81.98	684.0
2011-07-19 05:00:00	IWM	ETF	82.1	82.1	82.1	82.1	705.0
2011-07-19 06:00:00	IWM	ETF	82.0	82.04	82.0	82.04	15000.0
2011-07-19 07:00:00	IWM	ETF	82.06	82.14	81.98	82.1	85925.0
2011-07-19 08:00:00	IWM	ETF	82.1	82.34	81.85	82.29	2350771.0
2011-07-19 09:00:00	IWM	ETF	82.26	82.83	82.16	82.65	9258764.0
2011-07-19 10:00:00	IWM	ETF	82.66	82.9	82.61	82.7815	5553905.0
2011-07-19 11:00:00	IWM	ETF	82.79	82.81	82.39	82.58	5644120.0
2011-07-19 12:00:00	IWM	ETF	82.58	82.68	82.41	82.53	2678239.0
2011-07-19 13:00:00	IWM	ETF	82.53	83.03	82.37	82.93	6612886.0
2011-07-19 14:00:00	IWM	ETF	82.92	83.2	82.81	83.18	5755061.0
2011-07-19 15:00:00	IWM	ETF	83.17	83.41	83.15	83.33	9302412.0
2011-07-19 16:00:00	IWM	ETF	83.33	83.48	83.11	83.22	2494934.0
2011-07-19 17:00:00	IWM	ETF	83.27	83.3	83.18	83.18	186848.0
2011-07-19 18:00:00	IWM	ETF	83.22	83.28	83.07	83.12	102625.0
2011-07-19 19:00:00	IWM	ETF	83.19	83.25	83.18	83.25	7600.0
2011-07-19 06:00:00	DIA	ETF	124.05	124.05	124.05	124.05	100.0

> showing 50 of 5,641 rows — these rows as CSV

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