PREVIEW / etf_1hour / 2015-05-11

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-05-11.parquet
  size:    239 KB
  rows:    7,632

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
2015-05-11 04:00:00	SPY	ETF	211.26	211.4	211.08	211.15	29516.0
2015-05-11 05:00:00	SPY	ETF	211.15	211.26	211.1	211.13	12830.0
2015-05-11 06:00:00	SPY	ETF	211.16	211.3	211.11	211.3	100677.0
2015-05-11 07:00:00	SPY	ETF	211.3	211.55	211.2	211.51	277801.0
2015-05-11 08:00:00	SPY	ETF	211.39	211.54	211.21	211.47	341215.0
2015-05-11 09:00:00	SPY	ETF	211.47	211.85	211.27	211.66	9736347.0
2015-05-11 10:00:00	SPY	ETF	211.67	211.89	211.11	211.53	10749200.0
2015-05-11 11:00:00	SPY	ETF	211.52	211.68	211.25	211.54	6821769.0
2015-05-11 12:00:00	SPY	ETF	211.54	211.58	211.03	211.185	7029079.0
2015-05-11 13:00:00	SPY	ETF	211.185	211.42	211.13	211.13	4818945.0
2015-05-11 14:00:00	SPY	ETF	211.14	211.25	210.68	210.725	8840595.0
2015-05-11 15:00:00	SPY	ETF	210.72	211.08	210.52	210.61	17517149.0
2015-05-11 16:00:00	SPY	ETF	210.59	211.6634	210.15	210.28	8025812.0
2015-05-11 17:00:00	SPY	ETF	210.28	210.33	210.23	210.33	202330.0
2015-05-11 18:00:00	SPY	ETF	210.34	210.4	210.28	210.39	41871.0
2015-05-11 19:00:00	SPY	ETF	210.38	210.38	210.22	210.22	171449.0
2015-05-11 06:00:00	QQQ	ETF	108.49	108.62	108.47	108.62	27360.0
2015-05-11 07:00:00	QQQ	ETF	108.61	108.74	108.54	108.7	28545.0
2015-05-11 08:00:00	QQQ	ETF	108.7	108.72	108.57	108.71	67610.0
2015-05-11 09:00:00	QQQ	ETF	108.7	108.98	108.5	108.75	3683944.0
2015-05-11 10:00:00	QQQ	ETF	108.765	108.9	108.34	108.558	2703520.0
2015-05-11 11:00:00	QQQ	ETF	108.565	108.72	108.39	108.7062	2089999.0
2015-05-11 12:00:00	QQQ	ETF	108.71	108.745	108.44	108.53	1365241.0
2015-05-11 13:00:00	QQQ	ETF	108.52	108.715	108.49	108.54	934812.0
2015-05-11 14:00:00	QQQ	ETF	108.541	108.625	108.38	108.385	1505644.0
2015-05-11 15:00:00	QQQ	ETF	108.38	108.48	108.19	108.26	3264755.0
2015-05-11 16:00:00	QQQ	ETF	108.26	108.33	108.07	108.14	444267.0
2015-05-11 17:00:00	QQQ	ETF	108.14	108.17	108.12	108.17	26447.0
2015-05-11 18:00:00	QQQ	ETF	108.18	108.19	108.18	108.18	850.0
2015-05-11 19:00:00	QQQ	ETF	108.18	108.18	108.13	108.13	9330.0
2015-05-11 07:00:00	IWM	ETF	122.45	122.64	122.45	122.57	18200.0
2015-05-11 08:00:00	IWM	ETF	122.59	122.64	122.5	122.58	94501.0
2015-05-11 09:00:00	IWM	ETF	122.55	123.34	122.44	123.2	2881733.0
2015-05-11 10:00:00	IWM	ETF	123.2	123.5555	122.8	123.22	4002100.0
2015-05-11 11:00:00	IWM	ETF	123.215	123.66	123.07	123.63	2518888.0
2015-05-11 12:00:00	IWM	ETF	123.625	123.66	123.19	123.34	1910669.0
2015-05-11 13:00:00	IWM	ETF	123.34	123.485	123.16	123.17	1494373.0
2015-05-11 14:00:00	IWM	ETF	123.165	123.27	122.82	122.82	2710508.0
2015-05-11 15:00:00	IWM	ETF	122.82	123.16	122.64	122.71	6289512.0
2015-05-11 16:00:00	IWM	ETF	122.71	122.88	122.55	122.71	2291429.0
2015-05-11 17:00:00	IWM	ETF	122.67	122.7	122.65	122.65	1000.0
2015-05-11 19:00:00	IWM	ETF	122.66	122.7	122.66	122.7	698.0
2015-05-11 04:00:00	DIA	ETF	181.64	181.68	181.55	181.55	32300.0
2015-05-11 07:00:00	DIA	ETF	181.85	181.89	181.85	181.89	25400.0
2015-05-11 08:00:00	DIA	ETF	181.89	181.89	181.89	181.89	150.0
2015-05-11 09:00:00	DIA	ETF	181.84	182.0	181.52	181.75	709186.0
2015-05-11 10:00:00	DIA	ETF	181.76	181.98	181.26	181.67	868922.0
2015-05-11 11:00:00	DIA	ETF	181.67	181.85	181.5	181.66	390804.0
2015-05-11 12:00:00	DIA	ETF	181.67	181.7	181.28	181.41	341040.0
2015-05-11 13:00:00	DIA	ETF	181.4	181.58	181.3001	181.32	138397.0

> showing 50 of 7,632 rows — these rows as CSV

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