PREVIEW / etf_1hour / 2015-09-09

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-09-09.parquet
  size:    247 KB
  rows:    7,844

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-09-09 04:00:00	SPY	ETF	199.5	199.7	199.14	199.28	68959.0
2015-09-09 05:00:00	SPY	ETF	199.31	199.57	199.21	199.35	53530.0
2015-09-09 06:00:00	SPY	ETF	199.31	199.42	198.96	199.07	87827.0
2015-09-09 07:00:00	SPY	ETF	199.11	199.48	199.11	199.32	625546.0
2015-09-09 08:00:00	SPY	ETF	199.33	199.48	198.1	199.48	1110238.0
2015-09-09 09:00:00	SPY	ETF	199.48	199.57	197.43	198.77	13869134.0
2015-09-09 10:00:00	SPY	ETF	198.78	198.92	197.5	197.6769	19059487.0
2015-09-09 11:00:00	SPY	ETF	197.67	198.1	197.31	197.64	12163509.0
2015-09-09 12:00:00	SPY	ETF	197.65	198.15	197.49	197.72	8604528.0
2015-09-09 13:00:00	SPY	ETF	197.72	198.03	196.32	196.38	15186962.0
2015-09-09 14:00:00	SPY	ETF	196.41	198.0	195.76	196.165	20563825.0
2015-09-09 15:00:00	SPY	ETF	196.16	196.7	194.35	194.79	42613618.0
2015-09-09 16:00:00	SPY	ETF	194.78	199.33	194.66	195.03	11158640.0
2015-09-09 17:00:00	SPY	ETF	195.03	197.5175	195.02	195.11	2199168.0
2015-09-09 18:00:00	SPY	ETF	195.12	195.12	194.1	194.36	524145.0
2015-09-09 19:00:00	SPY	ETF	194.36	194.69	194.22	194.49	138699.0
2015-09-09 04:00:00	QQQ	ETF	106.42	106.48	106.32	106.32	18912.0
2015-09-09 05:00:00	QQQ	ETF	106.34	106.44	106.28	106.28	18471.0
2015-09-09 06:00:00	QQQ	ETF	106.27	106.3	106.1	106.1	10860.0
2015-09-09 07:00:00	QQQ	ETF	106.2	106.34	106.17	106.26	102360.0
2015-09-09 08:00:00	QQQ	ETF	106.27	106.38	106.13	106.36	305161.0
2015-09-09 09:00:00	QQQ	ETF	106.32	106.4	105.7	105.839	6296076.0
2015-09-09 10:00:00	QQQ	ETF	105.84	105.93	105.13	105.25	4874824.0
2015-09-09 11:00:00	QQQ	ETF	105.25	105.53	105.07	105.32	2826993.0
2015-09-09 12:00:00	QQQ	ETF	105.32	105.72	105.24	105.49	1982319.0
2015-09-09 13:00:00	QQQ	ETF	105.5	105.8598	104.8301	104.88	4285660.0
2015-09-09 14:00:00	QQQ	ETF	104.89	105.192	104.38	104.65	5579943.0
2015-09-09 15:00:00	QQQ	ETF	104.65	104.94	103.59	103.87	10432342.0
2015-09-09 16:00:00	QQQ	ETF	103.88	103.98	103.75	103.95	920368.0
2015-09-09 17:00:00	QQQ	ETF	103.95	104.03	103.94	104.02	36528.0
2015-09-09 18:00:00	QQQ	ETF	103.98	103.99	103.46	103.6	70029.0
2015-09-09 19:00:00	QQQ	ETF	103.61	103.69	103.47	103.56	45418.0
2015-09-09 05:00:00	IWM	ETF	116.42	116.46	116.42	116.46	600.0
2015-09-09 07:00:00	IWM	ETF	116.23	116.35	116.19	116.28	81150.0
2015-09-09 08:00:00	IWM	ETF	116.26	116.37	115.45	116.34	263517.0
2015-09-09 09:00:00	IWM	ETF	116.34	116.415	115.64	115.7	4434236.0
2015-09-09 10:00:00	IWM	ETF	115.71	115.87	114.74	114.95	5754861.0
2015-09-09 11:00:00	IWM	ETF	114.95	115.5299	114.87	115.26	3276348.0
2015-09-09 12:00:00	IWM	ETF	115.26	115.73	115.18	115.42	2946130.0
2015-09-09 13:00:00	IWM	ETF	115.425	115.58	114.7	114.76	3031935.0
2015-09-09 14:00:00	IWM	ETF	114.755	115.06	114.6	114.851	3650673.0
2015-09-09 15:00:00	IWM	ETF	114.84	115.1	114.01	114.14	7856323.0
2015-09-09 16:00:00	IWM	ETF	114.13	114.28	113.95	114.18	3020215.0
2015-09-09 17:00:00	IWM	ETF	114.13	114.18	114.13	114.14	2500.0
2015-09-09 18:00:00	IWM	ETF	113.88	113.88	113.88	113.88	999.0
2015-09-09 19:00:00	IWM	ETF	113.88	113.88	113.88	113.88	300.0
2015-09-09 04:00:00	DIA	ETF	166.62	166.62	166.55	166.55	600.0
2015-09-09 05:00:00	DIA	ETF	166.49	166.49	166.49	166.49	100.0
2015-09-09 07:00:00	DIA	ETF	166.35	166.64	166.35	166.5	9150.0
2015-09-09 08:00:00	DIA	ETF	166.45	166.61	166.35	166.51	19987.0

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

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