PREVIEW / etf_1hour / 2011-08-30

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-08-30.parquet
  size:    182 KB
  rows:    5,637

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-08-30 04:00:00	SPY	ETF	121.32	121.32	120.79	120.85	8699.0
2011-08-30 05:00:00	SPY	ETF	120.85	120.89	120.46	120.73	30830.0
2011-08-30 06:00:00	SPY	ETF	120.68	120.88	120.46	120.88	89548.0
2011-08-30 07:00:00	SPY	ETF	120.85	120.93	120.61	120.65	499819.0
2011-08-30 08:00:00	SPY	ETF	120.67	120.69	120.18	120.36	2521948.0
2011-08-30 09:00:00	SPY	ETF	120.36	121.1918	120.34	120.78	23482497.0
2011-08-30 10:00:00	SPY	ETF	120.78	120.86	119.26	120.59	48778038.0
2011-08-30 11:00:00	SPY	ETF	120.59	121.87	120.47	121.64	31778783.0
2011-08-30 12:00:00	SPY	ETF	121.64	121.68	120.78	120.92	20739890.0
2011-08-30 13:00:00	SPY	ETF	120.93	121.32	120.75	121.08	20628558.0
2011-08-30 14:00:00	SPY	ETF	121.08	121.9	120.85	121.85	31397825.0
2011-08-30 15:00:00	SPY	ETF	121.84	122.43	121.6	121.63	44772419.0
2011-08-30 16:00:00	SPY	ETF	121.62	122.2667	120.89	120.94	13595246.0
2011-08-30 17:00:00	SPY	ETF	120.96	121.6939	120.8	120.9	1128459.0
2011-08-30 18:00:00	SPY	ETF	120.9	121.62	120.77	120.81	241516.0
2011-08-30 19:00:00	SPY	ETF	120.81	120.9	120.72	120.9	187775.0
2011-08-30 04:00:00	QQQ	ETF	54.47	54.47	54.42	54.42	1000.0
2011-08-30 05:00:00	QQQ	ETF	54.39	54.39	54.26	54.26	3076.0
2011-08-30 06:00:00	QQQ	ETF	54.4	54.4	54.39	54.39	8908.0
2011-08-30 07:00:00	QQQ	ETF	54.47	54.48	54.37	54.37	47049.0
2011-08-30 08:00:00	QQQ	ETF	54.37	54.39	54.17	54.21	579076.0
2011-08-30 09:00:00	QQQ	ETF	54.19	54.68	54.19	54.52	7957738.0
2011-08-30 10:00:00	QQQ	ETF	54.49	54.59	54.11	54.5	13190577.0
2011-08-30 11:00:00	QQQ	ETF	54.49	55.06	54.44	55.04	7240643.0
2011-08-30 12:00:00	QQQ	ETF	55.04	55.05	54.58	54.66	7025592.0
2011-08-30 13:00:00	QQQ	ETF	54.6563	54.8517	54.57	54.74	4259938.0
2011-08-30 14:00:00	QQQ	ETF	54.74	55.121	54.66	55.1001	7175715.0
2011-08-30 15:00:00	QQQ	ETF	55.1	55.3	54.94	54.95	9571327.0
2011-08-30 16:00:00	QQQ	ETF	54.96	54.985	54.64	54.69	1408472.0
2011-08-30 17:00:00	QQQ	ETF	54.68	54.68	54.61	54.66	31799.0
2011-08-30 18:00:00	QQQ	ETF	54.65	54.97	54.61	54.65	59104.0
2011-08-30 19:00:00	QQQ	ETF	54.65	54.65	54.61	54.63	35490.0
2011-08-30 04:00:00	IWM	ETF	72.0	72.0	71.96	71.96	200.0
2011-08-30 05:00:00	IWM	ETF	71.83	71.83	71.83	71.83	100.0
2011-08-30 06:00:00	IWM	ETF	71.75	71.75	71.75	71.75	200.0
2011-08-30 07:00:00	IWM	ETF	72.0	72.0	71.8	71.83	42425.0
2011-08-30 08:00:00	IWM	ETF	71.84	71.92	71.57	71.57	540487.0
2011-08-30 09:00:00	IWM	ETF	71.57	72.32	71.56	71.9	10123929.0
2011-08-30 10:00:00	IWM	ETF	71.9	72.27	71.12	71.95	11990648.0
2011-08-30 11:00:00	IWM	ETF	71.95	72.89	71.84	72.81	7469044.0
2011-08-30 12:00:00	IWM	ETF	72.8	72.83	71.76	71.95	6897397.0
2011-08-30 13:00:00	IWM	ETF	71.94	72.2	71.8	72.11	4271978.0
2011-08-30 14:00:00	IWM	ETF	72.09	72.8	71.93	72.78	7757236.0
2011-08-30 15:00:00	IWM	ETF	72.77	73.265	72.61	72.72	10979183.0
2011-08-30 16:00:00	IWM	ETF	72.73	72.83	71.6707	72.26	2203780.0
2011-08-30 17:00:00	IWM	ETF	72.26	72.26	72.16	72.25	146310.0
2011-08-30 18:00:00	IWM	ETF	72.25	72.28	72.19	72.19	10300.0
2011-08-30 19:00:00	IWM	ETF	72.16	72.21	72.16	72.16	19699.0
2011-08-30 07:00:00	DIA	ETF	114.75	114.79	114.58	114.63	11850.0
2011-08-30 08:00:00	DIA	ETF	114.75	114.75	114.31	114.33	21460.0

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

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