PREVIEW / etf_1hour / 2017-05-26

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-05-26.parquet
  size:    268 KB
  rows:    8,783

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
2017-05-26 04:00:00	SPY	ETF	241.79	241.8	241.44	241.49	5450.0
2017-05-26 05:00:00	SPY	ETF	241.47	241.54	241.37	241.37	20225.0
2017-05-26 06:00:00	SPY	ETF	241.4	241.5	241.4	241.42	15610.0
2017-05-26 07:00:00	SPY	ETF	241.5	241.5	241.18	241.21	352147.0
2017-05-26 08:00:00	SPY	ETF	241.22	241.51	241.17	241.46	238687.0
2017-05-26 09:00:00	SPY	ETF	241.49	241.79	241.45	241.73	4444211.0
2017-05-26 10:00:00	SPY	ETF	241.73	241.9	241.6	241.6	4980683.0
2017-05-26 11:00:00	SPY	ETF	241.6073	241.8	241.52	241.53	4260043.0
2017-05-26 12:00:00	SPY	ETF	241.53	241.82	241.52	241.76	2583953.0
2017-05-26 13:00:00	SPY	ETF	241.76	241.84	241.64	241.68	2951300.0
2017-05-26 14:00:00	SPY	ETF	241.68	241.81	241.63	241.7375	3192872.0
2017-05-26 15:00:00	SPY	ETF	241.73	241.84	241.63	241.74	9183093.0
2017-05-26 16:00:00	SPY	ETF	241.75	241.8	241.67	241.8	12097951.0
2017-05-26 17:00:00	SPY	ETF	241.78	241.8	241.72	241.77	63542.0
2017-05-26 18:00:00	SPY	ETF	241.78	241.79	241.76	241.77	26851.0
2017-05-26 19:00:00	SPY	ETF	241.77	241.8	241.77	241.8	54101.0
2017-05-26 04:00:00	QQQ	ETF	141.03	141.05	140.97	140.97	1500.0
2017-05-26 05:00:00	QQQ	ETF	140.96	141.0	140.89	140.89	1700.0
2017-05-26 06:00:00	QQQ	ETF	140.93	140.98	140.92	140.92	3750.0
2017-05-26 07:00:00	QQQ	ETF	140.91	140.91	140.78	140.79	17004.0
2017-05-26 08:00:00	QQQ	ETF	140.79	140.95	140.78	140.93	43961.0
2017-05-26 09:00:00	QQQ	ETF	140.96	141.1251	140.81	141.11	1451728.0
2017-05-26 10:00:00	QQQ	ETF	141.1073	141.28	141.071	141.1	1380221.0
2017-05-26 11:00:00	QQQ	ETF	141.1	141.17	140.97	140.97	1364134.0
2017-05-26 12:00:00	QQQ	ETF	140.97	141.13	140.9634	141.07	833633.0
2017-05-26 13:00:00	QQQ	ETF	141.07	141.11	140.97	141.04	1077010.0
2017-05-26 14:00:00	QQQ	ETF	141.045	141.14	141.03	141.1033	868185.0
2017-05-26 15:00:00	QQQ	ETF	141.1054	141.22	141.08	141.21	2358725.0
2017-05-26 16:00:00	QQQ	ETF	141.2	141.33	141.17	141.33	1290531.0
2017-05-26 17:00:00	QQQ	ETF	141.31	141.33	141.22	141.22	2578.0
2017-05-26 18:00:00	QQQ	ETF	141.32	141.32	141.28	141.29	3549.0
2017-05-26 19:00:00	QQQ	ETF	141.29	141.33	141.25	141.33	984.0
2017-05-26 04:00:00	IWM	ETF	137.39	137.39	137.39	137.39	100.0
2017-05-26 06:00:00	IWM	ETF	137.24	137.26	137.17	137.26	5700.0
2017-05-26 07:00:00	IWM	ETF	137.2	137.2	136.98	137.02	41437.0
2017-05-26 08:00:00	IWM	ETF	137.02	137.25	137.0	137.23	75392.0
2017-05-26 09:00:00	IWM	ETF	137.3	137.53	137.03	137.26	2313773.0
2017-05-26 10:00:00	IWM	ETF	137.26	137.32	136.78	137.06	4049291.0
2017-05-26 11:00:00	IWM	ETF	137.06	137.5699	137.06	137.19	2184331.0
2017-05-26 12:00:00	IWM	ETF	137.1801	137.69	137.1801	137.64	1414157.0
2017-05-26 13:00:00	IWM	ETF	137.64	137.79	137.49	137.5	1194618.0
2017-05-26 14:00:00	IWM	ETF	137.5	137.54	137.36	137.4415	930018.0
2017-05-26 15:00:00	IWM	ETF	137.45	137.62	137.37	137.52	2756419.0
2017-05-26 16:00:00	IWM	ETF	137.54	137.5434	137.36	137.45	2627770.0
2017-05-26 17:00:00	IWM	ETF	137.43	137.45	137.41	137.41	2737.0
2017-05-26 19:00:00	IWM	ETF	137.42	137.42	137.41	137.42	1035.0
2017-05-26 04:00:00	DIA	ETF	210.5	210.6	210.5	210.6	200.0
2017-05-26 06:00:00	DIA	ETF	210.3	210.3	210.3	210.3	500.0
2017-05-26 07:00:00	DIA	ETF	210.3	210.3	210.3	210.3	100.0
2017-05-26 08:00:00	DIA	ETF	210.4	210.42	210.31	210.39	1600.0

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

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