PREVIEW / etf_1hour / 2015-01-14

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-01-14.parquet
  size:    246 KB
  rows:    7,808

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-01-14 04:00:00	SPY	ETF	200.87	201.85	200.84	201.85	632622.0
2015-01-14 05:00:00	SPY	ETF	201.95	202.33	201.33	201.49	77405.0
2015-01-14 06:00:00	SPY	ETF	201.54	201.55	201.03	201.04	217870.0
2015-01-14 07:00:00	SPY	ETF	201.02	201.38	200.7	200.73	617477.0
2015-01-14 08:00:00	SPY	ETF	201.18	201.3333	198.98	199.66	5627886.0
2015-01-14 09:00:00	SPY	ETF	199.63	201.3691	199.24	200.13	23086888.0
2015-01-14 10:00:00	SPY	ETF	200.14	201.1	200.08	200.55	29498959.0
2015-01-14 11:00:00	SPY	ETF	200.56	200.6	199.62	199.76	20994487.0
2015-01-14 12:00:00	SPY	ETF	199.755	199.99	199.29	199.63	12556626.0
2015-01-14 13:00:00	SPY	ETF	199.64	199.84	198.57	199.034	18719984.0
2015-01-14 14:00:00	SPY	ETF	199.04	200.73	198.93	199.78	30876467.0
2015-01-14 15:00:00	SPY	ETF	199.785	201.05	199.75	200.9	39094620.0
2015-01-14 16:00:00	SPY	ETF	200.89	201.48	200.81	201.46	8404443.0
2015-01-14 17:00:00	SPY	ETF	201.45	201.48	201.39	201.4	146806.0
2015-01-14 18:00:00	SPY	ETF	201.39	201.54	201.34	201.4	99413.0
2015-01-14 19:00:00	SPY	ETF	201.4	201.53	201.21	201.28	295359.0
2015-01-14 04:00:00	QQQ	ETF	101.0	101.25	100.82	101.25	14748.0
2015-01-14 05:00:00	QQQ	ETF	101.25	101.31	101.25	101.31	1166.0
2015-01-14 06:00:00	QQQ	ETF	101.18	101.35	101.18	101.21	15600.0
2015-01-14 07:00:00	QQQ	ETF	101.07	101.26	100.97	100.97	64950.0
2015-01-14 08:00:00	QQQ	ETF	101.0	101.14	100.15	100.55	577716.0
2015-01-14 09:00:00	QQQ	ETF	100.54	101.06	100.35	100.97	6428235.0
2015-01-14 10:00:00	QQQ	ETF	100.971	101.4829	100.79	101.02	6834282.0
2015-01-14 11:00:00	QQQ	ETF	101.03	101.05	100.57	100.64	5416288.0
2015-01-14 12:00:00	QQQ	ETF	100.66	100.8	100.43	100.651	3847671.0
2015-01-14 13:00:00	QQQ	ETF	100.66	100.75	100.07	100.33	3279571.0
2015-01-14 14:00:00	QQQ	ETF	100.32	101.08	100.29	100.56	7728001.0
2015-01-14 15:00:00	QQQ	ETF	100.56	101.18	100.55	101.0	11092783.0
2015-01-14 16:00:00	QQQ	ETF	101.0	101.31	100.6027	101.28	1770391.0
2015-01-14 17:00:00	QQQ	ETF	101.27	101.31	101.22	101.31	10189.0
2015-01-14 18:00:00	QQQ	ETF	101.29	101.32	101.24	101.27	15391.0
2015-01-14 19:00:00	QQQ	ETF	101.3	101.36	101.23	101.27	70525.0
2015-01-14 04:00:00	IWM	ETF	116.15	116.6	116.15	116.6	282.0
2015-01-14 05:00:00	IWM	ETF	117.49	117.52	117.49	117.52	200.0
2015-01-14 06:00:00	IWM	ETF	116.88	116.88	116.88	116.88	300.0
2015-01-14 07:00:00	IWM	ETF	116.8	117.0	116.47	116.57	30500.0
2015-01-14 08:00:00	IWM	ETF	116.6	116.67	115.57	115.94	521560.0
2015-01-14 09:00:00	IWM	ETF	115.94	116.82	115.65	116.56	5339169.0
2015-01-14 10:00:00	IWM	ETF	116.56	117.0	116.43	116.69	4971328.0
2015-01-14 11:00:00	IWM	ETF	116.7	116.75	116.24	116.36	2855121.0
2015-01-14 12:00:00	IWM	ETF	116.37	116.53	115.99	116.24	2965339.0
2015-01-14 13:00:00	IWM	ETF	116.25	116.34	115.55	115.77	3200494.0
2015-01-14 14:00:00	IWM	ETF	115.77	116.82	115.74	116.37	5496692.0
2015-01-14 15:00:00	IWM	ETF	116.38	117.1	116.37	116.81	6773823.0
2015-01-14 16:00:00	IWM	ETF	116.82	117.17	116.77	117.1	807548.0
2015-01-14 17:00:00	IWM	ETF	117.1	117.16	117.0	117.0	15037.0
2015-01-14 18:00:00	IWM	ETF	116.92	116.93	116.92	116.93	200.0
2015-01-14 19:00:00	IWM	ETF	117.1	117.17	117.05	117.17	3150.0
2015-01-14 08:00:00	DIA	ETF	174.89	174.89	173.34	173.7	44655.0
2015-01-14 09:00:00	DIA	ETF	173.51	174.18	173.29	173.8255	1390358.0

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

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