PREVIEW / etf_1hour / 2012-08-31

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-08-31.parquet
  size:    183 KB
  rows:    5,679

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-08-31 04:00:00	SPY	ETF	140.66	140.7	140.66	140.7	600.0
2012-08-31 05:00:00	SPY	ETF	140.73	140.9	140.73	140.85	3990.0
2012-08-31 06:00:00	SPY	ETF	140.83	141.25	140.83	141.15	217380.0
2012-08-31 07:00:00	SPY	ETF	141.16	141.32	141.14	141.22	371663.0
2012-08-31 08:00:00	SPY	ETF	141.2	141.85	140.86	141.54	2216088.0
2012-08-31 09:00:00	SPY	ETF	141.57	141.59	141.211	141.24	12915596.0
2012-08-31 10:00:00	SPY	ETF	141.24	141.66	140.36	141.6	42145999.0
2012-08-31 11:00:00	SPY	ETF	141.6	141.82	141.46	141.47	14802504.0
2012-08-31 12:00:00	SPY	ETF	141.47	141.52	140.84	141.1	15215922.0
2012-08-31 13:00:00	SPY	ETF	141.1	141.14	140.71	141.02	11987459.0
2012-08-31 14:00:00	SPY	ETF	141.02	141.45	141.02	141.2955	10775959.0
2012-08-31 15:00:00	SPY	ETF	141.3	141.45	140.93	141.16	23992462.0
2012-08-31 16:00:00	SPY	ETF	141.14	141.51	140.4507	140.97	14223175.0
2012-08-31 17:00:00	SPY	ETF	140.99	141.1	140.95	141.0	353523.0
2012-08-31 18:00:00	SPY	ETF	141.0	141.0	140.99	140.99	42860.0
2012-08-31 19:00:00	SPY	ETF	140.98	141.07	140.98	140.99	22948.0
2012-08-31 04:00:00	QQQ	ETF	67.79	67.85	67.79	67.85	300.0
2012-08-31 05:00:00	QQQ	ETF	67.91	67.91	67.91	67.91	200.0
2012-08-31 06:00:00	QQQ	ETF	67.95	68.18	67.95	68.16	11800.0
2012-08-31 07:00:00	QQQ	ETF	68.17	68.2	68.12	68.13	27002.0
2012-08-31 08:00:00	QQQ	ETF	68.14	68.37	68.13	68.34	444415.0
2012-08-31 09:00:00	QQQ	ETF	68.35	68.35	67.97	67.99	5476712.0
2012-08-31 10:00:00	QQQ	ETF	67.99	68.2599	67.47	68.25	10547622.0
2012-08-31 11:00:00	QQQ	ETF	68.25	68.45	68.16	68.16	5427389.0
2012-08-31 12:00:00	QQQ	ETF	68.17	68.21	67.91	68.06	2870289.0
2012-08-31 13:00:00	QQQ	ETF	68.06	68.071	67.85	68.02	1632757.0
2012-08-31 14:00:00	QQQ	ETF	68.02	68.25	67.995	68.19	2205489.0
2012-08-31 15:00:00	QQQ	ETF	68.184	68.25	67.96	68.14	4185322.0
2012-08-31 16:00:00	QQQ	ETF	68.14	68.23	67.6694	68.13	4283386.0
2012-08-31 17:00:00	QQQ	ETF	68.13	68.13	68.1	68.1	390.0
2012-08-31 18:00:00	QQQ	ETF	68.1	68.1	68.08	68.1	600.0
2012-08-31 19:00:00	QQQ	ETF	68.1	68.15	68.1	68.15	9950.0
2012-08-31 04:00:00	IWM	ETF	80.72	80.73	80.72	80.73	2800.0
2012-08-31 06:00:00	IWM	ETF	81.07	81.4	81.07	81.38	1400.0
2012-08-31 07:00:00	IWM	ETF	81.37	81.51	81.37	81.43	229665.0
2012-08-31 08:00:00	IWM	ETF	81.48	81.72	80.81	81.54	340327.0
2012-08-31 09:00:00	IWM	ETF	81.55	81.55	80.89	80.94	3336510.0
2012-08-31 10:00:00	IWM	ETF	80.94	81.27	80.34	81.2	10079863.0
2012-08-31 11:00:00	IWM	ETF	81.21	81.43	81.09	81.09	4259674.0
2012-08-31 12:00:00	IWM	ETF	81.1	81.13	80.77	80.98	2114568.0
2012-08-31 13:00:00	IWM	ETF	80.97	81.11	80.74	81.05	1922683.0
2012-08-31 14:00:00	IWM	ETF	81.05	81.29	81.02	81.21	2022950.0
2012-08-31 15:00:00	IWM	ETF	81.21	81.3	80.98	81.11	5949587.0
2012-08-31 16:00:00	IWM	ETF	81.09	81.2	80.93	81.11	2807302.0
2012-08-31 17:00:00	IWM	ETF	81.06	81.07	81.06	81.07	1532.0
2012-08-31 18:00:00	IWM	ETF	81.09	81.09	81.09	81.09	100.0
2012-08-31 19:00:00	IWM	ETF	81.19	81.19	81.16	81.16	1328.0
2012-08-31 07:00:00	DIA	ETF	130.57	130.57	130.57	130.57	500.0
2012-08-31 08:00:00	DIA	ETF	130.51	130.98	130.51	130.89	14623.0
2012-08-31 09:00:00	DIA	ETF	130.9	131.1	130.62	130.86	501548.0

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

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