PREVIEW / etf_1hour / 2012-06-27

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-06-27.parquet
  size:    177 KB
  rows:    5,445

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-06-27 04:00:00	SPY	ETF	132.07	132.09	132.07	132.09	1000.0
2012-06-27 05:00:00	SPY	ETF	132.11	132.15	132.03	132.1	3100.0
2012-06-27 06:00:00	SPY	ETF	132.24	132.35	132.11	132.23	65523.0
2012-06-27 07:00:00	SPY	ETF	132.28	132.43	132.26	132.41	148739.0
2012-06-27 08:00:00	SPY	ETF	132.39	132.51	132.12	132.19	1128842.0
2012-06-27 09:00:00	SPY	ETF	132.18	132.74	132.09	132.63	15164075.0
2012-06-27 10:00:00	SPY	ETF	132.62	133.18	132.5	133.0	20585029.0
2012-06-27 11:00:00	SPY	ETF	132.995	133.22	132.71	133.1	13512522.0
2012-06-27 12:00:00	SPY	ETF	133.11	133.35	133.09	133.22	7582566.0
2012-06-27 13:00:00	SPY	ETF	133.2197	133.33	132.93	133.03	8515355.0
2012-06-27 14:00:00	SPY	ETF	133.04	133.08	132.83	132.93	8456171.0
2012-06-27 15:00:00	SPY	ETF	132.92	133.43	132.89	133.18	21285269.0
2012-06-27 16:00:00	SPY	ETF	133.17	133.2852	131.966	133.16	10694312.0
2012-06-27 17:00:00	SPY	ETF	133.14	133.16	133.07	133.1	60150.0
2012-06-27 18:00:00	SPY	ETF	133.08	133.19	133.07	133.1	50651.0
2012-06-27 19:00:00	SPY	ETF	133.1	133.1	133.01	133.05	46490.0
2012-06-27 20:00:00	SPY	ETF	133.04	133.04	133.03	133.03	9200.0
2012-06-27 07:00:00	QQQ	ETF	62.68	62.7	62.64	62.7	71220.0
2012-06-27 08:00:00	QQQ	ETF	62.71	62.77	62.6	62.61	151825.0
2012-06-27 09:00:00	QQQ	ETF	62.63	62.955	62.6	62.8	3799656.0
2012-06-27 10:00:00	QQQ	ETF	62.8	63.18	62.7599	63.0499	6421170.0
2012-06-27 11:00:00	QQQ	ETF	63.049	63.12	62.91	63.02	3454459.0
2012-06-27 12:00:00	QQQ	ETF	63.02	63.15	63.01	63.02	2697864.0
2012-06-27 13:00:00	QQQ	ETF	63.028	63.06	62.7701	62.83	2429521.0
2012-06-27 14:00:00	QQQ	ETF	62.82	62.855	62.7	62.78	2396830.0
2012-06-27 15:00:00	QQQ	ETF	62.78	63.07	62.75	62.9099	6026630.0
2012-06-27 16:00:00	QQQ	ETF	62.91	62.97	62.515	62.88	5095344.0
2012-06-27 17:00:00	QQQ	ETF	62.87	62.87	62.86	62.86	3500.0
2012-06-27 18:00:00	QQQ	ETF	62.87	62.87	62.85	62.86	4585.0
2012-06-27 19:00:00	QQQ	ETF	62.86	62.86	62.81	62.82	8907.0
2012-06-27 07:00:00	IWM	ETF	76.33	76.33	76.28	76.28	2200.0
2012-06-27 08:00:00	IWM	ETF	76.36	76.44	76.03	76.22	153029.0
2012-06-27 09:00:00	IWM	ETF	76.21	76.78	76.17	76.57	4093525.0
2012-06-27 10:00:00	IWM	ETF	76.61	77.08	76.52	76.9328	7298353.0
2012-06-27 11:00:00	IWM	ETF	76.94	77.26	76.77	77.15	4170326.0
2012-06-27 12:00:00	IWM	ETF	77.15	77.37	77.14	77.18	3510111.0
2012-06-27 13:00:00	IWM	ETF	77.175	77.33	77.04	77.15	2950359.0
2012-06-27 14:00:00	IWM	ETF	77.14	77.19	77.01	77.11	3071901.0
2012-06-27 15:00:00	IWM	ETF	77.11	77.46	77.085	77.38	10210594.0
2012-06-27 16:00:00	IWM	ETF	77.38	77.48	77.3241	77.41	1867318.0
2012-06-27 17:00:00	IWM	ETF	77.41	77.44	77.4	77.4	2700.0
2012-06-27 18:00:00	IWM	ETF	77.39	77.39	77.39	77.39	664.0
2012-06-27 19:00:00	IWM	ETF	77.36	77.42	77.36	77.42	5740.0
2012-06-27 08:00:00	DIA	ETF	125.28	125.28	125.2	125.2	300.0
2012-06-27 09:00:00	DIA	ETF	125.23	125.6214	125.23	125.56	460873.0
2012-06-27 10:00:00	DIA	ETF	125.58	126.07	125.46	125.91	623253.0
2012-06-27 11:00:00	DIA	ETF	125.93	126.0239	125.65	125.94	407149.0
2012-06-27 12:00:00	DIA	ETF	125.9401	126.12	125.93	125.99	316000.0
2012-06-27 13:00:00	DIA	ETF	125.98	126.12	125.87	125.94	380612.0
2012-06-27 14:00:00	DIA	ETF	125.94	125.99	125.8257	125.9	252843.0

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

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