PREVIEW / etf_1hour / 2020-01-28

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-01-28.parquet
  size:    362 KB
  rows:    11,864

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-28 04:00:00	SPY	ETF	324.5	324.5	323.85	324.2	38216.0
2020-01-28 05:00:00	SPY	ETF	324.24	324.4	323.95	324.2	14218.0
2020-01-28 06:00:00	SPY	ETF	324.11	324.97	323.56	324.92	65317.0
2020-01-28 07:00:00	SPY	ETF	324.89	325.64	324.65	325.25	383572.0
2020-01-28 08:00:00	SPY	ETF	325.25	325.61	323.5	325.24	675637.0
2020-01-28 09:00:00	SPY	ETF	325.24	325.49	324.55	325.11	6760776.0
2020-01-28 10:00:00	SPY	ETF	325.115	327.0199	325.115	326.86	12278250.0
2020-01-28 11:00:00	SPY	ETF	326.85	327.26	326.44	327.21	5778231.0
2020-01-28 12:00:00	SPY	ETF	327.22	327.46	327.0	327.12	4238071.0
2020-01-28 13:00:00	SPY	ETF	327.11	327.19	326.63	327.09	4607264.0
2020-01-28 14:00:00	SPY	ETF	327.093	327.85	327.09	327.43	7685925.0
2020-01-28 15:00:00	SPY	ETF	327.44	327.69	326.79	326.89	13861657.0
2020-01-28 16:00:00	SPY	ETF	326.89	327.75	323.6038	327.6	5110680.0
2020-01-28 17:00:00	SPY	ETF	327.6	327.81	326.89	327.5	225363.0
2020-01-28 18:00:00	SPY	ETF	327.57	327.6	326.71	326.85	190383.0
2020-01-28 19:00:00	SPY	ETF	326.83	326.9	326.68	326.79	120002.0
2020-01-28 04:00:00	QQQ	ETF	219.05	219.05	218.42	218.93	63957.0
2020-01-28 05:00:00	QQQ	ETF	218.84	219.07	218.73	218.91	41854.0
2020-01-28 06:00:00	QQQ	ETF	218.8	219.47	218.49	219.46	63319.0
2020-01-28 07:00:00	QQQ	ETF	219.44	219.99	219.25	219.76	408267.0
2020-01-28 08:00:00	QQQ	ETF	219.3499	219.95	218.1	219.73	349094.0
2020-01-28 09:00:00	QQQ	ETF	219.7	219.98	219.06	219.47	2932591.0
2020-01-28 10:00:00	QQQ	ETF	219.49	220.95	219.43	220.815	4384527.0
2020-01-28 11:00:00	QQQ	ETF	220.82	221.42	220.52	221.38	2638128.0
2020-01-28 12:00:00	QQQ	ETF	221.39	221.62	221.23	221.321	1519660.0
2020-01-28 13:00:00	QQQ	ETF	221.34	221.58	221.04	221.51	1437035.0
2020-01-28 14:00:00	QQQ	ETF	221.51	221.9	221.51	221.755	1902362.0
2020-01-28 15:00:00	QQQ	ETF	221.75	221.96	221.41	221.43	3802105.0
2020-01-28 16:00:00	QQQ	ETF	221.43	222.34	221.11	222.07	1780224.0
2020-01-28 17:00:00	QQQ	ETF	221.99	222.18	221.45	222.0	91261.0
2020-01-28 18:00:00	QQQ	ETF	222.03	222.08	221.27	221.43	194224.0
2020-01-28 19:00:00	QQQ	ETF	221.48	221.49	221.31	221.43	31135.0
2020-01-28 04:00:00	IWM	ETF	164.01	164.01	163.79	163.9	8650.0
2020-01-28 05:00:00	IWM	ETF	164.08	164.08	163.9	163.9	200.0
2020-01-28 06:00:00	IWM	ETF	164.07	164.18	163.67	164.18	15000.0
2020-01-28 07:00:00	IWM	ETF	164.51	165.0	164.5	164.85	76175.0
2020-01-28 08:00:00	IWM	ETF	164.88	165.0	164.5	164.55	22674.0
2020-01-28 09:00:00	IWM	ETF	164.61	165.2	164.185	164.505	1416894.0
2020-01-28 10:00:00	IWM	ETF	164.53	165.4	164.5	165.05	1866708.0
2020-01-28 11:00:00	IWM	ETF	165.04	165.16	164.74	165.0199	1972114.0
2020-01-28 12:00:00	IWM	ETF	165.0131	165.12	164.71	164.92	754239.0
2020-01-28 13:00:00	IWM	ETF	164.925	164.925	164.57	164.81	1250311.0
2020-01-28 14:00:00	IWM	ETF	164.82	165.1891	164.82	164.86	1055186.0
2020-01-28 15:00:00	IWM	ETF	164.86	165.25	164.81	164.88	2834076.0
2020-01-28 16:00:00	IWM	ETF	164.88	165.19	164.6001	165.1	1113120.0
2020-01-28 17:00:00	IWM	ETF	165.21	165.32	165.08	165.08	1012.0
2020-01-28 18:00:00	IWM	ETF	165.08	165.08	164.68	164.75	30177.0
2020-01-28 19:00:00	IWM	ETF	164.75	164.75	164.62	164.73	14412.0
2020-01-28 04:00:00	DIA	ETF	286.0	286.0	285.96	285.96	376.0
2020-01-28 06:00:00	DIA	ETF	285.96	285.96	285.96	285.96	500.0

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

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