PREVIEW / etf_1hour / 2012-05-18

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-05-18.parquet
  size:    196 KB
  rows:    6,092

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
2012-05-18 04:00:00	SPY	ETF	130.58	131.06	130.58	130.88	2350.0
2012-05-18 05:00:00	SPY	ETF	130.93	131.3	130.62	131.27	42039.0
2012-05-18 06:00:00	SPY	ETF	131.21	131.35	131.13	131.21	55003.0
2012-05-18 07:00:00	SPY	ETF	131.23	131.55	131.21	131.29	1191746.0
2012-05-18 08:00:00	SPY	ETF	131.27	131.48	130.87	131.23	3248495.0
2012-05-18 09:00:00	SPY	ETF	131.23	131.44	130.86	131.07	30451058.0
2012-05-18 10:00:00	SPY	ETF	131.07	131.6	130.88	131.4	35765988.0
2012-05-18 11:00:00	SPY	ETF	131.405	131.475	130.2	130.46	68532930.0
2012-05-18 12:00:00	SPY	ETF	130.46	131.14	130.46	130.86	45107489.0
2012-05-18 13:00:00	SPY	ETF	130.86	131.0	130.335	130.3539	20598544.0
2012-05-18 14:00:00	SPY	ETF	130.36	130.46	129.84	130.03	25952894.0
2012-05-18 15:00:00	SPY	ETF	130.02	130.41	129.55	129.82	55456751.0
2012-05-18 16:00:00	SPY	ETF	129.8	131.14	129.51	129.59	31317367.0
2012-05-18 17:00:00	SPY	ETF	129.58	129.71	129.5437	129.7	802808.0
2012-05-18 18:00:00	SPY	ETF	129.71	129.74	129.6	129.63	69043.0
2012-05-18 19:00:00	SPY	ETF	129.63	129.68	129.6	129.62	58177.0
2012-05-18 20:00:00	SPY	ETF	129.61	129.61	129.61	129.61	129.0
2012-05-18 04:00:00	QQQ	ETF	61.75	61.75	61.75	61.75	100.0
2012-05-18 05:00:00	QQQ	ETF	61.6	61.8	61.6	61.8	200.0
2012-05-18 06:00:00	QQQ	ETF	61.76	61.88	61.72	61.8	21290.0
2012-05-18 07:00:00	QQQ	ETF	61.87	61.95	61.79	61.81	176361.0
2012-05-18 08:00:00	QQQ	ETF	61.8	61.86	61.29	61.69	3577285.0
2012-05-18 09:00:00	QQQ	ETF	61.69	61.86	61.39	61.52	8704651.0
2012-05-18 10:00:00	QQQ	ETF	61.52	61.96	61.43	61.8775	11418989.0
2012-05-18 11:00:00	QQQ	ETF	61.88	61.92	61.01	61.26	17911807.0
2012-05-18 12:00:00	QQQ	ETF	61.25	61.805	61.25	61.58	9205693.0
2012-05-18 13:00:00	QQQ	ETF	61.58	61.61	61.19	61.23	4120516.0
2012-05-18 14:00:00	QQQ	ETF	61.23	61.34	60.96	61.08	6898517.0
2012-05-18 15:00:00	QQQ	ETF	61.08	61.25	60.76	60.84	13642723.0
2012-05-18 16:00:00	QQQ	ETF	60.84	62.8583	60.65	60.71	1855154.0
2012-05-18 17:00:00	QQQ	ETF	60.71	60.78	60.71	60.75	27721.0
2012-05-18 18:00:00	QQQ	ETF	60.75	60.8	60.75	60.8	4800.0
2012-05-18 19:00:00	QQQ	ETF	60.8	60.82	60.76	60.76	16914.0
2012-05-18 05:00:00	IWM	ETF	75.36	75.77	75.36	75.77	3400.0
2012-05-18 06:00:00	IWM	ETF	75.78	75.85	75.78	75.78	5125.0
2012-05-18 07:00:00	IWM	ETF	75.83	75.98	75.68	75.7	55275.0
2012-05-18 08:00:00	IWM	ETF	75.72	75.95	75.68	75.78	292004.0
2012-05-18 09:00:00	IWM	ETF	75.74	75.81	75.27	75.36	9780957.0
2012-05-18 10:00:00	IWM	ETF	75.35	75.91	75.19	75.7	11789751.0
2012-05-18 11:00:00	IWM	ETF	75.7	75.765	74.6	74.9	13269825.0
2012-05-18 12:00:00	IWM	ETF	74.905	75.6101	74.9	75.4201	7629422.0
2012-05-18 13:00:00	IWM	ETF	75.41	75.465	75.19	75.26	4917108.0
2012-05-18 14:00:00	IWM	ETF	75.26	75.3201	74.8	74.85	6774482.0
2012-05-18 15:00:00	IWM	ETF	74.84	75.11	74.49	74.67	15354346.0
2012-05-18 16:00:00	IWM	ETF	74.67	75.259	74.44	74.49	3410546.0
2012-05-18 17:00:00	IWM	ETF	74.49	74.58	74.49	74.5	25670.0
2012-05-18 18:00:00	IWM	ETF	74.58	74.58	74.5	74.51	3600.0
2012-05-18 19:00:00	IWM	ETF	74.5	74.63	74.5	74.63	4782.0
2012-05-18 04:00:00	DIA	ETF	124.42	124.43	124.32	124.32	700.0
2012-05-18 05:00:00	DIA	ETF	124.1	124.1	124.1	124.1	500.0

> showing 50 of 6,092 rows — these rows as CSV

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