PREVIEW / etf_1hour / 2020-01-27

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-01-27.parquet
  size:    384 KB
  rows:    12,702

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
2020-01-27 04:00:00	SPY	ETF	325.61	325.61	324.32	324.56	103764.0
2020-01-27 05:00:00	SPY	ETF	324.31	324.48	323.33	323.33	120092.0
2020-01-27 06:00:00	SPY	ETF	323.22	324.21	323.0	323.9	359946.0
2020-01-27 07:00:00	SPY	ETF	323.95	324.69	323.85	323.97	866576.0
2020-01-27 08:00:00	SPY	ETF	324.4	325.8	323.48	323.66	1109343.0
2020-01-27 09:00:00	SPY	ETF	323.68	324.69	322.66	324.4875	13926769.0
2020-01-27 10:00:00	SPY	ETF	324.47	324.62	323.29	323.87	10200592.0
2020-01-27 11:00:00	SPY	ETF	323.86	324.43	323.31	324.2	8140857.0
2020-01-27 12:00:00	SPY	ETF	324.2	325.12	323.98	324.69	6589163.0
2020-01-27 13:00:00	SPY	ETF	324.67	325.07	324.44	324.6187	4868756.0
2020-01-27 14:00:00	SPY	ETF	324.62	324.99	323.89	324.215	7299936.0
2020-01-27 15:00:00	SPY	ETF	324.215	324.55	323.45	323.52	18684365.0
2020-01-27 16:00:00	SPY	ETF	323.49	328.7677	323.15	323.51	8684524.0
2020-01-27 17:00:00	SPY	ETF	323.52	323.54	323.38	323.42	448146.0
2020-01-27 18:00:00	SPY	ETF	323.37	324.21	323.29	324.03	170804.0
2020-01-27 19:00:00	SPY	ETF	324.03	324.28	323.79	323.92	91784.0
2020-01-27 04:00:00	QQQ	ETF	220.0	220.0	218.87	219.12	130261.0
2020-01-27 05:00:00	QQQ	ETF	219.1	219.1	218.0	218.05	76534.0
2020-01-27 06:00:00	QQQ	ETF	217.9	218.71	217.66	218.39	147344.0
2020-01-27 07:00:00	QQQ	ETF	218.39	219.0	218.35	218.49	455875.0
2020-01-27 08:00:00	QQQ	ETF	218.52	220.18	218.21	218.4601	922274.0
2020-01-27 09:00:00	QQQ	ETF	218.45	218.78	217.18	218.63	8458052.0
2020-01-27 10:00:00	QQQ	ETF	218.62	218.8802	217.72	218.1245	5359696.0
2020-01-27 11:00:00	QQQ	ETF	218.12	218.6	217.65	218.4501	3333635.0
2020-01-27 12:00:00	QQQ	ETF	218.44	219.2845	218.2	218.92	3010021.0
2020-01-27 13:00:00	QQQ	ETF	218.92	219.22	218.7	218.8899	1896799.0
2020-01-27 14:00:00	QQQ	ETF	218.89	219.27	218.17	218.47	3859503.0
2020-01-27 15:00:00	QQQ	ETF	218.46	218.71	217.905	218.05	7053491.0
2020-01-27 16:00:00	QQQ	ETF	218.05	218.14	217.8	218.08	1272915.0
2020-01-27 17:00:00	QQQ	ETF	218.1	218.12	217.89	217.9	451386.0
2020-01-27 18:00:00	QQQ	ETF	217.94	218.63	217.9	218.5	1005874.0
2020-01-27 19:00:00	QQQ	ETF	218.5	218.64	218.17	218.24	78539.0
2020-01-27 04:00:00	IWM	ETF	163.87	163.88	163.34	163.34	18396.0
2020-01-27 05:00:00	IWM	ETF	163.25	163.25	163.0	163.04	12856.0
2020-01-27 06:00:00	IWM	ETF	162.78	163.23	162.68	163.03	43864.0
2020-01-27 07:00:00	IWM	ETF	163.32	163.65	163.12	163.12	67586.0
2020-01-27 08:00:00	IWM	ETF	163.62	163.76	162.99	163.4	305082.0
2020-01-27 09:00:00	IWM	ETF	163.27	163.805	162.42	163.64	3429988.0
2020-01-27 10:00:00	IWM	ETF	163.61	163.845	163.07	163.34	2804904.0
2020-01-27 11:00:00	IWM	ETF	163.35	164.13	163.17	163.96	1507275.0
2020-01-27 12:00:00	IWM	ETF	163.94	164.49	163.84	164.01	1380281.0
2020-01-27 13:00:00	IWM	ETF	164.0	164.35	163.92	164.1601	843135.0
2020-01-27 14:00:00	IWM	ETF	164.17	164.31	163.81	163.97	1193438.0
2020-01-27 15:00:00	IWM	ETF	163.96	164.24	163.42	163.5	2902548.0
2020-01-27 16:00:00	IWM	ETF	163.5	163.64	163.28	163.54	2017293.0
2020-01-27 17:00:00	IWM	ETF	163.57	163.57	163.4	163.49	84694.0
2020-01-27 18:00:00	IWM	ETF	163.42	163.89	163.41	163.79	24360.0
2020-01-27 19:00:00	IWM	ETF	163.8	163.9	163.51	163.72	37778.0
2020-01-27 04:00:00	DIA	ETF	286.87	286.87	286.14	286.22	31595.0
2020-01-27 05:00:00	DIA	ETF	286.0	286.0	285.2	285.2	1200.0

> showing 50 of 12,702 rows — these rows as CSV

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