PREVIEW / etf_1hour / 2013-03-27

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-03-27.parquet
  size:    197 KB
  rows:    6,090

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
2013-03-27 04:00:00	SPY	ETF	156.33	156.35	156.15	156.22	4300.0
2013-03-27 05:00:00	SPY	ETF	156.28	156.29	155.74	155.74	66250.0
2013-03-27 06:00:00	SPY	ETF	155.76	155.89	155.46	155.59	355186.0
2013-03-27 07:00:00	SPY	ETF	155.55	155.59	155.28	155.39	683475.0
2013-03-27 08:00:00	SPY	ETF	155.39	155.59	155.22	155.39	1183834.0
2013-03-27 09:00:00	SPY	ETF	155.4	155.5	155.0	155.26	14557725.0
2013-03-27 10:00:00	SPY	ETF	155.26	155.72	155.1	155.59	17690244.0
2013-03-27 11:00:00	SPY	ETF	155.59	155.97	155.51	155.815	12619966.0
2013-03-27 12:00:00	SPY	ETF	155.84	155.93	155.73	155.8117	7960674.0
2013-03-27 13:00:00	SPY	ETF	155.81	155.95	155.6	155.931	10465474.0
2013-03-27 14:00:00	SPY	ETF	155.931	156.14	155.9	156.071	11405421.0
2013-03-27 15:00:00	SPY	ETF	156.0712	156.245	155.95	156.13	15839732.0
2013-03-27 16:00:00	SPY	ETF	156.14	156.18	155.4494	156.12	6418266.0
2013-03-27 17:00:00	SPY	ETF	156.11	156.14	156.08	156.1	60571.0
2013-03-27 18:00:00	SPY	ETF	156.1	156.12	156.0	156.06	43742.0
2013-03-27 19:00:00	SPY	ETF	156.06	156.07	155.98	155.99	47018.0
2013-03-27 04:00:00	QQQ	ETF	68.78	68.78	68.78	68.78	1000.0
2013-03-27 05:00:00	QQQ	ETF	68.7	68.7	68.67	68.67	2500.0
2013-03-27 06:00:00	QQQ	ETF	68.61	68.61	68.49	68.5	3100.0
2013-03-27 07:00:00	QQQ	ETF	68.49	68.49	68.35	68.37	18600.0
2013-03-27 08:00:00	QQQ	ETF	68.39	68.46	68.34	68.4	102959.0
2013-03-27 09:00:00	QQQ	ETF	68.38	68.44	68.14	68.35	3625849.0
2013-03-27 10:00:00	QQQ	ETF	68.35	68.61	68.19	68.54	4288102.0
2013-03-27 11:00:00	QQQ	ETF	68.54	68.69	68.485	68.62	3003984.0
2013-03-27 12:00:00	QQQ	ETF	68.63	68.65	68.5301	68.5981	1721350.0
2013-03-27 13:00:00	QQQ	ETF	68.6	68.68	68.52	68.68	1278445.0
2013-03-27 14:00:00	QQQ	ETF	68.68	68.81	68.6643	68.77	2708333.0
2013-03-27 15:00:00	QQQ	ETF	68.76	68.85	68.715	68.82	3726065.0
2013-03-27 16:00:00	QQQ	ETF	68.82	68.8572	68.6175	68.77	830483.0
2013-03-27 17:00:00	QQQ	ETF	68.77	68.8	68.74	68.78	10000.0
2013-03-27 18:00:00	QQQ	ETF	68.75	68.77	68.72	68.77	3752.0
2013-03-27 19:00:00	QQQ	ETF	68.71	68.73	68.7	68.71	18883.0
2013-03-27 06:00:00	IWM	ETF	94.01	94.01	93.86	93.9	400.0
2013-03-27 07:00:00	IWM	ETF	93.91	93.92	93.6	93.6	80699.0
2013-03-27 08:00:00	IWM	ETF	93.62	93.72	93.56	93.63	180276.0
2013-03-27 09:00:00	IWM	ETF	93.64	93.71	93.42	93.46	4666386.0
2013-03-27 10:00:00	IWM	ETF	93.45	93.89	93.24	93.73	5869980.0
2013-03-27 11:00:00	IWM	ETF	93.73	94.17	93.7	94.05	2956307.0
2013-03-27 12:00:00	IWM	ETF	94.07	94.12	93.89	93.96	1779539.0
2013-03-27 13:00:00	IWM	ETF	93.969	94.1	93.85	94.09	1465009.0
2013-03-27 14:00:00	IWM	ETF	94.08	94.269	94.02	94.22	2516738.0
2013-03-27 15:00:00	IWM	ETF	94.22	94.38	94.14	94.32	5733373.0
2013-03-27 16:00:00	IWM	ETF	94.32	94.3877	94.21	94.35	994263.0
2013-03-27 17:00:00	IWM	ETF	94.35	94.35	94.33	94.34	4200.0
2013-03-27 18:00:00	IWM	ETF	94.27	94.3	94.27	94.3	650.0
2013-03-27 19:00:00	IWM	ETF	94.32	94.32	94.3	94.3	7200.0
2013-03-27 05:00:00	DIA	ETF	144.8	144.8	144.8	144.8	120.0
2013-03-27 06:00:00	DIA	ETF	144.61	144.74	144.61	144.73	25470.0
2013-03-27 07:00:00	DIA	ETF	144.52	144.52	144.52	144.52	1000.0
2013-03-27 08:00:00	DIA	ETF	144.53	144.61	144.42	144.55	21143.0

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

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