PREVIEW / etf_1hour / 2019-01-23

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-01-23.parquet
  size:    319 KB
  rows:    10,553

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
2019-01-23 04:00:00	SPY	ETF	262.72	263.32	262.72	263.32	8660.0
2019-01-23 05:00:00	SPY	ETF	263.23	263.57	263.23	263.3	40284.0
2019-01-23 06:00:00	SPY	ETF	263.33	263.58	263.07	263.54	84382.0
2019-01-23 07:00:00	SPY	ETF	263.47	264.2	263.43	263.9	343538.0
2019-01-23 08:00:00	SPY	ETF	263.92	264.2	262.31	263.78	641282.0
2019-01-23 09:00:00	SPY	ETF	263.78	264.66	263.72	264.46	7552070.0
2019-01-23 10:00:00	SPY	ETF	264.465	264.79	262.66	262.86	12245174.0
2019-01-23 11:00:00	SPY	ETF	262.86	263.28	261.01	261.28	12225634.0
2019-01-23 12:00:00	SPY	ETF	261.29	262.22	260.66	262.1343	11613924.0
2019-01-23 13:00:00	SPY	ETF	262.1327	262.61	261.53	262.45	7278270.0
2019-01-23 14:00:00	SPY	ETF	262.46	262.97	261.93	262.29	9744940.0
2019-01-23 15:00:00	SPY	ETF	262.29	263.4	262.26	263.31	15276581.0
2019-01-23 16:00:00	SPY	ETF	263.315	263.42	262.7	263.17	5666477.0
2019-01-23 17:00:00	SPY	ETF	263.17	263.26	262.95	262.95	121358.0
2019-01-23 18:00:00	SPY	ETF	262.95	263.41	262.65	262.8	1611254.0
2019-01-23 19:00:00	SPY	ETF	262.74	263.2	262.58	263.06	87302.0
2019-01-23 04:00:00	QQQ	ETF	161.77	162.25	161.77	162.2	12789.0
2019-01-23 05:00:00	QQQ	ETF	162.33	162.39	162.19	162.25	17561.0
2019-01-23 06:00:00	QQQ	ETF	162.26	162.35	162.12	162.35	12630.0
2019-01-23 07:00:00	QQQ	ETF	162.33	162.78	162.33	162.63	126351.0
2019-01-23 08:00:00	QQQ	ETF	162.41	162.77	161.58	162.5701	252964.0
2019-01-23 09:00:00	QQQ	ETF	162.59	163.49	162.56	163.25	3642147.0
2019-01-23 10:00:00	QQQ	ETF	163.24	163.51	161.89	162.06	4985985.0
2019-01-23 11:00:00	QQQ	ETF	162.05	162.27	160.64	160.85	4894910.0
2019-01-23 12:00:00	QQQ	ETF	160.84	161.36	160.32	161.28	4728292.0
2019-01-23 13:00:00	QQQ	ETF	161.3	161.67	160.8201	161.48	3382476.0
2019-01-23 14:00:00	QQQ	ETF	161.5	161.91	161.07	161.37	3684028.0
2019-01-23 15:00:00	QQQ	ETF	161.37	162.19	161.32	162.18	4738577.0
2019-01-23 16:00:00	QQQ	ETF	162.18	162.41	161.89	162.27	1800479.0
2019-01-23 17:00:00	QQQ	ETF	162.28	162.29	162.16	162.23	42955.0
2019-01-23 18:00:00	QQQ	ETF	162.09	162.32	161.91	162.01	59796.0
2019-01-23 19:00:00	QQQ	ETF	162.0	162.33	161.87	162.23	58398.0
2019-01-23 05:00:00	IWM	ETF	145.4	145.4	145.35	145.35	2500.0
2019-01-23 06:00:00	IWM	ETF	145.31	145.4	145.3	145.4	26000.0
2019-01-23 07:00:00	IWM	ETF	145.4	145.68	145.4	145.65	17615.0
2019-01-23 08:00:00	IWM	ETF	145.0	145.62	145.0	145.3	67898.0
2019-01-23 09:00:00	IWM	ETF	145.33	146.18	145.22	145.88	1697563.0
2019-01-23 10:00:00	IWM	ETF	145.86	146.12	144.77	144.9	2910614.0
2019-01-23 11:00:00	IWM	ETF	144.9099	145.26	143.54	143.7	2390817.0
2019-01-23 12:00:00	IWM	ETF	143.7	144.3201	143.46	144.14	1856699.0
2019-01-23 13:00:00	IWM	ETF	144.14	144.29	143.67	144.04	1956305.0
2019-01-23 14:00:00	IWM	ETF	144.04	144.39	143.74	144.11	2218645.0
2019-01-23 15:00:00	IWM	ETF	144.11	144.62	144.09	144.61	2686268.0
2019-01-23 16:00:00	IWM	ETF	144.6	144.68	144.41	144.51	1587939.0
2019-01-23 17:00:00	IWM	ETF	144.44	144.6	144.44	144.44	12609.0
2019-01-23 18:00:00	IWM	ETF	144.45	144.47	144.21	144.21	19025.0
2019-01-23 19:00:00	IWM	ETF	144.14	144.5781	144.1	144.5781	108200.0
2019-01-23 05:00:00	DIA	ETF	245.06	245.06	244.82	244.82	2660.0
2019-01-23 06:00:00	DIA	ETF	245.2	245.22	245.2	245.22	900.0
2019-01-23 07:00:00	DIA	ETF	245.26	245.89	245.26	245.8	17728.0

> showing 50 of 10,553 rows — these rows as CSV

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