PREVIEW / etf_1hour / 2020-05-08

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-05-08.parquet
  size:    365 KB
  rows:    12,486

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-05-08 04:00:00	SPY	ETF	291.0	291.0	290.43	290.98	68411.0
2020-05-08 05:00:00	SPY	ETF	290.85	291.56	290.85	291.56	41599.0
2020-05-08 06:00:00	SPY	ETF	291.5	291.74	291.38	291.5	70632.0
2020-05-08 07:00:00	SPY	ETF	291.48	291.48	290.87	290.9	262687.0
2020-05-08 08:00:00	SPY	ETF	290.9	292.23	290.48	291.32	1873038.0
2020-05-08 09:00:00	SPY	ETF	291.32	291.75	289.86	290.8	7577332.0
2020-05-08 10:00:00	SPY	ETF	290.79	291.53	290.54	290.84	9091422.0
2020-05-08 11:00:00	SPY	ETF	290.83	291.85	290.43	291.73	7177835.0
2020-05-08 12:00:00	SPY	ETF	291.72	292.0	291.49	291.945	4703160.0
2020-05-08 13:00:00	SPY	ETF	291.94	292.05	290.76	291.1099	6046914.0
2020-05-08 14:00:00	SPY	ETF	291.11	291.75	290.79	291.66	6653251.0
2020-05-08 15:00:00	SPY	ETF	291.67	292.95	291.49	292.47	20778453.0
2020-05-08 16:00:00	SPY	ETF	292.46	293.54	291.6702	293.33	10617528.0
2020-05-08 17:00:00	SPY	ETF	293.37	293.49	292.44	293.3	592582.0
2020-05-08 18:00:00	SPY	ETF	293.3	293.49	293.3	293.45	68749.0
2020-05-08 19:00:00	SPY	ETF	293.49	293.74	293.45	293.74	104342.0
2020-05-08 04:00:00	QQQ	ETF	224.12	224.24	223.78	224.12	33168.0
2020-05-08 05:00:00	QQQ	ETF	224.2	224.51	224.0	224.41	28350.0
2020-05-08 06:00:00	QQQ	ETF	224.51	224.78	224.45	224.69	105885.0
2020-05-08 07:00:00	QQQ	ETF	224.6	224.69	224.29	224.34	267449.0
2020-05-08 08:00:00	QQQ	ETF	224.35	224.94	221.82	224.18	719717.0
2020-05-08 09:00:00	QQQ	ETF	224.15	224.45	222.48	223.13	4609791.0
2020-05-08 10:00:00	QQQ	ETF	223.14	224.391	223.14	223.85	4661627.0
2020-05-08 11:00:00	QQQ	ETF	223.85	224.69	223.505	224.6	2938201.0
2020-05-08 12:00:00	QQQ	ETF	224.61	224.93	224.42	224.86	2187405.0
2020-05-08 13:00:00	QQQ	ETF	224.8508	224.95	223.53	223.75	2836726.0
2020-05-08 14:00:00	QQQ	ETF	223.75	224.22	223.32	224.16	2419059.0
2020-05-08 15:00:00	QQQ	ETF	224.155	225.0	223.99	224.77	5574351.0
2020-05-08 16:00:00	QQQ	ETF	224.77	225.2	224.75	225.04	1236203.0
2020-05-08 17:00:00	QQQ	ETF	224.98	225.17	224.95	225.15	38660.0
2020-05-08 18:00:00	QQQ	ETF	225.11	225.42	225.09	225.33	59535.0
2020-05-08 19:00:00	QQQ	ETF	225.32	225.7	225.32	225.42	49877.0
2020-05-08 04:00:00	IWM	ETF	129.38	129.45	129.15	129.4	3729.0
2020-05-08 05:00:00	IWM	ETF	129.54	129.75	129.46	129.75	5706.0
2020-05-08 06:00:00	IWM	ETF	129.78	129.88	129.7	129.82	66118.0
2020-05-08 07:00:00	IWM	ETF	129.76	129.76	129.47	129.48	126161.0
2020-05-08 08:00:00	IWM	ETF	129.52	130.45	129.35	129.98	357337.0
2020-05-08 09:00:00	IWM	ETF	129.94	131.045	129.19	130.86	4766922.0
2020-05-08 10:00:00	IWM	ETF	130.87	131.43	130.2001	130.34	4940541.0
2020-05-08 11:00:00	IWM	ETF	130.35	131.62	130.09	131.585	2672549.0
2020-05-08 12:00:00	IWM	ETF	131.59	131.76	131.26	131.682	1981670.0
2020-05-08 13:00:00	IWM	ETF	131.69	131.835	130.835	131.38	1875477.0
2020-05-08 14:00:00	IWM	ETF	131.38	132.11	131.14	132.08	2203041.0
2020-05-08 15:00:00	IWM	ETF	132.08	132.75	131.87	132.32	7602484.0
2020-05-08 16:00:00	IWM	ETF	132.32	132.65	132.3	132.61	1700669.0
2020-05-08 17:00:00	IWM	ETF	132.6	132.75	132.36	132.64	69185.0
2020-05-08 18:00:00	IWM	ETF	132.58	132.66	132.39	132.53	27357.0
2020-05-08 19:00:00	IWM	ETF	132.6	132.75	132.52	132.73	26259.0
2020-05-08 04:00:00	DIA	ETF	241.54	241.74	241.41	241.65	3190.0
2020-05-08 05:00:00	DIA	ETF	241.88	242.21	241.88	242.21	3562.0

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

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