PREVIEW / etf_1hour / 2015-06-03

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-06-03.parquet
  size:    242 KB
  rows:    7,690

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-06-03 04:00:00	SPY	ETF	211.64	211.8	211.39	211.5	10186.0
2015-06-03 05:00:00	SPY	ETF	211.58	211.61	211.47	211.61	27820.0
2015-06-03 06:00:00	SPY	ETF	211.66	211.95	211.62	211.86	61930.0
2015-06-03 07:00:00	SPY	ETF	211.74	212.56	211.74	212.43	811107.0
2015-06-03 08:00:00	SPY	ETF	211.67	212.5	211.67	212.01	1022625.0
2015-06-03 09:00:00	SPY	ETF	212.02	212.16	211.3301	211.96	12252366.0
2015-06-03 10:00:00	SPY	ETF	211.95	212.67	211.571	212.55	14346256.0
2015-06-03 11:00:00	SPY	ETF	212.54	212.63	211.69	211.91	11644876.0
2015-06-03 12:00:00	SPY	ETF	211.91	211.97	211.5	211.822	10920866.0
2015-06-03 13:00:00	SPY	ETF	211.83	211.96	211.68	211.895	5937505.0
2015-06-03 14:00:00	SPY	ETF	211.9	212.25	211.895	211.98	7891948.0
2015-06-03 15:00:00	SPY	ETF	211.98	212.1	211.74	211.93	15986239.0
2015-06-03 16:00:00	SPY	ETF	211.93	212.25	211.8549	212.17	6334794.0
2015-06-03 17:00:00	SPY	ETF	212.2	212.23	212.17	212.22	84047.0
2015-06-03 18:00:00	SPY	ETF	212.2	212.2	212.13	212.14	35749.0
2015-06-03 19:00:00	SPY	ETF	212.18	212.2	212.14	212.18	55613.0
2015-06-03 04:00:00	QQQ	ETF	110.15	110.25	110.15	110.25	700.0
2015-06-03 05:00:00	QQQ	ETF	110.11	110.11	110.11	110.11	500.0
2015-06-03 06:00:00	QQQ	ETF	110.23	110.31	110.23	110.28	29400.0
2015-06-03 07:00:00	QQQ	ETF	110.29	110.84	110.27	110.75	234477.0
2015-06-03 08:00:00	QQQ	ETF	110.74	110.82	110.47	110.64	241376.0
2015-06-03 09:00:00	QQQ	ETF	110.63	110.7	110.19	110.51	3593806.0
2015-06-03 10:00:00	QQQ	ETF	110.525	110.81	110.3	110.7499	3884230.0
2015-06-03 11:00:00	QQQ	ETF	110.74	110.79	110.28	110.41	2427218.0
2015-06-03 12:00:00	QQQ	ETF	110.4	110.45	110.13	110.32	1986264.0
2015-06-03 13:00:00	QQQ	ETF	110.3	110.42	110.24	110.38	1935969.0
2015-06-03 14:00:00	QQQ	ETF	110.38	110.53	110.345	110.37	1185698.0
2015-06-03 15:00:00	QQQ	ETF	110.38	110.449	110.24	110.38	1811340.0
2015-06-03 16:00:00	QQQ	ETF	110.38	110.57	110.37	110.5	409387.0
2015-06-03 17:00:00	QQQ	ETF	110.51	110.53	110.48	110.5	13260.0
2015-06-03 18:00:00	QQQ	ETF	110.49	110.49	110.44	110.48	75784.0
2015-06-03 19:00:00	QQQ	ETF	110.49	110.5	110.48	110.48	6480.0
2015-06-03 04:00:00	IWM	ETF	124.68	124.68	124.68	124.68	100.0
2015-06-03 05:00:00	IWM	ETF	124.7	124.7	124.7	124.7	100.0
2015-06-03 06:00:00	IWM	ETF	124.78	124.78	124.78	124.78	5000.0
2015-06-03 07:00:00	IWM	ETF	124.84	125.16	124.81	125.05	132100.0
2015-06-03 08:00:00	IWM	ETF	125.04	125.12	124.8	124.83	260216.0
2015-06-03 09:00:00	IWM	ETF	124.75	125.05	124.42	124.99	2774607.0
2015-06-03 10:00:00	IWM	ETF	124.98	125.92	124.78	125.73	5754738.0
2015-06-03 11:00:00	IWM	ETF	125.73	125.88	125.45	125.56	2605031.0
2015-06-03 12:00:00	IWM	ETF	125.55	125.66	125.2	125.48	2307814.0
2015-06-03 13:00:00	IWM	ETF	125.47	125.7	125.41	125.69	1951376.0
2015-06-03 14:00:00	IWM	ETF	125.69	125.93	125.69	125.8099	2457623.0
2015-06-03 15:00:00	IWM	ETF	125.81	125.86	125.65	125.77	3151663.0
2015-06-03 16:00:00	IWM	ETF	125.76	125.92	124.5249	125.86	2686726.0
2015-06-03 17:00:00	IWM	ETF	125.88	126.0	125.88	125.97	1850.0
2015-06-03 07:00:00	DIA	ETF	181.0	181.15	181.0	181.15	1250.0
2015-06-03 08:00:00	DIA	ETF	181.0	181.16	181.0	181.02	1741.0
2015-06-03 09:00:00	DIA	ETF	180.87	180.96	180.122	180.86	759448.0
2015-06-03 10:00:00	DIA	ETF	180.84	181.74	180.53	181.65	1178226.0

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

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