PREVIEW / etf_1hour / 2012-03-14

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-03-14.parquet
  size:    190 KB
  rows:    5,802

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-14 04:00:00	SPY	ETF	139.97	140.06	139.9	140.03	22950.0
2012-03-14 05:00:00	SPY	ETF	140.06	140.2	140.06	140.17	78875.0
2012-03-14 06:00:00	SPY	ETF	140.15	140.37	140.15	140.37	131000.0
2012-03-14 07:00:00	SPY	ETF	140.37	140.39	140.01	140.01	326559.0
2012-03-14 08:00:00	SPY	ETF	140.02	140.21	139.93	140.14	2118548.0
2012-03-14 09:00:00	SPY	ETF	140.13	140.34	140.0	140.29	16891666.0
2012-03-14 10:00:00	SPY	ETF	140.28	140.445	139.98	140.0	26314095.0
2012-03-14 11:00:00	SPY	ETF	140.01	140.043	139.79	139.93	16046327.0
2012-03-14 12:00:00	SPY	ETF	139.93	140.1	139.82	140.07	10337823.0
2012-03-14 13:00:00	SPY	ETF	140.06	140.31	139.67	139.7	17054940.0
2012-03-14 14:00:00	SPY	ETF	139.7	139.84	139.55	139.765	18134768.0
2012-03-14 15:00:00	SPY	ETF	139.7519	139.95	139.48	139.92	25754720.0
2012-03-14 16:00:00	SPY	ETF	139.92	140.42	139.68	139.71	8392123.0
2012-03-14 17:00:00	SPY	ETF	139.7	139.7	139.53	139.6	1246498.0
2012-03-14 18:00:00	SPY	ETF	139.58	139.7	139.55	139.7	114211.0
2012-03-14 19:00:00	SPY	ETF	139.7	139.78	139.7	139.74	50530.0
2012-03-14 04:00:00	QQQ	ETF	66.2	66.2	66.2	66.2	100.0
2012-03-14 06:00:00	QQQ	ETF	66.25	66.37	66.25	66.36	2500.0
2012-03-14 07:00:00	QQQ	ETF	66.36	66.36	66.17	66.18	171069.0
2012-03-14 08:00:00	QQQ	ETF	66.18	66.36	66.17	66.26	954388.0
2012-03-14 09:00:00	QQQ	ETF	66.26	66.53	66.24	66.4601	7677985.0
2012-03-14 10:00:00	QQQ	ETF	66.46	66.64	66.4	66.51	9273821.0
2012-03-14 11:00:00	QQQ	ETF	66.52	66.54	66.35	66.42	4837580.0
2012-03-14 12:00:00	QQQ	ETF	66.43	66.55	66.34	66.528	3500463.0
2012-03-14 13:00:00	QQQ	ETF	66.52	66.74	66.3	66.35	8808307.0
2012-03-14 14:00:00	QQQ	ETF	66.34	66.41	66.08	66.34	8922572.0
2012-03-14 15:00:00	QQQ	ETF	66.33	66.518	66.19	66.51	8978235.0
2012-03-14 16:00:00	QQQ	ETF	66.49	66.5	66.38	66.41	1952563.0
2012-03-14 17:00:00	QQQ	ETF	66.4	66.4	66.34	66.35	9400.0
2012-03-14 18:00:00	QQQ	ETF	66.36	66.39	66.34	66.38	18076.0
2012-03-14 19:00:00	QQQ	ETF	66.38	66.42	66.38	66.42	33680.0
2012-03-14 07:00:00	IWM	ETF	83.19	83.25	82.94	82.95	15858.0
2012-03-14 08:00:00	IWM	ETF	82.93	82.98	82.82	82.98	76914.0
2012-03-14 09:00:00	IWM	ETF	82.96	83.18	82.88	83.12	4563342.0
2012-03-14 10:00:00	IWM	ETF	83.12	83.23	82.55	82.57	7861133.0
2012-03-14 11:00:00	IWM	ETF	82.58	82.65	82.34	82.48	5062055.0
2012-03-14 12:00:00	IWM	ETF	82.49	82.68	82.37	82.65	3315831.0
2012-03-14 13:00:00	IWM	ETF	82.64	82.76	82.17	82.21	8688073.0
2012-03-14 14:00:00	IWM	ETF	82.21	82.4	82.01	82.295	5121948.0
2012-03-14 15:00:00	IWM	ETF	82.29	82.41	82.08	82.38	7752811.0
2012-03-14 16:00:00	IWM	ETF	82.37	82.4	82.21	82.21	1348704.0
2012-03-14 17:00:00	IWM	ETF	82.22	82.22	82.12	82.12	64490.0
2012-03-14 18:00:00	IWM	ETF	82.12	82.31	82.08	82.31	17797.0
2012-03-14 19:00:00	IWM	ETF	82.1	82.1	82.1	82.1	935.0
2012-03-14 05:00:00	DIA	ETF	131.81	131.81	131.81	131.81	100.0
2012-03-14 06:00:00	DIA	ETF	132.05	132.05	132.05	132.05	100.0
2012-03-14 07:00:00	DIA	ETF	132.04	132.04	131.83	131.85	3606.0
2012-03-14 08:00:00	DIA	ETF	131.95	131.95	131.76	131.81	96300.0
2012-03-14 09:00:00	DIA	ETF	131.83	132.06	131.75	132.02	742280.0
2012-03-14 10:00:00	DIA	ETF	132.02	132.17	131.937	131.95	1458432.0

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

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