PREVIEW / etf_1hour / 2020-03-23

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-03-23.parquet
  size:    407 KB
  rows:    14,150

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-03-23 04:00:00	SPY	ETF	221.14	222.0	219.79	220.8	262956.0
2020-03-23 05:00:00	SPY	ETF	220.84	223.63	220.84	222.52	196577.0
2020-03-23 06:00:00	SPY	ETF	222.36	224.37	221.86	223.87	210253.0
2020-03-23 07:00:00	SPY	ETF	223.79	224.05	220.9	222.1	1494474.0
2020-03-23 08:00:00	SPY	ETF	221.94	238.89	218.34	234.59	11711786.0
2020-03-23 09:00:00	SPY	ETF	234.6	235.92	221.96	227.41	44057254.0
2020-03-23 10:00:00	SPY	ETF	227.4	228.78	223.33	223.54	31694996.0
2020-03-23 11:00:00	SPY	ETF	223.52	225.16	218.26	220.48	36247495.0
2020-03-23 12:00:00	SPY	ETF	220.48	228.16	219.27	227.38	41313437.0
2020-03-23 13:00:00	SPY	ETF	227.4	229.39	221.66	222.95	32774241.0
2020-03-23 14:00:00	SPY	ETF	222.96	229.6833	220.7594	222.17	37579196.0
2020-03-23 15:00:00	SPY	ETF	222.18	224.96	219.02	222.51	60526610.0
2020-03-23 16:00:00	SPY	ETF	222.39	223.59	220.61	222.16	19619016.0
2020-03-23 17:00:00	SPY	ETF	222.15	224.55	222.03	224.0	3402677.0
2020-03-23 18:00:00	SPY	ETF	223.84	227.19	222.95	226.25	2141409.0
2020-03-23 19:00:00	SPY	ETF	226.01	228.87	225.8	225.93	764718.0
2020-03-23 04:00:00	QQQ	ETF	165.65	166.31	164.25	164.8	176546.0
2020-03-23 05:00:00	QQQ	ETF	165.28	166.64	164.98	165.89	74571.0
2020-03-23 06:00:00	QQQ	ETF	165.82	167.45	165.45	167.2	77501.0
2020-03-23 07:00:00	QQQ	ETF	167.19	167.23	165.35	165.76	368369.0
2020-03-23 08:00:00	QQQ	ETF	165.74	178.76	165.0	174.93	4269323.0
2020-03-23 09:00:00	QQQ	ETF	174.9	176.08	166.81	171.47	15905867.0
2020-03-23 10:00:00	QQQ	ETF	171.47	172.6	168.61	168.78	12746118.0
2020-03-23 11:00:00	QQQ	ETF	168.78	169.88	164.93	167.13	14436219.0
2020-03-23 12:00:00	QQQ	ETF	167.09	173.34	166.23	172.72	14256043.0
2020-03-23 13:00:00	QQQ	ETF	172.72	174.21	168.7	169.62	12131519.0
2020-03-23 14:00:00	QQQ	ETF	169.65	171.4	168.02	169.12	11335060.0
2020-03-23 15:00:00	QQQ	ETF	169.13	171.78	167.0442	170.61	17761412.0
2020-03-23 16:00:00	QQQ	ETF	170.6	171.53	169.19	170.27	2517729.0
2020-03-23 17:00:00	QQQ	ETF	169.7	172.0	169.7	171.8	619046.0
2020-03-23 18:00:00	QQQ	ETF	171.75	173.71	171.24	172.9	204308.0
2020-03-23 19:00:00	QQQ	ETF	172.9	174.73	172.77	172.78	362964.0
2020-03-23 04:00:00	IWM	ETF	97.71	99.0	97.12	97.66	92489.0
2020-03-23 05:00:00	IWM	ETF	97.66	99.19	97.66	98.89	109125.0
2020-03-23 06:00:00	IWM	ETF	98.64	99.5	98.44	99.4	81796.0
2020-03-23 07:00:00	IWM	ETF	99.25	99.4	98.17	98.68	138611.0
2020-03-23 08:00:00	IWM	ETF	98.2	107.09	98.2	105.82	1243020.0
2020-03-23 09:00:00	IWM	ETF	105.8	106.37	97.46	101.93	6118086.0
2020-03-23 10:00:00	IWM	ETF	101.94	102.18	99.14	99.61	6289111.0
2020-03-23 11:00:00	IWM	ETF	99.62	100.15	95.91	97.52	7306538.0
2020-03-23 12:00:00	IWM	ETF	97.51	101.43	96.62	100.82	5773410.0
2020-03-23 13:00:00	IWM	ETF	100.87	101.5099	98.05	99.08	4461495.0
2020-03-23 14:00:00	IWM	ETF	99.11	101.47	97.94	99.68	5599404.0
2020-03-23 15:00:00	IWM	ETF	99.69	100.93	97.5707	99.83	10648953.0
2020-03-23 16:00:00	IWM	ETF	99.77	101.0	98.6502	100.15	1486011.0
2020-03-23 17:00:00	IWM	ETF	100.01	101.0	99.9	100.85	229539.0
2020-03-23 18:00:00	IWM	ETF	100.8	102.0	99.9	101.18	55275.0
2020-03-23 19:00:00	IWM	ETF	101.33	102.52	101.33	101.57	75449.0
2020-03-23 04:00:00	DIA	ETF	181.19	185.05	181.19	184.41	58665.0
2020-03-23 05:00:00	DIA	ETF	184.65	186.46	184.52	185.92	19211.0

> showing 50 of 14,150 rows — these rows as CSV

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