PREVIEW / etf_1hour / 2012-03-12

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-03-12.parquet
  size:    179 KB
  rows:    5,583

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-12 04:00:00	SPY	ETF	137.22	137.38	137.2	137.38	23580.0
2012-03-12 05:00:00	SPY	ETF	137.57	137.68	137.57	137.68	18400.0
2012-03-12 06:00:00	SPY	ETF	137.63	137.65	137.57	137.57	22700.0
2012-03-12 07:00:00	SPY	ETF	137.55	137.64	137.47	137.53	252729.0
2012-03-12 08:00:00	SPY	ETF	137.53	137.65	137.25	137.48	903031.0
2012-03-12 09:00:00	SPY	ETF	137.47	137.76	137.39	137.52	13797066.0
2012-03-12 10:00:00	SPY	ETF	137.51	137.54	137.17	137.35	21715329.0
2012-03-12 11:00:00	SPY	ETF	137.35	137.42	137.17	137.2	14557078.0
2012-03-12 12:00:00	SPY	ETF	137.19	137.46	137.09	137.38	11326086.0
2012-03-12 13:00:00	SPY	ETF	137.37	137.67	137.29	137.535	7984667.0
2012-03-12 14:00:00	SPY	ETF	137.535	137.64	137.48	137.63	6944984.0
2012-03-12 15:00:00	SPY	ETF	137.63	137.69	137.4515	137.57	16968173.0
2012-03-12 16:00:00	SPY	ETF	137.57	137.76	137.25	137.72	7287885.0
2012-03-12 17:00:00	SPY	ETF	137.73	137.82	137.72	137.78	152380.0
2012-03-12 18:00:00	SPY	ETF	137.76	137.79	137.71	137.78	45165.0
2012-03-12 19:00:00	SPY	ETF	137.77	137.83	137.76	137.79	85226.0
2012-03-12 07:00:00	QQQ	ETF	64.95	64.99	64.91	64.93	31800.0
2012-03-12 08:00:00	QQQ	ETF	64.95	64.96	64.84	64.94	413020.0
2012-03-12 09:00:00	QQQ	ETF	64.94	65.11	64.929	65.05	4144166.0
2012-03-12 10:00:00	QQQ	ETF	65.05	65.06	64.78	64.86	7091145.0
2012-03-12 11:00:00	QQQ	ETF	64.86	64.9	64.72	64.82	4991279.0
2012-03-12 12:00:00	QQQ	ETF	64.82	64.98	64.78	64.95	2590569.0
2012-03-12 13:00:00	QQQ	ETF	64.95	65.08	64.89	65.0062	2587364.0
2012-03-12 14:00:00	QQQ	ETF	65.0	65.06	64.96	65.02	1683204.0
2012-03-12 15:00:00	QQQ	ETF	65.019	65.04	64.93	65.03	4329520.0
2012-03-12 16:00:00	QQQ	ETF	65.03	65.14	65.02	65.11	566359.0
2012-03-12 17:00:00	QQQ	ETF	65.1	65.1	65.1	65.1	200.0
2012-03-12 18:00:00	QQQ	ETF	65.1	65.11	65.08	65.09	18300.0
2012-03-12 19:00:00	QQQ	ETF	65.1	65.14	65.09	65.13	10560.0
2012-03-12 07:00:00	IWM	ETF	81.76	81.8	81.68	81.7	144353.0
2012-03-12 08:00:00	IWM	ETF	81.93	81.93	81.52	81.6	228639.0
2012-03-12 09:00:00	IWM	ETF	81.6	81.93	81.51	81.65	3926919.0
2012-03-12 10:00:00	IWM	ETF	81.66	81.67	81.17	81.33	7005713.0
2012-03-12 11:00:00	IWM	ETF	81.33	81.42	81.05	81.29	6273758.0
2012-03-12 12:00:00	IWM	ETF	81.28	81.46	81.12	81.26	2970683.0
2012-03-12 13:00:00	IWM	ETF	81.265	81.57	81.19	81.38	1619358.0
2012-03-12 14:00:00	IWM	ETF	81.3887	81.55	81.35	81.4703	1581462.0
2012-03-12 15:00:00	IWM	ETF	81.48	81.5	81.23	81.4287	5459532.0
2012-03-12 16:00:00	IWM	ETF	81.44	81.61	81.3741	81.58	857896.0
2012-03-12 17:00:00	IWM	ETF	81.57	81.64	81.57	81.64	800.0
2012-03-12 18:00:00	IWM	ETF	81.6	81.6	81.56	81.56	3305.0
2012-03-12 19:00:00	IWM	ETF	81.6	81.6	81.56	81.56	243.0
2012-03-12 04:00:00	DIA	ETF	128.98	128.98	128.98	128.98	100.0
2012-03-12 07:00:00	DIA	ETF	129.17	129.17	129.15	129.16	500.0
2012-03-12 08:00:00	DIA	ETF	129.03	129.03	128.95	128.97	1610.0
2012-03-12 09:00:00	DIA	ETF	129.14	129.53	129.1	129.38	426394.0
2012-03-12 10:00:00	DIA	ETF	129.39	129.44	129.12	129.33	677377.0
2012-03-12 11:00:00	DIA	ETF	129.34	129.42	129.21	129.3	1682343.0
2012-03-12 12:00:00	DIA	ETF	129.2828	129.47	129.18	129.4	631201.0
2012-03-12 13:00:00	DIA	ETF	129.4	129.64	129.34	129.521	414759.0

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

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