PREVIEW / etf_1hour / 2012-04-13

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-04-13.parquet
  size:    180 KB
  rows:    5,582

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-04-13 04:00:00	SPY	ETF	138.68	138.68	138.36	138.4	5120.0
2012-04-13 05:00:00	SPY	ETF	138.43	138.51	138.22	138.46	53983.0
2012-04-13 06:00:00	SPY	ETF	138.41	138.92	138.41	138.9	255030.0
2012-04-13 07:00:00	SPY	ETF	138.9	139.01	138.43	138.43	715316.0
2012-04-13 08:00:00	SPY	ETF	138.43	138.94	138.22	138.54	2065692.0
2012-04-13 09:00:00	SPY	ETF	138.53	138.8708	137.87	137.92	22003197.0
2012-04-13 10:00:00	SPY	ETF	137.9201	138.08	137.35	137.57	29049382.0
2012-04-13 11:00:00	SPY	ETF	137.57	137.93	137.41	137.74	19776002.0
2012-04-13 12:00:00	SPY	ETF	137.73	137.85	137.57	137.78	9875314.0
2012-04-13 13:00:00	SPY	ETF	137.775	138.8168	137.66	137.6705	9574623.0
2012-04-13 14:00:00	SPY	ETF	137.68	137.84	137.55	137.71	14018805.0
2012-04-13 15:00:00	SPY	ETF	137.7	137.9	137.01	137.13	35984804.0
2012-04-13 16:00:00	SPY	ETF	137.13	138.8172	136.8668	136.96	20135422.0
2012-04-13 17:00:00	SPY	ETF	137.078	137.14	136.94	137.12	1946645.0
2012-04-13 18:00:00	SPY	ETF	137.12	137.23	137.09	137.1	167727.0
2012-04-13 19:00:00	SPY	ETF	137.1	137.11	136.96	136.96	29330.0
2012-04-13 05:00:00	QQQ	ETF	67.02	67.02	67.02	67.02	150.0
2012-04-13 06:00:00	QQQ	ETF	67.07	67.12	67.07	67.11	14300.0
2012-04-13 07:00:00	QQQ	ETF	67.19	67.19	66.98	66.98	128200.0
2012-04-13 08:00:00	QQQ	ETF	66.98	67.12	66.92	67.02	237489.0
2012-04-13 09:00:00	QQQ	ETF	67.02	67.02	66.68	66.7495	7107886.0
2012-04-13 10:00:00	QQQ	ETF	66.74	66.8393	66.17	66.3814	10256769.0
2012-04-13 11:00:00	QQQ	ETF	66.38	66.6	66.235	66.45	9777136.0
2012-04-13 12:00:00	QQQ	ETF	66.45	66.49	66.379	66.469	3818752.0
2012-04-13 13:00:00	QQQ	ETF	66.46	66.59	66.4	66.43	4063004.0
2012-04-13 14:00:00	QQQ	ETF	66.43	66.51	66.36	66.41	5055807.0
2012-04-13 15:00:00	QQQ	ETF	66.41	66.56	66.16	66.19	7889281.0
2012-04-13 16:00:00	QQQ	ETF	66.18	66.4346	66.09	66.1	1674808.0
2012-04-13 17:00:00	QQQ	ETF	66.1	66.19	66.09	66.19	35100.0
2012-04-13 18:00:00	QQQ	ETF	66.19	66.2	66.17	66.18	6000.0
2012-04-13 19:00:00	QQQ	ETF	66.2	66.2	66.15	66.15	11830.0
2012-04-13 04:00:00	IWM	ETF	80.41	80.41	80.41	80.41	2000.0
2012-04-13 06:00:00	IWM	ETF	80.54	80.54	80.54	80.54	1000.0
2012-04-13 07:00:00	IWM	ETF	80.83	80.97	80.44	80.45	277343.0
2012-04-13 08:00:00	IWM	ETF	80.44	80.5	80.28	80.49	701200.0
2012-04-13 09:00:00	IWM	ETF	80.48	80.48	79.88	79.92	6364619.0
2012-04-13 10:00:00	IWM	ETF	79.93	79.99	79.43	79.6677	10228605.0
2012-04-13 11:00:00	IWM	ETF	79.66	79.88	79.52	79.7	6838685.0
2012-04-13 12:00:00	IWM	ETF	79.71	79.74	79.54	79.67	2984633.0
2012-04-13 13:00:00	IWM	ETF	79.66	79.92	79.62	79.76	2807828.0
2012-04-13 14:00:00	IWM	ETF	79.76	79.79	79.51	79.55	6390943.0
2012-04-13 15:00:00	IWM	ETF	79.55	79.75	79.45	79.56	6959589.0
2012-04-13 16:00:00	IWM	ETF	79.56	79.7	79.37	79.45	1564373.0
2012-04-13 17:00:00	IWM	ETF	79.45	79.5	79.45	79.5	2263.0
2012-04-13 18:00:00	IWM	ETF	79.65	79.65	79.65	79.65	928.0
2012-04-13 19:00:00	IWM	ETF	79.43	79.43	79.4	79.4	400.0
2012-04-13 07:00:00	DIA	ETF	129.6	129.6	129.39	129.39	4400.0
2012-04-13 08:00:00	DIA	ETF	129.4	129.41	129.2	129.39	14300.0
2012-04-13 09:00:00	DIA	ETF	129.38	129.4	128.82	128.85	939454.0
2012-04-13 10:00:00	DIA	ETF	128.85	129.02	128.6	128.74	1663162.0

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

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