PREVIEW / etf_1hour / 2018-01-08

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-01-08.parquet
  size:    309 KB
  rows:    10,187

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
2018-01-08 04:00:00	SPY	ETF	273.55	273.6	273.48	273.56	7950.0
2018-01-08 05:00:00	SPY	ETF	273.57	273.69	273.52	273.57	4238.0
2018-01-08 06:00:00	SPY	ETF	273.62	273.68	273.2	273.2	77492.0
2018-01-08 07:00:00	SPY	ETF	273.2	273.32	272.99	273.14	502917.0
2018-01-08 08:00:00	SPY	ETF	273.12	273.35	273.0	273.19	506037.0
2018-01-08 09:00:00	SPY	ETF	273.22	273.47	272.98	273.339	5586435.0
2018-01-08 10:00:00	SPY	ETF	273.34	273.47	273.1	273.39	4392945.0
2018-01-08 11:00:00	SPY	ETF	273.38	273.62	273.3	273.44	3125796.0
2018-01-08 12:00:00	SPY	ETF	273.45	273.67	273.43	273.645	2350036.0
2018-01-08 13:00:00	SPY	ETF	273.65	274.0	273.65	273.95	5501501.0
2018-01-08 14:00:00	SPY	ETF	273.95	274.04	273.87	274.02	3528337.0
2018-01-08 15:00:00	SPY	ETF	274.025	274.1	273.77	273.93	13664702.0
2018-01-08 16:00:00	SPY	ETF	273.94	274.03	273.85	273.97	9331816.0
2018-01-08 17:00:00	SPY	ETF	273.97	274.0	273.5683	273.88	1250012.0
2018-01-08 18:00:00	SPY	ETF	273.91	274.05	273.9	274.04	63441.0
2018-01-08 19:00:00	SPY	ETF	274.02	274.02	273.92	273.96	21540.0
2018-01-08 04:00:00	QQQ	ETF	162.09	162.14	162.05	162.06	13000.0
2018-01-08 05:00:00	QQQ	ETF	162.09	162.14	162.08	162.12	8889.0
2018-01-08 06:00:00	QQQ	ETF	162.16	162.16	162.0	162.0	7797.0
2018-01-08 07:00:00	QQQ	ETF	161.91	161.94	161.76	161.87	88995.0
2018-01-08 08:00:00	QQQ	ETF	161.94	161.94	161.73	161.81	132081.0
2018-01-08 09:00:00	QQQ	ETF	161.83	162.26	161.81	162.17	2645857.0
2018-01-08 10:00:00	QQQ	ETF	162.17	162.425	161.88	162.35	2608369.0
2018-01-08 11:00:00	QQQ	ETF	162.345	162.62	162.285	162.45	1963739.0
2018-01-08 12:00:00	QQQ	ETF	162.45	162.51	162.34	162.41	999955.0
2018-01-08 13:00:00	QQQ	ETF	162.41	162.55	162.372	162.54	1218116.0
2018-01-08 14:00:00	QQQ	ETF	162.54	162.61	162.33	162.43	1572819.0
2018-01-08 15:00:00	QQQ	ETF	162.43	162.63	162.375	162.5	3190625.0
2018-01-08 16:00:00	QQQ	ETF	162.49	162.6	162.46	162.57	1005207.0
2018-01-08 17:00:00	QQQ	ETF	162.59	162.59	162.1419	162.56	450888.0
2018-01-08 18:00:00	QQQ	ETF	162.54	162.68	162.54	162.68	15196.0
2018-01-08 19:00:00	QQQ	ETF	162.62	162.65	162.56	162.65	12662.0
2018-01-08 06:00:00	IWM	ETF	154.7	154.7	154.7	154.7	1000.0
2018-01-08 07:00:00	IWM	ETF	154.63	154.79	154.43	154.52	48517.0
2018-01-08 08:00:00	IWM	ETF	154.46	154.63	154.43	154.54	34160.0
2018-01-08 09:00:00	IWM	ETF	154.5	154.84	153.5	153.85	2462501.0
2018-01-08 10:00:00	IWM	ETF	153.84	154.388	153.58	154.26	1758605.0
2018-01-08 11:00:00	IWM	ETF	154.2462	154.44	154.2	154.34	1255071.0
2018-01-08 12:00:00	IWM	ETF	154.34	154.69	154.34	154.68	872567.0
2018-01-08 13:00:00	IWM	ETF	154.69	155.15	154.69	155.12	1028529.0
2018-01-08 14:00:00	IWM	ETF	155.13	155.27	155.09	155.145	1340789.0
2018-01-08 15:00:00	IWM	ETF	155.15	155.21	155.0	155.01	2433026.0
2018-01-08 16:00:00	IWM	ETF	155.03	155.1	154.94	155.03	2869430.0
2018-01-08 17:00:00	IWM	ETF	155.03	155.03	154.2163	154.2163	1450292.0
2018-01-08 18:00:00	IWM	ETF	154.96	155.07	154.95	155.04	4803.0
2018-01-08 19:00:00	IWM	ETF	155.01	155.03	154.98	154.98	16994.0
2018-01-08 04:00:00	DIA	ETF	253.11	253.11	253.11	253.11	200.0
2018-01-08 06:00:00	DIA	ETF	253.37	253.42	253.32	253.32	750.0
2018-01-08 07:00:00	DIA	ETF	252.95	252.95	252.56	252.56	6701.0
2018-01-08 08:00:00	DIA	ETF	252.56	252.9	252.56	252.72	3974.0

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

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