PREVIEW / etf_1hour / 2019-03-05

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-03-05.parquet
  size:    317 KB
  rows:    10,540

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
2019-03-05 04:00:00	SPY	ETF	279.77	279.94	279.75	279.83	14092.0
2019-03-05 05:00:00	SPY	ETF	279.92	279.92	279.6	279.74	5492.0
2019-03-05 06:00:00	SPY	ETF	279.64	279.67	279.5	279.67	7868.0
2019-03-05 07:00:00	SPY	ETF	279.7	279.74	279.18	279.25	205131.0
2019-03-05 08:00:00	SPY	ETF	279.3301	279.75	279.21	279.35	163454.0
2019-03-05 09:00:00	SPY	ETF	279.35	279.59	278.41	278.72	6766150.0
2019-03-05 10:00:00	SPY	ETF	278.72	279.42	278.55	278.835	8613406.0
2019-03-05 11:00:00	SPY	ETF	278.85	279.68	278.7	279.27	8570501.0
2019-03-05 12:00:00	SPY	ETF	279.27	279.4	279.05	279.3299	3454059.0
2019-03-05 13:00:00	SPY	ETF	279.3285	279.61	278.87	279.16	4704312.0
2019-03-05 14:00:00	SPY	ETF	279.16	279.68	279.1	279.64	3731321.0
2019-03-05 15:00:00	SPY	ETF	279.64	279.76	279.05	279.05	13072940.0
2019-03-05 16:00:00	SPY	ETF	279.05	279.28	278.93	278.95	7080360.0
2019-03-05 17:00:00	SPY	ETF	279.01	279.03	278.66	278.74	299900.0
2019-03-05 18:00:00	SPY	ETF	278.73	278.89	278.59	278.75	139394.0
2019-03-05 19:00:00	SPY	ETF	278.67	278.72	278.51	278.61	77812.0
2019-03-05 04:00:00	QQQ	ETF	174.45	174.78	174.45	174.68	2145.0
2019-03-05 05:00:00	QQQ	ETF	174.65	174.65	174.42	174.52	13950.0
2019-03-05 06:00:00	QQQ	ETF	174.47	174.49	174.35	174.46	14950.0
2019-03-05 07:00:00	QQQ	ETF	174.48	174.48	174.05	174.14	271778.0
2019-03-05 08:00:00	QQQ	ETF	174.47	174.61	174.18	174.36	351125.0
2019-03-05 09:00:00	QQQ	ETF	174.3	174.6199	173.685	174.0	3385287.0
2019-03-05 10:00:00	QQQ	ETF	174.01	174.7	173.94	174.455	3719252.0
2019-03-05 11:00:00	QQQ	ETF	174.475	174.98	174.31	174.69	2517070.0
2019-03-05 12:00:00	QQQ	ETF	174.69	174.8	174.445	174.6234	1172983.0
2019-03-05 13:00:00	QQQ	ETF	174.63	174.86	174.46	174.63	1482404.0
2019-03-05 14:00:00	QQQ	ETF	174.63	175.03	174.59	175.0	1485434.0
2019-03-05 15:00:00	QQQ	ETF	175.01	175.085	174.53	174.53	4943313.0
2019-03-05 16:00:00	QQQ	ETF	174.5358	174.76	174.47	174.55	742820.0
2019-03-05 17:00:00	QQQ	ETF	174.62	174.63	174.42	174.44	79257.0
2019-03-05 18:00:00	QQQ	ETF	174.44	174.5299	174.31	174.43	71979.0
2019-03-05 19:00:00	QQQ	ETF	174.36	174.37	174.24	174.35	45358.0
2019-03-05 04:00:00	IWM	ETF	157.0	157.17	157.0	157.17	2358.0
2019-03-05 06:00:00	IWM	ETF	156.9	156.9	156.9	156.9	1000.0
2019-03-05 07:00:00	IWM	ETF	156.99	156.99	156.86	156.88	9000.0
2019-03-05 08:00:00	IWM	ETF	156.75	156.98	156.75	156.81	25212.0
2019-03-05 09:00:00	IWM	ETF	156.805	156.95	155.96	156.22	1895673.0
2019-03-05 10:00:00	IWM	ETF	156.22	156.7	156.09	156.17	4450809.0
2019-03-05 11:00:00	IWM	ETF	156.19	156.88	156.15	156.64	2021753.0
2019-03-05 12:00:00	IWM	ETF	156.64	156.78	156.3017	156.54	1139792.0
2019-03-05 13:00:00	IWM	ETF	156.55	156.71	156.3221	156.615	907860.0
2019-03-05 14:00:00	IWM	ETF	156.6	156.81	156.58	156.675	899177.0
2019-03-05 15:00:00	IWM	ETF	156.69	156.69	156.05	156.09	3141790.0
2019-03-05 16:00:00	IWM	ETF	156.09	156.27	156.04	156.06	603742.0
2019-03-05 17:00:00	IWM	ETF	156.05	156.07	156.02	156.06	5753.0
2019-03-05 18:00:00	IWM	ETF	156.1	156.1	155.91	155.91	16758.0
2019-03-05 19:00:00	IWM	ETF	155.91	155.92	155.79	155.84	7760.0
2019-03-05 05:00:00	DIA	ETF	258.76	258.76	258.76	258.76	150.0
2019-03-05 07:00:00	DIA	ETF	258.76	258.76	258.12	258.17	2104.0
2019-03-05 08:00:00	DIA	ETF	258.41	258.83	258.37	258.38	8836.0

> showing 50 of 10,540 rows — these rows as CSV

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