PREVIEW / etf_1hour / 2015-01-15

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-01-15.parquet
  size:    245 KB
  rows:    7,796

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-15 04:00:00	SPY	ETF	202.4	202.44	199.4	201.0	1108231.0
2015-01-15 05:00:00	SPY	ETF	200.03	201.4	199.55	200.11	454442.0
2015-01-15 06:00:00	SPY	ETF	200.22	200.22	199.3	199.79	605631.0
2015-01-15 07:00:00	SPY	ETF	199.97	201.74	199.7	200.87	1487833.0
2015-01-15 08:00:00	SPY	ETF	199.71	202.21	199.71	201.74	3073220.0
2015-01-15 09:00:00	SPY	ETF	201.74	202.01	199.62	199.92	25877644.0
2015-01-15 10:00:00	SPY	ETF	199.93	201.48	199.54	200.32	29327561.0
2015-01-15 11:00:00	SPY	ETF	200.32	200.54	199.5	199.91	22058717.0
2015-01-15 12:00:00	SPY	ETF	199.91	200.2	198.97	199.3501	17638093.0
2015-01-15 13:00:00	SPY	ETF	199.355	200.03	199.06	199.45	16522211.0
2015-01-15 14:00:00	SPY	ETF	199.45	200.24	199.26	200.06	15821681.0
2015-01-15 15:00:00	SPY	ETF	200.0638	200.19	198.88	199.02	27314548.0
2015-01-15 16:00:00	SPY	ETF	199.01	199.79	198.79	198.81	9458175.0
2015-01-15 17:00:00	SPY	ETF	198.8	200.3519	198.29	198.51	769616.0
2015-01-15 18:00:00	SPY	ETF	198.51	198.74	198.35	198.42	429733.0
2015-01-15 19:00:00	SPY	ETF	198.39	198.47	197.76	198.13	733649.0
2015-01-15 04:00:00	QQQ	ETF	101.68	101.84	100.0	100.8	49750.0
2015-01-15 05:00:00	QQQ	ETF	100.42	101.14	100.42	100.54	3550.0
2015-01-15 06:00:00	QQQ	ETF	100.77	100.77	100.3	100.56	34100.0
2015-01-15 07:00:00	QQQ	ETF	100.59	101.29	100.5	100.92	364820.0
2015-01-15 08:00:00	QQQ	ETF	100.88	102.13	100.51	101.2	461948.0
2015-01-15 09:00:00	QQQ	ETF	101.23	101.59	100.11	100.27	7922039.0
2015-01-15 10:00:00	QQQ	ETF	100.24	101.1	100.01	100.57	7919112.0
2015-01-15 11:00:00	QQQ	ETF	100.57	100.69	100.05	100.255	5765180.0
2015-01-15 12:00:00	QQQ	ETF	100.25	100.45	99.65	99.87	5320222.0
2015-01-15 13:00:00	QQQ	ETF	99.88	100.28	99.77	99.81	4652406.0
2015-01-15 14:00:00	QQQ	ETF	99.82	100.28	99.733	100.18	3051683.0
2015-01-15 15:00:00	QQQ	ETF	100.17	100.26	99.525	99.65	5981547.0
2015-01-15 16:00:00	QQQ	ETF	99.65	101.0009	99.56	99.56	2059886.0
2015-01-15 17:00:00	QQQ	ETF	99.54	99.55	99.24	99.33	87046.0
2015-01-15 18:00:00	QQQ	ETF	99.4	99.43	99.25	99.28	36433.0
2015-01-15 19:00:00	QQQ	ETF	99.25	99.26	98.93	99.05	99632.0
2015-01-15 04:00:00	IWM	ETF	117.43	117.43	115.46	115.46	2300.0
2015-01-15 06:00:00	IWM	ETF	116.01	116.1	115.95	116.05	2900.0
2015-01-15 07:00:00	IWM	ETF	116.48	116.95	116.39	116.95	144636.0
2015-01-15 08:00:00	IWM	ETF	116.8	117.57	116.44	117.24	234132.0
2015-01-15 09:00:00	IWM	ETF	117.25	117.38	115.52	115.6101	4865166.0
2015-01-15 10:00:00	IWM	ETF	115.61	116.61	115.26	116.055	6540524.0
2015-01-15 11:00:00	IWM	ETF	116.06	116.23	115.58	115.64	3468688.0
2015-01-15 12:00:00	IWM	ETF	115.64	115.89	114.48	114.8138	5821264.0
2015-01-15 13:00:00	IWM	ETF	114.82	115.02	114.53	114.795	3598425.0
2015-01-15 14:00:00	IWM	ETF	114.8	115.39	114.69	115.18	3666784.0
2015-01-15 15:00:00	IWM	ETF	115.17	115.24	114.56	114.73	6854907.0
2015-01-15 16:00:00	IWM	ETF	114.74	116.28	114.21	114.21	3055938.0
2015-01-15 17:00:00	IWM	ETF	114.25	114.29	113.92	114.13	45317.0
2015-01-15 18:00:00	IWM	ETF	114.14	114.39	114.1	114.1	19501.0
2015-01-15 19:00:00	IWM	ETF	114.14	114.14	113.72	114.09	4225.0
2015-01-15 07:00:00	DIA	ETF	173.38	174.7	173.38	174.23	7132.0
2015-01-15 08:00:00	DIA	ETF	174.12	175.1	173.99	174.71	23046.0
2015-01-15 09:00:00	DIA	ETF	174.75	175.08	173.17	173.46	1568334.0

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

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