PREVIEW / etf_1hour / 2020-03-18

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-03-18.parquet
  size:    405 KB
  rows:    14,092

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-18 04:00:00	SPY	ETF	240.5	240.61	238.5	239.44	190845.0
2020-03-18 05:00:00	SPY	ETF	239.54	239.77	238.03	238.75	145694.0
2020-03-18 06:00:00	SPY	ETF	238.75	239.14	235.0	236.01	351358.0
2020-03-18 07:00:00	SPY	ETF	236.2	239.5	235.8	239.17	1265493.0
2020-03-18 08:00:00	SPY	ETF	239.16	243.5	235.5	237.0	2237558.0
2020-03-18 09:00:00	SPY	ETF	237.01	244.38	236.2	242.58	33189338.0
2020-03-18 10:00:00	SPY	ETF	242.61	248.37	240.0	240.26	29720225.0
2020-03-18 11:00:00	SPY	ETF	240.25	241.49	237.08	241.06	39469542.0
2020-03-18 12:00:00	SPY	ETF	241.09	241.26	235.67	235.73	38043457.0
2020-03-18 13:00:00	SPY	ETF	235.0	236.88	230.0	231.88	41334717.0
2020-03-18 14:00:00	SPY	ETF	231.91	235.18	228.02	235.09	43961042.0
2020-03-18 15:00:00	SPY	ETF	235.1	241.87	231.0	241.01	74867323.0
2020-03-18 16:00:00	SPY	ETF	240.97	242.95	233.9196	242.15	16870181.0
2020-03-18 17:00:00	SPY	ETF	242.16	242.1801	240.0	241.51	940794.0
2020-03-18 18:00:00	SPY	ETF	241.6	247.47	238.03	245.37	1607370.0
2020-03-18 19:00:00	SPY	ETF	245.37	247.65	242.6	245.99	1136100.0
2020-03-18 04:00:00	QQQ	ETF	171.31	173.14	171.0	172.97	77075.0
2020-03-18 05:00:00	QQQ	ETF	172.84	172.99	171.64	171.81	25948.0
2020-03-18 06:00:00	QQQ	ETF	171.81	172.5	170.32	170.68	57177.0
2020-03-18 07:00:00	QQQ	ETF	170.68	172.85	170.5	172.7	171501.0
2020-03-18 08:00:00	QQQ	ETF	171.39	175.17	170.51	171.9	417265.0
2020-03-18 09:00:00	QQQ	ETF	171.87	177.61	170.78	176.64	9995653.0
2020-03-18 10:00:00	QQQ	ETF	176.66	179.22	175.22	175.705	10382381.0
2020-03-18 11:00:00	QQQ	ETF	175.66	176.23	172.96	175.805	10496237.0
2020-03-18 12:00:00	QQQ	ETF	175.81	176.11	171.52	171.54	8899748.0
2020-03-18 13:00:00	QQQ	ETF	170.91	172.5	167.51	168.7786	12291852.0
2020-03-18 14:00:00	QQQ	ETF	168.79	172.1816	166.8	172.1599	11537274.0
2020-03-18 15:00:00	QQQ	ETF	172.16	176.63	168.5204	176.42	25769107.0
2020-03-18 16:00:00	QQQ	ETF	176.42	177.72	174.47	177.26	5659016.0
2020-03-18 17:00:00	QQQ	ETF	177.27	177.5	176.61	177.0	300120.0
2020-03-18 18:00:00	QQQ	ETF	176.97	180.52	174.05	179.39	996930.0
2020-03-18 19:00:00	QQQ	ETF	179.4	181.6	177.79	180.39	380236.0
2020-03-18 04:00:00	IWM	ETF	103.55	103.55	102.01	103.0	13442.0
2020-03-18 05:00:00	IWM	ETF	102.5	102.91	102.5	102.63	5232.0
2020-03-18 06:00:00	IWM	ETF	102.5	102.5	101.01	101.01	11332.0
2020-03-18 07:00:00	IWM	ETF	101.45	102.9	101.2	102.89	28225.0
2020-03-18 08:00:00	IWM	ETF	102.08	103.21	101.5	101.85	70877.0
2020-03-18 09:00:00	IWM	ETF	101.56	106.21	101.42	104.44	6883816.0
2020-03-18 10:00:00	IWM	ETF	104.43	106.775	102.45	102.51	6401735.0
2020-03-18 11:00:00	IWM	ETF	102.529	103.51	100.48	103.29	6027908.0
2020-03-18 12:00:00	IWM	ETF	103.24	103.45	99.27	99.49	4667641.0
2020-03-18 13:00:00	IWM	ETF	99.49	100.74	97.01	98.1198	5668226.0
2020-03-18 14:00:00	IWM	ETF	98.11	100.0602	96.25	99.97	6432933.0
2020-03-18 15:00:00	IWM	ETF	99.97	100.99	96.39	100.82	13802401.0
2020-03-18 16:00:00	IWM	ETF	100.82	101.65	98.85	101.22	3509060.0
2020-03-18 17:00:00	IWM	ETF	101.18	101.21	101.0	101.0	19037.0
2020-03-18 18:00:00	IWM	ETF	101.0	102.88	99.77	102.42	731503.0
2020-03-18 19:00:00	IWM	ETF	102.06	103.93	101.14	103.12	63500.0
2020-03-18 04:00:00	DIA	ETF	201.75	201.75	200.8	200.8	300.0
2020-03-18 05:00:00	DIA	ETF	201.0	201.0	200.43	200.43	300.0

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

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