PREVIEW / etf_1hour / 2011-07-01

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-07-01.parquet
  size:    181 KB
  rows:    5,550

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
2011-07-01 04:00:00	SPY	ETF	131.65	132.02	131.65	132.02	4600.0
2011-07-01 05:00:00	SPY	ETF	131.97	132.01	131.87	131.89	15072.0
2011-07-01 06:00:00	SPY	ETF	132.03	132.15	132.01	132.05	58330.0
2011-07-01 07:00:00	SPY	ETF	132.03	132.1	131.9	132.01	765223.0
2011-07-01 08:00:00	SPY	ETF	131.98	132.18	131.8778	132.0	2604875.0
2011-07-01 09:00:00	SPY	ETF	131.99	132.15	131.78	132.11	22241030.0
2011-07-01 10:00:00	SPY	ETF	132.11	133.23	132.09	132.96	57244199.0
2011-07-01 11:00:00	SPY	ETF	132.96	133.28	132.93	133.19	17435352.0
2011-07-01 12:00:00	SPY	ETF	133.19	133.4	133.13	133.37	11572161.0
2011-07-01 13:00:00	SPY	ETF	133.37	133.74	133.32	133.68	17142813.0
2011-07-01 14:00:00	SPY	ETF	133.67	134.01	133.59	133.97	16808828.0
2011-07-01 15:00:00	SPY	ETF	133.96	134.1	133.74	133.91	39240528.0
2011-07-01 16:00:00	SPY	ETF	133.92	134.01	132.4	133.91	15094532.0
2011-07-01 17:00:00	SPY	ETF	133.89	134.05	133.86	133.99	250406.0
2011-07-01 18:00:00	SPY	ETF	133.98	134.09	133.93	134.01	420017.0
2011-07-01 19:00:00	SPY	ETF	133.98	134.02	133.97	134.0	14993.0
2011-07-01 05:00:00	QQQ	ETF	57.02	57.02	57.02	57.02	1100.0
2011-07-01 06:00:00	QQQ	ETF	57.17	57.17	57.06	57.08	4400.0
2011-07-01 07:00:00	QQQ	ETF	57.08	57.12	57.03	57.05	13590.0
2011-07-01 08:00:00	QQQ	ETF	57.05	57.13	57.03	57.04	216409.0
2011-07-01 09:00:00	QQQ	ETF	57.05	57.18	56.92	57.16	4097458.0
2011-07-01 10:00:00	QQQ	ETF	57.15	57.5	57.14	57.45	13281197.0
2011-07-01 11:00:00	QQQ	ETF	57.46	57.65	57.42	57.605	4695325.0
2011-07-01 12:00:00	QQQ	ETF	57.605	57.73	57.58	57.685	4284057.0
2011-07-01 13:00:00	QQQ	ETF	57.68	57.89	57.66	57.86	4744074.0
2011-07-01 14:00:00	QQQ	ETF	57.865	57.975	57.8	57.96	3691872.0
2011-07-01 15:00:00	QQQ	ETF	57.96	57.985	57.83	57.91	7945278.0
2011-07-01 16:00:00	QQQ	ETF	57.91	58.0	57.75	57.77	2125708.0
2011-07-01 17:00:00	QQQ	ETF	57.77	57.86	57.77	57.7984	20504.0
2011-07-01 18:00:00	QQQ	ETF	57.93	57.93	57.82	57.85	93481.0
2011-07-01 19:00:00	QQQ	ETF	57.85	57.89	57.85	57.88	24133.0
2011-07-01 04:00:00	IWM	ETF	82.9	82.9	82.85	82.85	6200.0
2011-07-01 06:00:00	IWM	ETF	83.0	83.11	83.0	83.03	2000.0
2011-07-01 07:00:00	IWM	ETF	82.97	83.02	82.9	82.9	39808.0
2011-07-01 08:00:00	IWM	ETF	82.91	83.03	82.8	82.83	287302.0
2011-07-01 09:00:00	IWM	ETF	82.81	83.02	82.62	82.98	9011635.0
2011-07-01 10:00:00	IWM	ETF	82.98	83.83	82.97	83.635	16170381.0
2011-07-01 11:00:00	IWM	ETF	83.63	83.81	83.59	83.73	5239311.0
2011-07-01 12:00:00	IWM	ETF	83.72	83.96	83.69	83.915	3197703.0
2011-07-01 13:00:00	IWM	ETF	83.92	84.13	83.89	84.06	5052400.0
2011-07-01 14:00:00	IWM	ETF	84.07	84.23	84.01	84.21	3779677.0
2011-07-01 15:00:00	IWM	ETF	84.2	84.23	83.96	84.07	9258299.0
2011-07-01 16:00:00	IWM	ETF	84.07	84.21	83.97	84.0	2726278.0
2011-07-01 17:00:00	IWM	ETF	84.04	84.04	83.96	84.03	45935.0
2011-07-01 18:00:00	IWM	ETF	84.04	84.04	84.04	84.04	2900.0
2011-07-01 19:00:00	IWM	ETF	84.03	84.03	84.03	84.03	300.0
2011-07-01 04:00:00	DIA	ETF	123.84	123.84	123.84	123.84	100.0
2011-07-01 07:00:00	DIA	ETF	124.01	124.08	123.96	123.96	105000.0
2011-07-01 08:00:00	DIA	ETF	123.98	124.12	123.95	124.01	135571.0
2011-07-01 09:00:00	DIA	ETF	123.98	124.13	123.8	124.1	758649.0

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

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