PREVIEW / etf_1hour / 2020-01-21

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-01-21.parquet
  size:    375 KB
  rows:    12,446

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-21 04:00:00	SPY	ETF	330.7	330.75	330.14	330.34	43583.0
2020-01-21 05:00:00	SPY	ETF	330.4	330.47	330.28	330.39	26674.0
2020-01-21 06:00:00	SPY	ETF	330.52	330.74	330.4	330.72	69201.0
2020-01-21 07:00:00	SPY	ETF	330.76	330.92	330.68	330.79	325242.0
2020-01-21 08:00:00	SPY	ETF	330.715	330.93	330.1	330.62	398702.0
2020-01-21 09:00:00	SPY	ETF	330.66	331.56	330.65	331.25	7607501.0
2020-01-21 10:00:00	SPY	ETF	331.24	331.54	330.95	331.17	10888616.0
2020-01-21 11:00:00	SPY	ETF	331.17	332.08	331.14	331.99	14259254.0
2020-01-21 12:00:00	SPY	ETF	331.99	332.18	331.9	332.02	4299544.0
2020-01-21 13:00:00	SPY	ETF	332.015	332.09	330.95	331.0	8055807.0
2020-01-21 14:00:00	SPY	ETF	331.0	331.5	330.82	331.4	6093299.0
2020-01-21 15:00:00	SPY	ETF	331.4	331.76	331.02	331.31	10768713.0
2020-01-21 16:00:00	SPY	ETF	331.31	331.46	331.09	331.22	11793358.0
2020-01-21 17:00:00	SPY	ETF	331.15	331.3	331.12	331.25	435306.0
2020-01-21 18:00:00	SPY	ETF	331.29	331.4	331.15	331.2	81011.0
2020-01-21 19:00:00	SPY	ETF	331.3	331.62	331.27	331.5	53962.0
2020-01-21 04:00:00	QQQ	ETF	222.35	222.35	221.93	222.05	36449.0
2020-01-21 05:00:00	QQQ	ETF	222.04	222.15	222.0	222.13	44961.0
2020-01-21 06:00:00	QQQ	ETF	222.1	222.34	222.05	222.3	62344.0
2020-01-21 07:00:00	QQQ	ETF	222.35	222.45	222.3	222.4	135231.0
2020-01-21 08:00:00	QQQ	ETF	222.35	223.38	221.94	222.4	154133.0
2020-01-21 09:00:00	QQQ	ETF	222.45	223.25	222.45	223.1	3187205.0
2020-01-21 10:00:00	QQQ	ETF	223.1	223.4	222.9002	223.07	2383756.0
2020-01-21 11:00:00	QQQ	ETF	223.05	223.84	223.01	223.64	1851099.0
2020-01-21 12:00:00	QQQ	ETF	223.64	223.73	223.54	223.62	885376.0
2020-01-21 13:00:00	QQQ	ETF	223.615	223.72	222.701	222.7899	1969547.0
2020-01-21 14:00:00	QQQ	ETF	222.785	223.195	222.66	223.1399	1989598.0
2020-01-21 15:00:00	QQQ	ETF	223.14	223.6253	223.1	223.34	3053535.0
2020-01-21 16:00:00	QQQ	ETF	223.34	223.61	222.99	223.2	1806585.0
2020-01-21 17:00:00	QQQ	ETF	223.22	223.3	223.18	223.3	30393.0
2020-01-21 18:00:00	QQQ	ETF	223.35	223.44	223.22	223.28	258414.0
2020-01-21 19:00:00	QQQ	ETF	223.33	223.58	223.3	223.5	41245.0
2020-01-21 04:00:00	IWM	ETF	168.0	168.04	167.81	167.88	10319.0
2020-01-21 05:00:00	IWM	ETF	168.03	168.03	168.03	168.03	300.0
2020-01-21 06:00:00	IWM	ETF	168.15	168.36	168.09	168.34	6494.0
2020-01-21 07:00:00	IWM	ETF	168.45	168.45	168.37	168.44	14570.0
2020-01-21 08:00:00	IWM	ETF	168.3801	168.48	168.12	168.16	44368.0
2020-01-21 09:00:00	IWM	ETF	168.27	168.52	167.95	168.21	1266948.0
2020-01-21 10:00:00	IWM	ETF	168.2	168.47	167.68	167.89	1870791.0
2020-01-21 11:00:00	IWM	ETF	167.89	168.19	167.84	168.15	1158362.0
2020-01-21 12:00:00	IWM	ETF	168.13	168.27	168.025	168.08	659615.0
2020-01-21 13:00:00	IWM	ETF	168.08	168.16	167.27	167.44	1362028.0
2020-01-21 14:00:00	IWM	ETF	167.44	167.85	167.35	167.82	1277077.0
2020-01-21 15:00:00	IWM	ETF	167.81	168.0	167.37	167.63	3003791.0
2020-01-21 16:00:00	IWM	ETF	167.67	168.9905	167.49	167.5	2112071.0
2020-01-21 17:00:00	IWM	ETF	167.51	167.62	167.51	167.6	2003.0
2020-01-21 18:00:00	IWM	ETF	167.61	167.67	167.53	167.58	446876.0
2020-01-21 19:00:00	IWM	ETF	167.67	167.82	167.67	167.74	7700.0
2020-01-21 04:00:00	DIA	ETF	292.14	292.14	292.0	292.0	314.0
2020-01-21 05:00:00	DIA	ETF	292.21	292.21	292.21	292.21	300.0

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

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