PREVIEW / etf_1hour / 2011-09-01

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-09-01.parquet
  size:    180 KB
  rows:    5,566

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-09-01 04:00:00	SPY	ETF	121.93	122.03	121.79	121.85	83500.0
2011-09-01 05:00:00	SPY	ETF	121.76	121.76	121.45	121.73	14785.0
2011-09-01 06:00:00	SPY	ETF	121.78	121.88	121.57	121.64	19672.0
2011-09-01 07:00:00	SPY	ETF	121.71	122.09	121.71	121.95	325634.0
2011-09-01 08:00:00	SPY	ETF	121.9	122.43	121.8	122.37	3682278.0
2011-09-01 09:00:00	SPY	ETF	122.37	122.56	121.69	121.96	24118802.0
2011-09-01 10:00:00	SPY	ETF	121.93	123.4	121.78	122.17	68748397.0
2011-09-01 11:00:00	SPY	ETF	122.18	122.56	121.84	122.455	29954723.0
2011-09-01 12:00:00	SPY	ETF	122.46	122.51	121.97	122.02	16308532.0
2011-09-01 13:00:00	SPY	ETF	122.0111	122.08	121.2	121.29	28332618.0
2011-09-01 14:00:00	SPY	ETF	121.31	121.56	120.95	121.2329	28092318.0
2011-09-01 15:00:00	SPY	ETF	121.23	121.48	120.78	120.93	40716407.0
2011-09-01 16:00:00	SPY	ETF	120.94	122.3139	120.46	120.62	13209412.0
2011-09-01 17:00:00	SPY	ETF	120.63	120.8	120.59	120.73	377534.0
2011-09-01 18:00:00	SPY	ETF	120.73	120.96	120.66	120.7	276929.0
2011-09-01 19:00:00	SPY	ETF	120.66	120.75	120.49	120.55	88661.0
2011-09-01 05:00:00	QQQ	ETF	54.81	55.01	54.79	55.01	1300.0
2011-09-01 06:00:00	QQQ	ETF	54.98	54.98	54.94	54.98	900.0
2011-09-01 07:00:00	QQQ	ETF	54.95	55.06	54.94	55.0	16810.0
2011-09-01 08:00:00	QQQ	ETF	55.0	55.46	54.8	55.21	1421257.0
2011-09-01 09:00:00	QQQ	ETF	55.2	55.33	54.99	55.17	6013464.0
2011-09-01 10:00:00	QQQ	ETF	55.17	55.64	55.09	55.1	15858720.0
2011-09-01 11:00:00	QQQ	ETF	55.1	55.26	54.93	55.22	4825519.0
2011-09-01 12:00:00	QQQ	ETF	55.22	55.23	54.9	54.91	2779107.0
2011-09-01 13:00:00	QQQ	ETF	54.9	54.94	54.59	54.63	5388570.0
2011-09-01 14:00:00	QQQ	ETF	54.63	54.79	54.46	54.65	5805947.0
2011-09-01 15:00:00	QQQ	ETF	54.64	54.77	54.48	54.54	9697353.0
2011-09-01 16:00:00	QQQ	ETF	54.55	54.64	54.45	54.51	3698656.0
2011-09-01 17:00:00	QQQ	ETF	54.51	54.56	54.5	54.53	21800.0
2011-09-01 18:00:00	QQQ	ETF	54.52	54.55	54.52	54.53	27075.0
2011-09-01 19:00:00	QQQ	ETF	54.53	54.55	54.45	54.47	27884.0
2011-09-01 04:00:00	IWM	ETF	72.51	72.52	72.5	72.52	700.0
2011-09-01 06:00:00	IWM	ETF	72.33	72.33	72.25	72.25	300.0
2011-09-01 07:00:00	IWM	ETF	72.25	72.58	72.25	72.43	24970.0
2011-09-01 08:00:00	IWM	ETF	72.4	72.79	72.35	72.76	403389.0
2011-09-01 09:00:00	IWM	ETF	72.74	72.79	72.16	72.39	5819722.0
2011-09-01 10:00:00	IWM	ETF	72.39	73.63	72.27	72.5	23406644.0
2011-09-01 11:00:00	IWM	ETF	72.49	72.83	72.24	72.82	5687528.0
2011-09-01 12:00:00	IWM	ETF	72.82	72.83	72.16	72.16	2636392.0
2011-09-01 13:00:00	IWM	ETF	72.16	72.16	71.17	71.22	7502986.0
2011-09-01 14:00:00	IWM	ETF	71.22	71.44	70.87	71.11	8926951.0
2011-09-01 15:00:00	IWM	ETF	71.1088	71.18	70.69	71.07	14233223.0
2011-09-01 16:00:00	IWM	ETF	71.06	71.17	70.8	70.8	2940796.0
2011-09-01 17:00:00	IWM	ETF	70.86	71.05	70.86	71.01	104385.0
2011-09-01 18:00:00	IWM	ETF	70.96	70.96	70.86	70.86	6600.0
2011-09-01 19:00:00	IWM	ETF	70.9	70.9	70.85	70.85	6600.0
2011-09-01 07:00:00	DIA	ETF	115.78	115.91	115.66	115.91	550.0
2011-09-01 08:00:00	DIA	ETF	115.77	116.16	115.69	116.14	19586.0
2011-09-01 09:00:00	DIA	ETF	116.11	116.27	115.48	115.73	946855.0
2011-09-01 10:00:00	DIA	ETF	115.66	117.03	115.57	116.02	2291137.0

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

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