PREVIEW / etf_1hour / 2020-01-23

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-01-23.parquet
  size:    366 KB
  rows:    11,939

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-01-23 04:00:00	SPY	ETF	331.05	331.21	330.98	331.12	31753.0
2020-01-23 05:00:00	SPY	ETF	331.09	331.36	331.09	331.3	44840.0
2020-01-23 06:00:00	SPY	ETF	331.31	331.38	331.12	331.25	44352.0
2020-01-23 07:00:00	SPY	ETF	331.25	331.35	330.7	330.8	220340.0
2020-01-23 08:00:00	SPY	ETF	331.3501	331.36	330.52	330.66	648061.0
2020-01-23 09:00:00	SPY	ETF	330.65	330.83	329.41	330.31	7448710.0
2020-01-23 10:00:00	SPY	ETF	330.31	330.83	330.08	330.29	5930599.0
2020-01-23 11:00:00	SPY	ETF	330.27	330.39	329.61	330.169	4205411.0
2020-01-23 12:00:00	SPY	ETF	330.16	330.675	330.01	330.32	2897139.0
2020-01-23 13:00:00	SPY	ETF	330.3101	331.21	330.21	331.1979	4618842.0
2020-01-23 14:00:00	SPY	ETF	331.2	331.7052	331.14	331.69	6438507.0
2020-01-23 15:00:00	SPY	ETF	331.69	331.92	331.44	331.74	10463829.0
2020-01-23 16:00:00	SPY	ETF	331.76	331.93	331.3837	331.86	7972903.0
2020-01-23 17:00:00	SPY	ETF	331.84	331.87	330.7896	331.87	72528.0
2020-01-23 18:00:00	SPY	ETF	331.86	332.37	331.8	332.25	95812.0
2020-01-23 19:00:00	SPY	ETF	332.21	332.28	331.95	331.97	34996.0
2020-01-23 04:00:00	QQQ	ETF	223.7	223.83	223.66	223.75	15320.0
2020-01-23 05:00:00	QQQ	ETF	223.75	224.04	223.75	224.04	18620.0
2020-01-23 06:00:00	QQQ	ETF	224.03	224.04	223.86	223.94	13600.0
2020-01-23 07:00:00	QQQ	ETF	223.96	224.13	223.7	223.77	98415.0
2020-01-23 08:00:00	QQQ	ETF	224.09	224.1	223.29	223.64	184752.0
2020-01-23 09:00:00	QQQ	ETF	223.69	223.9	222.7	223.61	4226448.0
2020-01-23 10:00:00	QQQ	ETF	223.6199	224.22	223.47	223.61	3161919.0
2020-01-23 11:00:00	QQQ	ETF	223.62	223.775	223.2812	223.68	2109472.0
2020-01-23 12:00:00	QQQ	ETF	223.68	224.015	223.53	223.62	1285569.0
2020-01-23 13:00:00	QQQ	ETF	223.62	224.195	223.51	224.15	1261103.0
2020-01-23 14:00:00	QQQ	ETF	224.15	224.5	224.09	224.4959	1424782.0
2020-01-23 15:00:00	QQQ	ETF	224.49	224.69	224.27	224.53	2750762.0
2020-01-23 16:00:00	QQQ	ETF	224.54	225.14	223.668	225.14	2309598.0
2020-01-23 17:00:00	QQQ	ETF	225.09	225.15	224.59	225.1	45841.0
2020-01-23 18:00:00	QQQ	ETF	225.12	225.56	225.12	225.53	87919.0
2020-01-23 19:00:00	QQQ	ETF	225.55	225.55	225.34	225.34	56342.0
2020-01-23 04:00:00	IWM	ETF	167.22	167.39	167.22	167.39	7801.0
2020-01-23 05:00:00	IWM	ETF	167.36	167.44	167.36	167.43	6300.0
2020-01-23 06:00:00	IWM	ETF	167.56	167.56	167.46	167.53	2645.0
2020-01-23 07:00:00	IWM	ETF	167.52	167.52	167.25	167.34	7550.0
2020-01-23 08:00:00	IWM	ETF	167.4901	167.51	167.01	167.01	130385.0
2020-01-23 09:00:00	IWM	ETF	167.1	167.31	165.45	166.57	3121516.0
2020-01-23 10:00:00	IWM	ETF	166.57	166.97	166.25	166.72	1997519.0
2020-01-23 11:00:00	IWM	ETF	166.71	166.92	166.26	166.83	1047491.0
2020-01-23 12:00:00	IWM	ETF	166.82	167.018	166.63	166.84	789444.0
2020-01-23 13:00:00	IWM	ETF	166.85	167.43	166.79	167.43	759154.0
2020-01-23 14:00:00	IWM	ETF	167.43	167.955	167.4	167.9431	1302445.0
2020-01-23 15:00:00	IWM	ETF	167.94	167.965	167.49	167.52	3035896.0
2020-01-23 16:00:00	IWM	ETF	167.52	167.61	167.4	167.47	1423742.0
2020-01-23 17:00:00	IWM	ETF	167.45	167.5	167.45	167.5	1500.0
2020-01-23 18:00:00	IWM	ETF	167.53	167.7	167.53	167.69	19000.0
2020-01-23 19:00:00	IWM	ETF	167.6	167.6	167.5	167.57	3700.0
2020-01-23 04:00:00	DIA	ETF	291.36	291.44	291.36	291.44	555.0
2020-01-23 05:00:00	DIA	ETF	291.44	291.66	291.44	291.66	769.0

> showing 50 of 11,939 rows — these rows as CSV

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