PREVIEW / etf_1hour / 2020-02-03

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-02-03.parquet
  size:    373 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-02-03 04:00:00	SPY	ETF	323.5	323.52	322.82	322.98	89419.0
2020-02-03 05:00:00	SPY	ETF	322.84	323.32	322.72	323.13	18239.0
2020-02-03 06:00:00	SPY	ETF	323.22	323.65	323.18	323.39	68460.0
2020-02-03 07:00:00	SPY	ETF	323.35	323.47	323.01	323.32	256952.0
2020-02-03 08:00:00	SPY	ETF	323.31	324.38	321.73	323.66	622034.0
2020-02-03 09:00:00	SPY	ETF	323.63	325.24	323.22	325.16	7246535.0
2020-02-03 10:00:00	SPY	ETF	325.17	326.16	324.92	325.18	12392025.0
2020-02-03 11:00:00	SPY	ETF	325.19	325.53	323.72	324.27	9892097.0
2020-02-03 12:00:00	SPY	ETF	324.25	324.93	323.91	324.85	5649386.0
2020-02-03 13:00:00	SPY	ETF	324.85	324.92	324.05	324.62	4974546.0
2020-02-03 14:00:00	SPY	ETF	324.62	324.74	323.97	324.53	5977587.0
2020-02-03 15:00:00	SPY	ETF	324.52	325.01	323.9	324.14	13217810.0
2020-02-03 16:00:00	SPY	ETF	324.14	324.2138	321.8814	324.01	6580306.0
2020-02-03 17:00:00	SPY	ETF	324.02	324.02	323.81	323.9	158012.0
2020-02-03 18:00:00	SPY	ETF	323.9	323.9	323.07	323.61	192410.0
2020-02-03 19:00:00	SPY	ETF	323.61	324.21	323.6	324.18	104461.0
2020-02-03 04:00:00	QQQ	ETF	220.42	220.58	219.99	220.0	79357.0
2020-02-03 05:00:00	QQQ	ETF	219.95	220.18	219.81	220.09	29184.0
2020-02-03 06:00:00	QQQ	ETF	220.21	220.5	220.1	220.25	50460.0
2020-02-03 07:00:00	QQQ	ETF	220.24	220.34	219.93	220.18	185373.0
2020-02-03 08:00:00	QQQ	ETF	220.18	221.23	219.07	220.53	288353.0
2020-02-03 09:00:00	QQQ	ETF	220.52	222.2	219.99	222.16	3786826.0
2020-02-03 10:00:00	QQQ	ETF	222.18	222.885	222.0	222.27	4366588.0
2020-02-03 11:00:00	QQQ	ETF	222.272	222.67	221.62	221.98	2824496.0
2020-02-03 12:00:00	QQQ	ETF	221.96	222.66	221.8	222.56	1717519.0
2020-02-03 13:00:00	QQQ	ETF	222.59	222.6177	221.69	222.21	1868842.0
2020-02-03 14:00:00	QQQ	ETF	222.2	222.39	221.82	222.16	1446966.0
2020-02-03 15:00:00	QQQ	ETF	222.16	222.74	221.99	222.3	3263029.0
2020-02-03 16:00:00	QQQ	ETF	222.31	222.8	221.3	221.67	2775757.0
2020-02-03 17:00:00	QQQ	ETF	222.38	222.38	221.5	221.61	23165.0
2020-02-03 18:00:00	QQQ	ETF	221.54	221.55	220.93	221.31	84461.0
2020-02-03 19:00:00	QQQ	ETF	221.3	221.78	221.3	221.72	24401.0
2020-02-03 04:00:00	IWM	ETF	161.26	161.26	161.16	161.16	1000.0
2020-02-03 05:00:00	IWM	ETF	161.15	161.35	161.15	161.26	6048.0
2020-02-03 06:00:00	IWM	ETF	161.27	161.46	161.23	161.38	19195.0
2020-02-03 07:00:00	IWM	ETF	161.37	161.42	161.26	161.34	17573.0
2020-02-03 08:00:00	IWM	ETF	161.37	162.09	161.32	161.79	105200.0
2020-02-03 09:00:00	IWM	ETF	161.75	162.29	161.49	162.03	2501080.0
2020-02-03 10:00:00	IWM	ETF	162.04	162.93	162.04	162.52	2782878.0
2020-02-03 11:00:00	IWM	ETF	162.53	162.685	161.63	161.97	1992736.0
2020-02-03 12:00:00	IWM	ETF	161.94	162.4	161.67	162.37	914914.0
2020-02-03 13:00:00	IWM	ETF	162.3809	162.41	161.865	162.26	890204.0
2020-02-03 14:00:00	IWM	ETF	162.25	162.48	162.0	162.37	1442738.0
2020-02-03 15:00:00	IWM	ETF	162.36	162.575	161.98	162.32	2495366.0
2020-02-03 16:00:00	IWM	ETF	162.31	162.4466	162.09	162.21	1346079.0
2020-02-03 17:00:00	IWM	ETF	162.23	162.23	162.16	162.2	1493.0
2020-02-03 18:00:00	IWM	ETF	162.17	162.32	161.85	162.2	44448.0
2020-02-03 19:00:00	IWM	ETF	162.1	162.34	162.1	162.32	26150.0
2020-02-03 04:00:00	DIA	ETF	283.83	283.83	283.34	283.34	1865.0
2020-02-03 05:00:00	DIA	ETF	283.38	283.59	283.37	283.37	900.0

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

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