PREVIEW / etf_1hour / 2020-11-17

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-11-17.parquet
  size:    392 KB
  rows:    13,313

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-11-17 04:00:00	SPY	ETF	361.05	361.27	360.92	361.05	32881.0
2020-11-17 05:00:00	SPY	ETF	360.95	360.98	360.56	360.75	14828.0
2020-11-17 06:00:00	SPY	ETF	360.55	360.77	360.11	360.45	63491.0
2020-11-17 07:00:00	SPY	ETF	360.45	360.8	359.85	360.03	335385.0
2020-11-17 08:00:00	SPY	ETF	360.03	361.5	359.25	359.81	576043.0
2020-11-17 09:00:00	SPY	ETF	359.82	360.15	358.34	358.407	8731664.0
2020-11-17 10:00:00	SPY	ETF	358.41	360.697	358.38	360.57	12397713.0
2020-11-17 11:00:00	SPY	ETF	360.57	361.18	360.34	360.81	7544050.0
2020-11-17 12:00:00	SPY	ETF	360.8	361.74	360.68	361.35	4504551.0
2020-11-17 13:00:00	SPY	ETF	361.34	361.72	360.77	360.98	3338336.0
2020-11-17 14:00:00	SPY	ETF	360.96	361.92	360.93	361.52	4775660.0
2020-11-17 15:00:00	SPY	ETF	361.52	361.55	359.75	360.64	15387065.0
2020-11-17 16:00:00	SPY	ETF	360.64	361.15	360.29	360.29	7183456.0
2020-11-17 17:00:00	SPY	ETF	360.28	360.62	360.28	360.42	223933.0
2020-11-17 18:00:00	SPY	ETF	360.41	361.05	360.13	360.86	168199.0
2020-11-17 19:00:00	SPY	ETF	360.86	360.91	359.5	359.87	141821.0
2020-11-17 04:00:00	QQQ	ETF	293.58	294.03	293.48	293.71	22751.0
2020-11-17 05:00:00	QQQ	ETF	293.74	293.74	292.83	293.17	31793.0
2020-11-17 06:00:00	QQQ	ETF	293.08	293.72	292.8	293.66	76120.0
2020-11-17 07:00:00	QQQ	ETF	293.6	293.9	293.33	293.44	133170.0
2020-11-17 08:00:00	QQQ	ETF	293.43	293.99	292.66	293.49	274208.0
2020-11-17 09:00:00	QQQ	ETF	293.4202	293.71	291.76	291.82	2832972.0
2020-11-17 10:00:00	QQQ	ETF	291.828	293.57	291.828	293.509	2764138.0
2020-11-17 11:00:00	QQQ	ETF	293.49	293.59	291.89	292.7	2208936.0
2020-11-17 12:00:00	QQQ	ETF	292.68	293.26	292.6	293.1287	1652202.0
2020-11-17 13:00:00	QQQ	ETF	293.15	293.74	292.74	292.96	1520491.0
2020-11-17 14:00:00	QQQ	ETF	292.96	293.56	292.9	292.9906	1888149.0
2020-11-17 15:00:00	QQQ	ETF	293.01	293.06	291.61	292.12	4411922.0
2020-11-17 16:00:00	QQQ	ETF	292.15	292.7331	291.89	291.89	1035650.0
2020-11-17 17:00:00	QQQ	ETF	292.05	292.14	291.91	292.11	10466.0
2020-11-17 18:00:00	QQQ	ETF	292.06	292.36	291.8	292.24	70080.0
2020-11-17 19:00:00	QQQ	ETF	292.17	292.26	291.3	291.48	129592.0
2020-11-17 04:00:00	IWM	ETF	177.1	177.14	176.65	176.65	10746.0
2020-11-17 05:00:00	IWM	ETF	176.62	176.67	176.44	176.62	5578.0
2020-11-17 06:00:00	IWM	ETF	176.55	176.57	176.1	176.36	28293.0
2020-11-17 07:00:00	IWM	ETF	176.33	176.46	175.74	176.08	212307.0
2020-11-17 08:00:00	IWM	ETF	176.3399	177.1	175.2	175.69	122796.0
2020-11-17 09:00:00	IWM	ETF	175.76	176.3	174.28	174.335	3522550.0
2020-11-17 10:00:00	IWM	ETF	174.33	175.71	174.2903	175.55	3095016.0
2020-11-17 11:00:00	IWM	ETF	175.55	176.84	175.36	176.72	2105191.0
2020-11-17 12:00:00	IWM	ETF	176.72	177.75	176.53	177.62	1633017.0
2020-11-17 13:00:00	IWM	ETF	177.63	177.999	177.415	177.86	1382605.0
2020-11-17 14:00:00	IWM	ETF	177.86	178.8	177.86	178.57	2613402.0
2020-11-17 15:00:00	IWM	ETF	178.55	178.55	177.61	178.44	4280231.0
2020-11-17 16:00:00	IWM	ETF	178.45	178.52	177.4979	177.92	2719202.0
2020-11-17 17:00:00	IWM	ETF	178.06	178.06	177.86	177.94	16374.0
2020-11-17 18:00:00	IWM	ETF	177.97	178.5	177.76	178.26	67416.0
2020-11-17 19:00:00	IWM	ETF	178.26	178.35	177.59	177.71	23479.0
2020-11-17 04:00:00	DIA	ETF	299.08	299.1	299.06	299.07	600.0
2020-11-17 05:00:00	DIA	ETF	299.09	299.15	298.78	298.78	1181.0

> showing 50 of 13,313 rows — these rows as CSV

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