PREVIEW / etf_1hour / 2012-12-27

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-12-27.parquet
  size:    195 KB
  rows:    6,005

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-12-27 04:00:00	SPY	ETF	141.64	141.66	141.64	141.64	44350.0
2012-12-27 05:00:00	SPY	ETF	141.69	141.73	141.6	141.7	23070.0
2012-12-27 06:00:00	SPY	ETF	141.72	141.98	141.72	141.95	85148.0
2012-12-27 07:00:00	SPY	ETF	141.97	142.08	141.89	141.92	71860.0
2012-12-27 08:00:00	SPY	ETF	141.92	142.08	141.67	141.86	934230.0
2012-12-27 09:00:00	SPY	ETF	141.85	142.08	141.6	141.729	9538684.0
2012-12-27 10:00:00	SPY	ETF	141.72	141.72	140.61	140.87	29130018.0
2012-12-27 11:00:00	SPY	ETF	140.86	141.01	140.47	140.57	16605388.0
2012-12-27 12:00:00	SPY	ETF	140.575	140.6	139.92	140.38	18694068.0
2012-12-27 13:00:00	SPY	ETF	140.39	141.7498	140.17	140.26	14917369.0
2012-12-27 14:00:00	SPY	ETF	140.26	141.1	140.06	140.99	26261591.0
2012-12-27 15:00:00	SPY	ETF	141.0	141.92	140.87	141.5899	38384051.0
2012-12-27 16:00:00	SPY	ETF	141.57	141.72	140.7612	141.69	11026653.0
2012-12-27 17:00:00	SPY	ETF	141.69	141.74	141.49	141.64	353688.0
2012-12-27 18:00:00	SPY	ETF	141.61	141.93	141.61	141.74	158047.0
2012-12-27 19:00:00	SPY	ETF	141.76	141.76	141.65	141.72	41738.0
2012-12-27 06:00:00	QQQ	ETF	64.57	64.62	64.57	64.62	6800.0
2012-12-27 07:00:00	QQQ	ETF	64.62	64.64	64.6	64.6	8440.0
2012-12-27 08:00:00	QQQ	ETF	64.62	64.62	64.54	64.59	172923.0
2012-12-27 09:00:00	QQQ	ETF	64.58	64.6	64.36	64.48	4153426.0
2012-12-27 10:00:00	QQQ	ETF	64.48	64.481	63.95	64.17	6139336.0
2012-12-27 11:00:00	QQQ	ETF	64.18	64.27	63.86	63.9	4000900.0
2012-12-27 12:00:00	QQQ	ETF	63.91	63.94	63.6	63.8	5202441.0
2012-12-27 13:00:00	QQQ	ETF	63.8	64.0	63.76	63.79	4906014.0
2012-12-27 14:00:00	QQQ	ETF	63.785	64.2	63.701	64.17	5085310.0
2012-12-27 15:00:00	QQQ	ETF	64.18	64.64	64.13	64.41	9959307.0
2012-12-27 16:00:00	QQQ	ETF	64.41	64.5828	64.0426	64.41	4724240.0
2012-12-27 17:00:00	QQQ	ETF	64.4	64.536	64.35	64.35	2432950.0
2012-12-27 18:00:00	QQQ	ETF	64.37	64.49	64.37	64.45	21145.0
2012-12-27 19:00:00	QQQ	ETF	64.45	64.45	64.42	64.44	9265.0
2012-12-27 04:00:00	IWM	ETF	83.19	83.25	83.19	83.25	1000.0
2012-12-27 07:00:00	IWM	ETF	83.44	83.44	83.37	83.37	3200.0
2012-12-27 08:00:00	IWM	ETF	83.37	83.39	83.26	83.34	98118.0
2012-12-27 09:00:00	IWM	ETF	83.34	83.435	83.09	83.32	2135720.0
2012-12-27 10:00:00	IWM	ETF	83.32	83.32	82.72	82.87	5058205.0
2012-12-27 11:00:00	IWM	ETF	82.878	82.93	82.51	82.55	3803647.0
2012-12-27 12:00:00	IWM	ETF	82.54	82.58	82.05	82.2	3830444.0
2012-12-27 13:00:00	IWM	ETF	82.2	82.565	82.16	82.26	2725220.0
2012-12-27 14:00:00	IWM	ETF	82.25	82.73	82.12	82.7	5450672.0
2012-12-27 15:00:00	IWM	ETF	82.7	83.29	82.665	83.13	9727629.0
2012-12-27 16:00:00	IWM	ETF	83.1	83.2	82.7592	83.05	1860262.0
2012-12-27 17:00:00	IWM	ETF	83.06	83.06	83.0	83.06	6161.0
2012-12-27 18:00:00	IWM	ETF	83.05	83.08	83.02	83.05	7820.0
2012-12-27 19:00:00	IWM	ETF	83.02	83.02	83.0	83.0	200.0
2012-12-27 08:00:00	DIA	ETF	131.06	131.06	131.03	131.03	1083.0
2012-12-27 09:00:00	DIA	ETF	130.92	131.14	130.78	130.91	537452.0
2012-12-27 10:00:00	DIA	ETF	130.88	130.88	129.82	130.12	1149207.0
2012-12-27 11:00:00	DIA	ETF	130.13	130.25	129.81	129.97	688899.0
2012-12-27 12:00:00	DIA	ETF	129.97	129.974	129.34	129.73	722208.0
2012-12-27 13:00:00	DIA	ETF	129.73	129.89	129.48	129.54	717254.0

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

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