PREVIEW / etf_1hour / 2012-03-27

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-03-27.parquet
  size:    185 KB
  rows:    5,769

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-03-27 04:00:00	SPY	ETF	142.29	142.35	142.25	142.25	910.0
2012-03-27 05:00:00	SPY	ETF	142.3	142.39	142.03	142.03	42108.0
2012-03-27 06:00:00	SPY	ETF	142.03	142.1	141.97	142.1	48700.0
2012-03-27 07:00:00	SPY	ETF	141.96	142.05	141.71	141.71	540555.0
2012-03-27 08:00:00	SPY	ETF	141.7	142.2	141.66	141.85	3463076.0
2012-03-27 09:00:00	SPY	ETF	141.87	141.93	141.63	141.78	15264869.0
2012-03-27 10:00:00	SPY	ETF	141.79	141.82	141.45	141.475	20984221.0
2012-03-27 11:00:00	SPY	ETF	141.48	141.65	141.45	141.63	12536216.0
2012-03-27 12:00:00	SPY	ETF	141.63	141.75	141.511	141.64	8630364.0
2012-03-27 13:00:00	SPY	ETF	141.634	141.68	141.43	141.6	9321688.0
2012-03-27 14:00:00	SPY	ETF	141.6	141.72	141.56	141.64	6886979.0
2012-03-27 15:00:00	SPY	ETF	141.63	141.71	141.08	141.16	22696600.0
2012-03-27 16:00:00	SPY	ETF	141.16	141.6738	141.01	141.04	14506695.0
2012-03-27 17:00:00	SPY	ETF	141.03	141.05	140.94	140.98	183745.0
2012-03-27 18:00:00	SPY	ETF	140.98	141.09	140.94	141.08	96399.0
2012-03-27 19:00:00	SPY	ETF	141.09	141.18	141.06	141.16	190615.0
2012-03-27 05:00:00	QQQ	ETF	68.22	68.22	68.22	68.22	1000.0
2012-03-27 07:00:00	QQQ	ETF	68.17	68.22	68.09	68.09	13340.0
2012-03-27 08:00:00	QQQ	ETF	68.09	68.24	68.08	68.16	924662.0
2012-03-27 09:00:00	QQQ	ETF	68.18	68.27	68.12	68.2	6914567.0
2012-03-27 10:00:00	QQQ	ETF	68.21	68.4	68.13	68.2413	6780328.0
2012-03-27 11:00:00	QQQ	ETF	68.25	68.36	68.24	68.328	2891849.0
2012-03-27 12:00:00	QQQ	ETF	68.33	68.4	68.321	68.395	2287554.0
2012-03-27 13:00:00	QQQ	ETF	68.39	68.45	68.3	68.43	1994484.0
2012-03-27 14:00:00	QQQ	ETF	68.43	68.49	68.4	68.45	2204741.0
2012-03-27 15:00:00	QQQ	ETF	68.45	68.49	68.168	68.21	7318010.0
2012-03-27 16:00:00	QQQ	ETF	68.21	68.334	68.15	68.17	2258974.0
2012-03-27 17:00:00	QQQ	ETF	68.16	68.18	68.13	68.13	19376.0
2012-03-27 18:00:00	QQQ	ETF	68.14	68.16	68.1	68.16	18171.0
2012-03-27 19:00:00	QQQ	ETF	68.16	68.22	68.16	68.19	12230.0
2012-03-27 07:00:00	IWM	ETF	84.62	84.66	84.56	84.56	4788.0
2012-03-27 08:00:00	IWM	ETF	84.57	84.71	84.44	84.6	413558.0
2012-03-27 09:00:00	IWM	ETF	84.58	84.66	84.36	84.56	5808960.0
2012-03-27 10:00:00	IWM	ETF	84.57	84.6	84.19	84.24	6466151.0
2012-03-27 11:00:00	IWM	ETF	84.25	84.36	84.15	84.315	3144976.0
2012-03-27 12:00:00	IWM	ETF	84.315	84.36	84.11	84.265	2788745.0
2012-03-27 13:00:00	IWM	ETF	84.269	84.33	84.15	84.295	2252563.0
2012-03-27 14:00:00	IWM	ETF	84.3	84.41	84.24	84.28	2993655.0
2012-03-27 15:00:00	IWM	ETF	84.28	84.33	83.75	83.79	9687949.0
2012-03-27 16:00:00	IWM	ETF	83.78	84.2718	83.72	83.79	1397933.0
2012-03-27 17:00:00	IWM	ETF	83.81	83.81	83.67	83.67	420859.0
2012-03-27 18:00:00	IWM	ETF	83.68	83.68	83.68	83.68	200.0
2012-03-27 05:00:00	DIA	ETF	132.1	132.1	132.1	132.1	100.0
2012-03-27 07:00:00	DIA	ETF	132.37	132.37	132.35	132.35	200.0
2012-03-27 08:00:00	DIA	ETF	132.16	132.5	132.16	132.4	94000.0
2012-03-27 09:00:00	DIA	ETF	132.37	132.37	132.155	132.24	514491.0
2012-03-27 10:00:00	DIA	ETF	132.25	132.25	131.93	131.971	916037.0
2012-03-27 11:00:00	DIA	ETF	131.988	132.17	131.96	132.15	518676.0
2012-03-27 12:00:00	DIA	ETF	132.15	132.25	132.05	132.14	300610.0
2012-03-27 13:00:00	DIA	ETF	132.13	132.18	131.98	132.08	228296.0

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

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