PREVIEW / etf_1hour / 2011-05-19

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-05-19.parquet
  size:    176 KB
  rows:    5,372

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-05-19 04:00:00	SPY	ETF	134.3	134.36	134.18	134.25	8720.0
2011-05-19 05:00:00	SPY	ETF	134.36	134.94	134.36	134.89	9999.0
2011-05-19 06:00:00	SPY	ETF	134.84	134.95	134.73	134.83	51150.0
2011-05-19 07:00:00	SPY	ETF	134.78	134.84	134.65	134.69	443449.0
2011-05-19 08:00:00	SPY	ETF	134.69	134.95	134.65	134.93	2030436.0
2011-05-19 09:00:00	SPY	ETF	134.93	135.03	134.67	134.93	13690030.0
2011-05-19 10:00:00	SPY	ETF	134.92	134.94	134.01	134.06	29830402.0
2011-05-19 11:00:00	SPY	ETF	134.06	134.25	133.94	134.14	13917289.0
2011-05-19 12:00:00	SPY	ETF	134.14	134.72	134.11	134.53	12456549.0
2011-05-19 13:00:00	SPY	ETF	134.53	134.81	134.49	134.71	8024004.0
2011-05-19 14:00:00	SPY	ETF	134.71	134.82	134.14	134.4	14015058.0
2011-05-19 15:00:00	SPY	ETF	134.395	134.72	134.37	134.66	18806800.0
2011-05-19 16:00:00	SPY	ETF	134.67	134.8987	134.1796	134.68	4897787.0
2011-05-19 17:00:00	SPY	ETF	134.67	134.69	134.63	134.66	39283.0
2011-05-19 18:00:00	SPY	ETF	134.68	134.68	134.6	134.6	54996.0
2011-05-19 19:00:00	SPY	ETF	134.6	134.66	134.56	134.66	29381.0
2011-05-19 04:00:00	QQQ	ETF	58.0	58.0	58.0	58.0	200.0
2011-05-19 05:00:00	QQQ	ETF	58.07	58.1	58.07	58.1	200.0
2011-05-19 06:00:00	QQQ	ETF	58.18	58.19	58.15	58.19	4700.0
2011-05-19 07:00:00	QQQ	ETF	58.16	58.2	58.13	58.15	10264.0
2011-05-19 08:00:00	QQQ	ETF	58.15	58.29	58.11	58.26	1098242.0
2011-05-19 09:00:00	QQQ	ETF	58.26	58.3	58.081	58.23	4198694.0
2011-05-19 10:00:00	QQQ	ETF	58.22	58.22	57.87	57.92	8182871.0
2011-05-19 11:00:00	QQQ	ETF	57.915	58.01	57.85	57.95	3243137.0
2011-05-19 12:00:00	QQQ	ETF	57.96	58.3	57.96	58.239	6088741.0
2011-05-19 13:00:00	QQQ	ETF	58.235	58.33	58.2	58.28	2534611.0
2011-05-19 14:00:00	QQQ	ETF	58.275	58.34	58.065	58.14	3150185.0
2011-05-19 15:00:00	QQQ	ETF	58.15	58.25	58.13	58.21	3919442.0
2011-05-19 16:00:00	QQQ	ETF	58.22	58.2579	58.0508	58.21	1672441.0
2011-05-19 17:00:00	QQQ	ETF	58.2	58.24	58.19	58.23	25495.0
2011-05-19 18:00:00	QQQ	ETF	58.22	58.22	58.17	58.17	26052.0
2011-05-19 19:00:00	QQQ	ETF	58.18	58.21	58.17	58.17	3766.0
2011-05-19 04:00:00	IWM	ETF	83.23	83.23	83.23	83.23	500.0
2011-05-19 05:00:00	IWM	ETF	83.51	83.51	83.51	83.51	100.0
2011-05-19 06:00:00	IWM	ETF	83.83	83.83	83.78	83.78	2600.0
2011-05-19 07:00:00	IWM	ETF	83.78	83.85	83.68	83.7	68640.0
2011-05-19 08:00:00	IWM	ETF	83.71	83.99	83.68	83.98	1006181.0
2011-05-19 09:00:00	IWM	ETF	83.98	83.99	83.59	83.81	5544685.0
2011-05-19 10:00:00	IWM	ETF	83.81	83.81	82.84	82.93	12320625.0
2011-05-19 11:00:00	IWM	ETF	82.93	82.98	82.73	82.87	5460214.0
2011-05-19 12:00:00	IWM	ETF	82.86	83.46	82.85	83.35	5179636.0
2011-05-19 13:00:00	IWM	ETF	83.35	83.71	83.3	83.64	3276454.0
2011-05-19 14:00:00	IWM	ETF	83.63	83.72	83.23	83.4101	4464325.0
2011-05-19 15:00:00	IWM	ETF	83.41	83.68	83.37	83.46	6940514.0
2011-05-19 16:00:00	IWM	ETF	83.46	83.65	83.4	83.52	992566.0
2011-05-19 17:00:00	IWM	ETF	83.54	83.54	83.5	83.52	2440.0
2011-05-19 18:00:00	IWM	ETF	83.54	83.54	83.41	83.54	54800.0
2011-05-19 19:00:00	IWM	ETF	83.5	83.5	83.49	83.49	600.0
2011-05-19 05:00:00	DIA	ETF	126.12	126.12	126.12	126.12	200.0
2011-05-19 06:00:00	DIA	ETF	126.05	126.14	126.05	126.14	1600.0

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

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