PREVIEW / etf_1hour / 2016-03-03

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-03-03.parquet
  size:    249 KB
  rows:    7,960

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-03-03 04:00:00	SPY	ETF	198.75	199.17	198.72	199.07	15300.0
2016-03-03 05:00:00	SPY	ETF	199.12	199.25	198.98	199.25	17972.0
2016-03-03 06:00:00	SPY	ETF	199.25	199.25	198.84	198.95	71072.0
2016-03-03 07:00:00	SPY	ETF	198.94	198.97	198.69	198.86	263262.0
2016-03-03 08:00:00	SPY	ETF	198.84	198.92	198.64	198.8	554391.0
2016-03-03 09:00:00	SPY	ETF	198.84	198.86	198.19	198.385	8497383.0
2016-03-03 10:00:00	SPY	ETF	198.385	199.0	198.12	198.825	17553960.0
2016-03-03 11:00:00	SPY	ETF	198.82	198.92	198.11	198.49	13062513.0
2016-03-03 12:00:00	SPY	ETF	198.5	198.71	198.27	198.67	7995875.0
2016-03-03 13:00:00	SPY	ETF	198.6625	199.26	198.66	199.16	9024074.0
2016-03-03 14:00:00	SPY	ETF	199.16	199.49	198.96	199.36	10854778.0
2016-03-03 15:00:00	SPY	ETF	199.37	199.795	199.2	199.76	20733465.0
2016-03-03 16:00:00	SPY	ETF	199.76	199.84	198.8247	199.77	3257779.0
2016-03-03 17:00:00	SPY	ETF	199.78	199.84	199.74	199.77	142637.0
2016-03-03 18:00:00	SPY	ETF	199.77	199.77	199.57	199.59	120789.0
2016-03-03 19:00:00	SPY	ETF	199.62	199.68	199.58	199.68	29683.0
2016-03-03 04:00:00	QQQ	ETF	105.89	105.89	105.89	105.89	100.0
2016-03-03 05:00:00	QQQ	ETF	105.94	105.97	105.94	105.97	3298.0
2016-03-03 06:00:00	QQQ	ETF	106.0	106.0	105.69	105.69	2699.0
2016-03-03 07:00:00	QQQ	ETF	105.73	105.75	105.62	105.73	27026.0
2016-03-03 08:00:00	QQQ	ETF	105.76	105.77	105.64	105.77	62172.0
2016-03-03 09:00:00	QQQ	ETF	105.74	105.75	105.3	105.39	2911029.0
2016-03-03 10:00:00	QQQ	ETF	105.4	105.5294	105.09	105.36	3237484.0
2016-03-03 11:00:00	QQQ	ETF	105.36	105.4062	104.87	105.12	3340813.0
2016-03-03 12:00:00	QQQ	ETF	105.12	105.228	105.002	105.14	1687332.0
2016-03-03 13:00:00	QQQ	ETF	105.14	105.53	105.14	105.48	2052145.0
2016-03-03 14:00:00	QQQ	ETF	105.495	105.59	105.34	105.5	2183398.0
2016-03-03 15:00:00	QQQ	ETF	105.51	105.63	105.35	105.62	5366429.0
2016-03-03 16:00:00	QQQ	ETF	105.63	105.63	105.45	105.61	1786599.0
2016-03-03 17:00:00	QQQ	ETF	105.63	105.64	105.58	105.6	12106.0
2016-03-03 18:00:00	QQQ	ETF	105.6	105.6	105.47	105.48	12203.0
2016-03-03 19:00:00	QQQ	ETF	105.49	105.54	105.49	105.5	5699.0
2016-03-03 04:00:00	IWM	ETF	106.15	106.15	106.15	106.15	200.0
2016-03-03 05:00:00	IWM	ETF	106.3	106.3	106.21	106.21	200.0
2016-03-03 06:00:00	IWM	ETF	106.23	106.25	106.16	106.16	2800.0
2016-03-03 07:00:00	IWM	ETF	106.2	106.22	106.11	106.2	11765.0
2016-03-03 08:00:00	IWM	ETF	106.19	106.19	106.01	106.05	76062.0
2016-03-03 09:00:00	IWM	ETF	106.03	106.33	105.92	106.16	3138303.0
2016-03-03 10:00:00	IWM	ETF	106.16	106.77	106.0	106.675	4112910.0
2016-03-03 11:00:00	IWM	ETF	106.6813	106.73	106.1	106.45	3740939.0
2016-03-03 12:00:00	IWM	ETF	106.45	106.54	106.18	106.32	1500310.0
2016-03-03 13:00:00	IWM	ETF	106.32	106.7	106.29	106.63	1868266.0
2016-03-03 14:00:00	IWM	ETF	106.65	106.82	106.57	106.65	2116471.0
2016-03-03 15:00:00	IWM	ETF	106.66	107.11	106.61	107.06	5586332.0
2016-03-03 16:00:00	IWM	ETF	107.07	107.15	106.0656	106.98	2113168.0
2016-03-03 17:00:00	IWM	ETF	106.97	107.06	106.96	106.99	38330.0
2016-03-03 18:00:00	IWM	ETF	106.96	107.1	106.92	107.1	599.0
2016-03-03 19:00:00	IWM	ETF	106.93	107.13	106.93	107.13	4811.0
2016-03-03 07:00:00	DIA	ETF	168.66	168.66	168.66	168.66	100.0
2016-03-03 08:00:00	DIA	ETF	168.7	168.7	168.7	168.7	100.0

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

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