PREVIEW / etf_1hour / 2016-12-12

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-12-12.parquet
  size:    279 KB
  rows:    8,985

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
2016-12-12 04:00:00	SPY	ETF	226.82	226.82	226.15	226.16	8585.0
2016-12-12 05:00:00	SPY	ETF	226.3	226.4	226.16	226.34	4019.0
2016-12-12 06:00:00	SPY	ETF	226.28	226.5	226.28	226.48	11368.0
2016-12-12 07:00:00	SPY	ETF	226.51	226.65	226.43	226.43	117510.0
2016-12-12 08:00:00	SPY	ETF	226.46	226.6	226.44	226.55	342601.0
2016-12-12 09:00:00	SPY	ETF	226.55	226.82	226.26	226.82	10367942.0
2016-12-12 10:00:00	SPY	ETF	226.82	226.96	226.17	226.34	9847900.0
2016-12-12 11:00:00	SPY	ETF	226.33	226.49	226.045	226.15	12267363.0
2016-12-12 12:00:00	SPY	ETF	226.155	226.155	225.76	225.97	13824981.0
2016-12-12 13:00:00	SPY	ETF	225.97	226.19	225.88	225.95	5804856.0
2016-12-12 14:00:00	SPY	ETF	225.945	226.25	225.86	225.975	8221093.0
2016-12-12 15:00:00	SPY	ETF	225.98	226.29	225.94	226.22	17821375.0
2016-12-12 16:00:00	SPY	ETF	226.19	226.36	226.08	226.14	21541700.0
2016-12-12 17:00:00	SPY	ETF	226.12	226.463	226.06	226.11	583262.0
2016-12-12 18:00:00	SPY	ETF	226.09	226.11	225.82	225.99	182803.0
2016-12-12 19:00:00	SPY	ETF	225.96	226.2	225.95	226.18	105585.0
2016-12-12 20:00:00	SPY	ETF	226.25	226.25	226.2034	226.2034	181000.0
2016-12-12 04:00:00	QQQ	ETF	119.02	119.1	118.72	118.77	5558.0
2016-12-12 05:00:00	QQQ	ETF	118.8	118.94	118.78	118.94	5609.0
2016-12-12 06:00:00	QQQ	ETF	118.9	119.0	118.9	119.0	9309.0
2016-12-12 07:00:00	QQQ	ETF	118.99	119.1	118.99	119.03	53508.0
2016-12-12 08:00:00	QQQ	ETF	119.02	119.07	119.0	119.05	80605.0
2016-12-12 09:00:00	QQQ	ETF	119.05	119.13	118.74	119.11	2643052.0
2016-12-12 10:00:00	QQQ	ETF	119.11	119.21	118.66	118.87	2871913.0
2016-12-12 11:00:00	QQQ	ETF	118.86	118.9533	118.67	118.69	1870913.0
2016-12-12 12:00:00	QQQ	ETF	118.69	118.7	118.47	118.6599	2357144.0
2016-12-12 13:00:00	QQQ	ETF	118.66	118.82	118.58	118.63	1467832.0
2016-12-12 14:00:00	QQQ	ETF	118.64	118.81	118.61	118.7632	1790761.0
2016-12-12 15:00:00	QQQ	ETF	118.76	118.995	118.75	118.97	3478034.0
2016-12-12 16:00:00	QQQ	ETF	118.97	119.01	118.8	118.81	512617.0
2016-12-12 17:00:00	QQQ	ETF	118.81	118.87	118.81	118.84	2560.0
2016-12-12 18:00:00	QQQ	ETF	118.84	118.85	118.7	118.8	26030.0
2016-12-12 19:00:00	QQQ	ETF	118.79	118.94	118.79	118.91	8607.0
2016-12-12 04:00:00	IWM	ETF	138.04	138.04	137.46	137.61	3463.0
2016-12-12 05:00:00	IWM	ETF	137.59	137.73	137.56	137.68	1619.0
2016-12-12 06:00:00	IWM	ETF	137.7	138.03	137.7	138.03	4596.0
2016-12-12 07:00:00	IWM	ETF	138.02	138.03	137.95	137.97	21500.0
2016-12-12 08:00:00	IWM	ETF	137.92	138.04	137.89	138.0	21908.0
2016-12-12 09:00:00	IWM	ETF	138.01	138.57	137.8	138.4	2908768.0
2016-12-12 10:00:00	IWM	ETF	138.4	138.5	137.22	137.54	7176587.0
2016-12-12 11:00:00	IWM	ETF	137.545	137.87	136.77	136.89	4758195.0
2016-12-12 12:00:00	IWM	ETF	136.88	136.99	136.51	136.595	3421703.0
2016-12-12 13:00:00	IWM	ETF	136.6	136.98	136.53	136.66	2060026.0
2016-12-12 14:00:00	IWM	ETF	136.6587	136.95	136.55	136.6499	2584158.0
2016-12-12 15:00:00	IWM	ETF	136.64	136.85	136.57	136.82	4548056.0
2016-12-12 16:00:00	IWM	ETF	136.82	137.04	136.7429	136.85	2550835.0
2016-12-12 17:00:00	IWM	ETF	136.92	136.92	136.8	136.8	2600.0
2016-12-12 18:00:00	IWM	ETF	136.77	136.82	136.77	136.82	2900.0
2016-12-12 19:00:00	IWM	ETF	136.77	136.84	136.76	136.84	2281.0
2016-12-12 05:00:00	DIA	ETF	197.71	197.71	197.71	197.71	250.0

> showing 50 of 8,985 rows — these rows as CSV

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