PREVIEW / etf_1hour / 2015-04-13

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-04-13.parquet
  size:    242 KB
  rows:    7,658

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-04-13 04:00:00	SPY	ETF	209.77	210.14	209.5	209.57	2626.0
2015-04-13 05:00:00	SPY	ETF	209.63	209.86	209.58	209.85	12300.0
2015-04-13 06:00:00	SPY	ETF	209.85	209.86	209.71	209.71	51712.0
2015-04-13 07:00:00	SPY	ETF	209.75	209.84	209.6	209.62	245967.0
2015-04-13 08:00:00	SPY	ETF	209.64	210.07	209.51	209.65	564902.0
2015-04-13 09:00:00	SPY	ETF	209.63	210.5	209.61	210.45	9761722.0
2015-04-13 10:00:00	SPY	ETF	210.45	210.63	210.2	210.22	6642067.0
2015-04-13 11:00:00	SPY	ETF	210.21	210.44	210.14	210.16	11471334.0
2015-04-13 12:00:00	SPY	ETF	210.1628	210.21	209.87	210.05	7378528.0
2015-04-13 13:00:00	SPY	ETF	210.05	210.05	209.375	209.66	9879393.0
2015-04-13 14:00:00	SPY	ETF	209.66	209.78	209.27	209.44	7099077.0
2015-04-13 15:00:00	SPY	ETF	209.445	209.65	209.03	209.08	12263630.0
2015-04-13 16:00:00	SPY	ETF	209.11	209.2	209.04	209.16	4409513.0
2015-04-13 17:00:00	SPY	ETF	209.17	209.28	209.17	209.2	212319.0
2015-04-13 18:00:00	SPY	ETF	209.19	209.27	209.12	209.16	130026.0
2015-04-13 19:00:00	SPY	ETF	209.16	209.2	209.14	209.19	34332.0
2015-04-13 04:00:00	QQQ	ETF	107.6	107.6	107.6	107.6	400.0
2015-04-13 06:00:00	QQQ	ETF	107.65	107.69	107.65	107.68	11600.0
2015-04-13 07:00:00	QQQ	ETF	107.69	107.72	107.67	107.72	10728.0
2015-04-13 08:00:00	QQQ	ETF	107.68	107.76	107.66	107.73	58399.0
2015-04-13 09:00:00	QQQ	ETF	107.71	108.31	107.71	108.27	3270117.0
2015-04-13 10:00:00	QQQ	ETF	108.26	108.38	108.145	108.16	2492862.0
2015-04-13 11:00:00	QQQ	ETF	108.16	108.27	108.093	108.13	2136932.0
2015-04-13 12:00:00	QQQ	ETF	108.13	108.17	107.95	107.98	1377629.0
2015-04-13 13:00:00	QQQ	ETF	107.98	107.98	107.48	107.65	2096429.0
2015-04-13 14:00:00	QQQ	ETF	107.66	107.79	107.54	107.65	1627257.0
2015-04-13 15:00:00	QQQ	ETF	107.66	107.78	107.36	107.46	3330858.0
2015-04-13 16:00:00	QQQ	ETF	107.47	107.49	107.37	107.44	426976.0
2015-04-13 17:00:00	QQQ	ETF	107.45	107.51	107.45	107.5	36093.0
2015-04-13 18:00:00	QQQ	ETF	107.5	107.5	107.43	107.48	3050.0
2015-04-13 19:00:00	QQQ	ETF	107.48	107.49	107.43	107.43	63256.0
2015-04-13 04:00:00	IWM	ETF	125.5	125.5	125.5	125.5	100.0
2015-04-13 08:00:00	IWM	ETF	125.61	125.67	125.5	125.62	44263.0
2015-04-13 09:00:00	IWM	ETF	125.6	126.03	125.6	126.01	1682707.0
2015-04-13 10:00:00	IWM	ETF	126.02	126.35	125.95	126.165	2242809.0
2015-04-13 11:00:00	IWM	ETF	126.16	126.39	126.145	126.2759	2012776.0
2015-04-13 12:00:00	IWM	ETF	126.28	126.3	126.02	126.099	1687588.0
2015-04-13 13:00:00	IWM	ETF	126.1	126.1	125.75	125.91	2439687.0
2015-04-13 14:00:00	IWM	ETF	125.91	126.02	125.79	125.84	1236005.0
2015-04-13 15:00:00	IWM	ETF	125.84	125.93	125.58	125.69	4458040.0
2015-04-13 16:00:00	IWM	ETF	125.69	125.75	125.61	125.72	1700179.0
2015-04-13 17:00:00	IWM	ETF	125.76	125.76	125.76	125.76	1534.0
2015-04-13 18:00:00	IWM	ETF	125.7	125.7	125.7	125.7	100.0
2015-04-13 19:00:00	IWM	ETF	125.75	125.75	125.73	125.73	400.0
2015-04-13 04:00:00	DIA	ETF	179.99	180.02	179.95	179.99	12200.0
2015-04-13 05:00:00	DIA	ETF	180.04	180.09	180.02	180.02	21500.0
2015-04-13 06:00:00	DIA	ETF	180.09	180.09	180.09	180.09	1000.0
2015-04-13 07:00:00	DIA	ETF	180.08	180.08	180.01	180.01	15200.0
2015-04-13 08:00:00	DIA	ETF	180.0	180.15	179.94	179.94	1500.0
2015-04-13 09:00:00	DIA	ETF	180.009	180.8	180.009	180.75	429581.0

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

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