PREVIEW / etf_1hour / 2020-01-24

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-01-24.parquet
  size:    369 KB
  rows:    11,986

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-24 04:00:00	SPY	ETF	332.75	332.92	332.56	332.58	30110.0
2020-01-24 05:00:00	SPY	ETF	332.53	332.66	332.42	332.46	17056.0
2020-01-24 06:00:00	SPY	ETF	332.67	332.74	332.52	332.74	6520.0
2020-01-24 07:00:00	SPY	ETF	332.7	332.75	332.46	332.62	68261.0
2020-01-24 08:00:00	SPY	ETF	332.53	332.94	332.17	332.5	217124.0
2020-01-24 09:00:00	SPY	ETF	332.45	332.62	331.75	332.21	4344695.0
2020-01-24 10:00:00	SPY	ETF	332.22	332.2332	330.83	331.16	8628478.0
2020-01-24 11:00:00	SPY	ETF	331.165	331.545	329.94	329.965	8934056.0
2020-01-24 12:00:00	SPY	ETF	329.96	331.97	328.69	329.7875	12127179.0
2020-01-24 13:00:00	SPY	ETF	329.79	331.7683	328.0301	328.46	10434169.0
2020-01-24 14:00:00	SPY	ETF	328.47	328.63	327.36	328.61	12072184.0
2020-01-24 15:00:00	SPY	ETF	328.61	329.26	327.84	328.75	18938141.0
2020-01-24 16:00:00	SPY	ETF	328.74	331.7683	328.4	328.41	10413040.0
2020-01-24 17:00:00	SPY	ETF	328.39	328.77	328.15	328.31	317937.0
2020-01-24 18:00:00	SPY	ETF	328.29	328.58	328.2	328.4	76663.0
2020-01-24 19:00:00	SPY	ETF	328.37	328.44	328.26	328.26	27283.0
2020-01-24 04:00:00	QQQ	ETF	225.87	225.93	225.79	225.8	7224.0
2020-01-24 05:00:00	QQQ	ETF	225.75	225.8	225.65	225.68	14957.0
2020-01-24 06:00:00	QQQ	ETF	225.75	225.86	225.72	225.86	12084.0
2020-01-24 07:00:00	QQQ	ETF	225.86	225.86	225.62	225.69	107360.0
2020-01-24 08:00:00	QQQ	ETF	225.8099	225.99	225.51	225.6699	92832.0
2020-01-24 09:00:00	QQQ	ETF	225.65	225.88	225.23	225.55	2919706.0
2020-01-24 10:00:00	QQQ	ETF	225.55	225.55	224.56	224.92	3543992.0
2020-01-24 11:00:00	QQQ	ETF	224.93	225.23	224.01	224.02	3224123.0
2020-01-24 12:00:00	QQQ	ETF	224.01	224.04	222.94	223.82	4749700.0
2020-01-24 13:00:00	QQQ	ETF	223.82	223.82	222.25	222.685	3002010.0
2020-01-24 14:00:00	QQQ	ETF	222.67	222.78	221.6701	222.7699	5132618.0
2020-01-24 15:00:00	QQQ	ETF	222.76	223.15	222.06	222.69	6144155.0
2020-01-24 16:00:00	QQQ	ETF	222.68	222.83	222.39	222.39	1199706.0
2020-01-24 17:00:00	QQQ	ETF	222.35	222.52	222.14	222.23	479008.0
2020-01-24 18:00:00	QQQ	ETF	222.26	222.37	222.12	222.14	18648.0
2020-01-24 19:00:00	QQQ	ETF	222.15	222.25	222.05	222.25	12166.0
2020-01-24 04:00:00	IWM	ETF	168.28	168.36	168.04	168.07	12130.0
2020-01-24 05:00:00	IWM	ETF	168.07	168.07	167.95	167.95	1385.0
2020-01-24 06:00:00	IWM	ETF	168.06	168.17	168.06	168.17	5918.0
2020-01-24 07:00:00	IWM	ETF	168.24	168.24	168.16	168.18	10588.0
2020-01-24 08:00:00	IWM	ETF	167.95	168.25	167.82	168.01	30207.0
2020-01-24 09:00:00	IWM	ETF	168.04	168.1	166.96	167.4	1411523.0
2020-01-24 10:00:00	IWM	ETF	167.41	167.41	166.1	166.41	1904586.0
2020-01-24 11:00:00	IWM	ETF	166.412	166.76	165.9	165.94	2103224.0
2020-01-24 12:00:00	IWM	ETF	165.93	165.93	165.1146	165.63	2245342.0
2020-01-24 13:00:00	IWM	ETF	165.64	165.64	164.73	164.93	1617211.0
2020-01-24 14:00:00	IWM	ETF	164.93	165.17	164.23	165.17	2294130.0
2020-01-24 15:00:00	IWM	ETF	165.16	165.45	164.74	165.33	3704622.0
2020-01-24 16:00:00	IWM	ETF	165.39	165.49	165.2	165.3	2546578.0
2020-01-24 17:00:00	IWM	ETF	165.39	165.39	165.22	165.39	52174.0
2020-01-24 18:00:00	IWM	ETF	165.23	165.23	165.23	165.23	1000.0
2020-01-24 19:00:00	IWM	ETF	165.16	165.16	165.05	165.05	6082.0
2020-01-24 04:00:00	DIA	ETF	292.5	292.5	292.5	292.5	100.0
2020-01-24 06:00:00	DIA	ETF	292.34	292.36	292.34	292.36	200.0

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

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