PREVIEW / etf_1hour / 2020-01-31

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-01-31.parquet
  size:    376 KB
  rows:    12,279

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-31 04:00:00	SPY	ETF	327.33	327.48	326.94	327.13	22694.0
2020-01-31 05:00:00	SPY	ETF	327.11	327.26	326.03	326.6	62279.0
2020-01-31 06:00:00	SPY	ETF	326.6	326.93	326.43	326.82	93385.0
2020-01-31 07:00:00	SPY	ETF	326.82	327.45	326.77	327.04	237916.0
2020-01-31 08:00:00	SPY	ETF	326.92	329.0	326.7	327.1	505447.0
2020-01-31 09:00:00	SPY	ETF	327.1	327.43	325.43	326.05	7840917.0
2020-01-31 10:00:00	SPY	ETF	326.03	326.035	323.76	323.95	11194359.0
2020-01-31 11:00:00	SPY	ETF	323.96	324.34	322.63	324.095	13948920.0
2020-01-31 12:00:00	SPY	ETF	324.095	324.095	322.11	322.69	13856329.0
2020-01-31 13:00:00	SPY	ETF	322.6899	323.15	321.65	322.47	9431122.0
2020-01-31 14:00:00	SPY	ETF	322.48	323.23	322.18	322.49	9440659.0
2020-01-31 15:00:00	SPY	ETF	322.5	322.75	320.73	321.74	29314787.0
2020-01-31 16:00:00	SPY	ETF	321.75	327.674	321.64	322.17	14678233.0
2020-01-31 17:00:00	SPY	ETF	322.27	322.27	321.73	321.98	329216.0
2020-01-31 18:00:00	SPY	ETF	321.92	322.04	321.86	322.0	97961.0
2020-01-31 19:00:00	SPY	ETF	321.93	321.97	321.85	321.85	50847.0
2020-01-31 04:00:00	QQQ	ETF	223.5	223.61	223.21	223.35	58845.0
2020-01-31 05:00:00	QQQ	ETF	223.3	223.47	222.53	222.97	46365.0
2020-01-31 06:00:00	QQQ	ETF	223.0	223.28	222.89	223.26	52175.0
2020-01-31 07:00:00	QQQ	ETF	223.27	223.94	223.25	223.59	276693.0
2020-01-31 08:00:00	QQQ	ETF	223.7299	224.98	222.98	223.63	399507.0
2020-01-31 09:00:00	QQQ	ETF	223.7	223.98	221.595	222.24	4688546.0
2020-01-31 10:00:00	QQQ	ETF	222.24	222.32	220.39	220.63	5420056.0
2020-01-31 11:00:00	QQQ	ETF	220.59	220.98	219.44	220.865	6188425.0
2020-01-31 12:00:00	QQQ	ETF	220.86	220.86	219.51	219.9964	3923773.0
2020-01-31 13:00:00	QQQ	ETF	219.98	220.31	219.04	219.66	3576627.0
2020-01-31 14:00:00	QQQ	ETF	219.67	220.235	219.42	219.71	4057467.0
2020-01-31 15:00:00	QQQ	ETF	219.71	219.905	218.285	219.01	8943970.0
2020-01-31 16:00:00	QQQ	ETF	218.97	219.56	218.92	219.45	3424177.0
2020-01-31 17:00:00	QQQ	ETF	219.5	219.5	219.07	219.22	317136.0
2020-01-31 18:00:00	QQQ	ETF	219.22	219.25	219.07	219.1	21475.0
2020-01-31 19:00:00	QQQ	ETF	219.07	219.17	218.98	218.98	14744.0
2020-01-31 04:00:00	IWM	ETF	163.5	163.6	163.36	163.55	9902.0
2020-01-31 05:00:00	IWM	ETF	163.41	163.42	162.86	162.87	6500.0
2020-01-31 06:00:00	IWM	ETF	162.99	163.3	162.99	163.2	12300.0
2020-01-31 07:00:00	IWM	ETF	163.29	163.45	163.25	163.27	12420.0
2020-01-31 08:00:00	IWM	ETF	163.34	163.34	162.98	163.14	121659.0
2020-01-31 09:00:00	IWM	ETF	163.2	163.51	162.25	162.61	2298120.0
2020-01-31 10:00:00	IWM	ETF	162.5989	162.61	161.19	161.33	3638737.0
2020-01-31 11:00:00	IWM	ETF	161.335	161.53	160.665	161.41	3189699.0
2020-01-31 12:00:00	IWM	ETF	161.4	161.54	160.405	160.675	2465681.0
2020-01-31 13:00:00	IWM	ETF	160.66	160.93	160.3	160.72	1726984.0
2020-01-31 14:00:00	IWM	ETF	160.73	161.14	160.58	160.81	2297810.0
2020-01-31 15:00:00	IWM	ETF	160.81	160.98	160.03	160.55	5882915.0
2020-01-31 16:00:00	IWM	ETF	160.55	161.05	160.48	160.75	2459640.0
2020-01-31 17:00:00	IWM	ETF	160.92	160.92	160.53	160.61	119341.0
2020-01-31 18:00:00	IWM	ETF	160.65	160.65	160.53	160.54	17493.0
2020-01-31 19:00:00	IWM	ETF	160.57	160.65	160.5	160.51	2092.0
2020-01-31 04:00:00	DIA	ETF	287.8	287.8	287.75	287.75	400.0
2020-01-31 05:00:00	DIA	ETF	287.0	287.04	286.55	286.81	1000.0

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

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