PREVIEW / etf_1hour / 2016-01-12

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-01-12.parquet
  size:    257 KB
  rows:    8,152

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-01-12 04:00:00	SPY	ETF	191.64	192.71	191.35	192.6	47475.0
2016-01-12 05:00:00	SPY	ETF	192.65	193.55	192.52	193.53	48521.0
2016-01-12 06:00:00	SPY	ETF	193.45	194.0	192.95	193.25	244779.0
2016-01-12 07:00:00	SPY	ETF	193.23	193.99	193.06	193.85	803368.0
2016-01-12 08:00:00	SPY	ETF	193.84	194.26	193.07	193.92	2800069.0
2016-01-12 09:00:00	SPY	ETF	193.93	194.55	193.38	193.97	19945289.0
2016-01-12 10:00:00	SPY	ETF	193.975	194.17	192.59	193.05	27811433.0
2016-01-12 11:00:00	SPY	ETF	193.0608	194.41	191.77	192.52	20690340.0
2016-01-12 12:00:00	SPY	ETF	192.52	192.99	191.44	191.75	17530982.0
2016-01-12 13:00:00	SPY	ETF	191.75	192.5	191.62	191.87	11783148.0
2016-01-12 14:00:00	SPY	ETF	191.87	192.94	191.14	192.84	23580575.0
2016-01-12 15:00:00	SPY	ETF	192.85	194.01	192.29	193.62	32765378.0
2016-01-12 16:00:00	SPY	ETF	193.6	193.79	189.17	192.8	9899532.0
2016-01-12 17:00:00	SPY	ETF	192.8	193.66	192.64	192.84	591342.0
2016-01-12 18:00:00	SPY	ETF	192.81	193.66	192.77	193.27	458184.0
2016-01-12 19:00:00	SPY	ETF	193.27	193.98	193.27	193.95	563598.0
2016-01-12 20:00:00	SPY	ETF	193.6283	193.6283	193.6283	193.6283	36500.0
2016-01-12 04:00:00	QQQ	ETF	103.94	104.69	103.94	104.68	12810.0
2016-01-12 05:00:00	QQQ	ETF	104.65	105.02	104.65	104.97	2060.0
2016-01-12 06:00:00	QQQ	ETF	105.13	105.2	104.91	105.0	19250.0
2016-01-12 07:00:00	QQQ	ETF	105.03	105.48	104.95	105.45	56592.0
2016-01-12 08:00:00	QQQ	ETF	105.43	105.73	105.04	105.43	416217.0
2016-01-12 09:00:00	QQQ	ETF	105.42	106.08	105.22	105.79	6172395.0
2016-01-12 10:00:00	QQQ	ETF	105.79	105.964	105.06	105.35	6683793.0
2016-01-12 11:00:00	QQQ	ETF	105.345	105.41	104.63	105.07	4886454.0
2016-01-12 12:00:00	QQQ	ETF	105.08	105.32	104.42	104.62	3537548.0
2016-01-12 13:00:00	QQQ	ETF	104.62	105.04	104.51	104.6	3753533.0
2016-01-12 14:00:00	QQQ	ETF	104.59	105.3399	104.08	105.275	5972322.0
2016-01-12 15:00:00	QQQ	ETF	105.26	105.829	104.89	105.57	9943668.0
2016-01-12 16:00:00	QQQ	ETF	105.56	105.69	105.12	105.16	942405.0
2016-01-12 17:00:00	QQQ	ETF	105.11	105.15	105.03	105.1	92444.0
2016-01-12 18:00:00	QQQ	ETF	105.15	105.46	105.13	105.39	72486.0
2016-01-12 19:00:00	QQQ	ETF	105.44	105.8	105.44	105.78	57417.0
2016-01-12 04:00:00	IWM	ETF	103.0	103.63	103.0	103.63	800.0
2016-01-12 05:00:00	IWM	ETF	103.74	104.03	103.74	104.03	2170.0
2016-01-12 06:00:00	IWM	ETF	104.05	104.05	103.81	103.82	5400.0
2016-01-12 07:00:00	IWM	ETF	103.95	104.25	103.79	104.21	96487.0
2016-01-12 08:00:00	IWM	ETF	104.17	104.36	103.82	104.03	125484.0
2016-01-12 09:00:00	IWM	ETF	104.13	104.99	103.96	104.54	6336859.0
2016-01-12 10:00:00	IWM	ETF	104.54	104.67	103.695	103.96	5819334.0
2016-01-12 11:00:00	IWM	ETF	103.95	104.05	102.73	103.21	6536015.0
2016-01-12 12:00:00	IWM	ETF	103.21	103.49	102.4	102.45	4914695.0
2016-01-12 13:00:00	IWM	ETF	102.45	102.78	102.26	102.38	4411353.0
2016-01-12 14:00:00	IWM	ETF	102.385	102.97	101.94	102.89	7003169.0
2016-01-12 15:00:00	IWM	ETF	102.88	103.82	102.51	103.75	10694600.0
2016-01-12 16:00:00	IWM	ETF	103.75	103.87	103.22	103.25	1268583.0
2016-01-12 17:00:00	IWM	ETF	103.28	103.35	103.2	103.25	9390.0
2016-01-12 18:00:00	IWM	ETF	103.37	103.49	103.37	103.37	5291.0
2016-01-12 19:00:00	IWM	ETF	103.37	103.75	103.37	103.75	3846.0
2016-01-12 20:00:00	IWM	ETF	103.7238	103.7238	103.7238	103.7238	2000000.0

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

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