PREVIEW / etf_1hour / 2019-08-07

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-08-07.parquet
  size:    352 KB
  rows:    11,498

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-08-07 04:00:00	SPY	ETF	287.49	288.28	287.46	288.11	29907.0
2019-08-07 05:00:00	SPY	ETF	288.23	288.63	287.96	288.43	25823.0
2019-08-07 06:00:00	SPY	ETF	288.43	288.53	287.94	287.98	73170.0
2019-08-07 07:00:00	SPY	ETF	287.96	288.19	287.27	287.32	459626.0
2019-08-07 08:00:00	SPY	ETF	287.86	288.1499	284.25	284.43	2610970.0
2019-08-07 09:00:00	SPY	ETF	284.38	284.71	282.04	283.421	20239212.0
2019-08-07 10:00:00	SPY	ETF	283.42	286.49	282.91	286.11	22916363.0
2019-08-07 11:00:00	SPY	ETF	286.1	286.38	284.55	284.94	13802958.0
2019-08-07 12:00:00	SPY	ETF	284.975	285.87	284.2	285.82	10355809.0
2019-08-07 13:00:00	SPY	ETF	285.8	287.6	285.67	286.75	11900146.0
2019-08-07 14:00:00	SPY	ETF	286.76	288.14	286.3	288.1	12275527.0
2019-08-07 15:00:00	SPY	ETF	288.11	288.82	287.26	288.03	20576324.0
2019-08-07 16:00:00	SPY	ETF	288.01	288.34	287.55	287.7	23005205.0
2019-08-07 17:00:00	SPY	ETF	287.7	287.981	287.45	287.54	376753.0
2019-08-07 18:00:00	SPY	ETF	287.54	288.01	287.31	287.97	313112.0
2019-08-07 19:00:00	SPY	ETF	287.95	288.22	287.06	287.16	136733.0
2019-08-07 04:00:00	QQQ	ETF	183.48	184.06	183.48	183.91	105474.0
2019-08-07 05:00:00	QQQ	ETF	183.95	184.32	183.79	184.21	38426.0
2019-08-07 06:00:00	QQQ	ETF	184.21	184.26	183.7	183.74	38144.0
2019-08-07 07:00:00	QQQ	ETF	183.83	184.0	183.25	183.3	307146.0
2019-08-07 08:00:00	QQQ	ETF	183.91	183.98	181.0	181.0801	836839.0
2019-08-07 09:00:00	QQQ	ETF	181.13	181.71	179.89	181.02	7874466.0
2019-08-07 10:00:00	QQQ	ETF	181.02	183.43	180.69	183.12	8067775.0
2019-08-07 11:00:00	QQQ	ETF	183.1	183.27	181.85	182.09	5047540.0
2019-08-07 12:00:00	QQQ	ETF	182.1	182.6	181.371	182.38	3200453.0
2019-08-07 13:00:00	QQQ	ETF	182.39	183.86	182.27	183.27	3358994.0
2019-08-07 14:00:00	QQQ	ETF	183.275	184.15	182.88	184.1	3907091.0
2019-08-07 15:00:00	QQQ	ETF	184.11	184.51	183.43	184.06	5955348.0
2019-08-07 16:00:00	QQQ	ETF	184.05	184.28	183.75	183.86	1298499.0
2019-08-07 17:00:00	QQQ	ETF	183.9	184.04	183.8	183.85	39147.0
2019-08-07 18:00:00	QQQ	ETF	183.85	184.16	183.6	184.16	82235.0
2019-08-07 19:00:00	QQQ	ETF	184.17	184.34	183.53	183.59	87723.0
2019-08-07 04:00:00	IWM	ETF	149.65	149.66	149.65	149.66	2193.0
2019-08-07 05:00:00	IWM	ETF	149.64	149.7	149.55	149.7	9000.0
2019-08-07 06:00:00	IWM	ETF	149.95	149.95	149.61	149.61	6000.0
2019-08-07 07:00:00	IWM	ETF	149.61	149.69	149.25	149.25	29435.0
2019-08-07 08:00:00	IWM	ETF	149.74	149.74	147.71	147.79	220203.0
2019-08-07 09:00:00	IWM	ETF	147.88	148.13	146.69	147.08	4422191.0
2019-08-07 10:00:00	IWM	ETF	147.07	148.5311	146.74	148.34	4167835.0
2019-08-07 11:00:00	IWM	ETF	148.3	148.685	147.72	148.0	2388938.0
2019-08-07 12:00:00	IWM	ETF	148.0	148.62	147.69	148.44	1284567.0
2019-08-07 13:00:00	IWM	ETF	148.45	149.2	148.29	148.86	1980186.0
2019-08-07 14:00:00	IWM	ETF	148.85	149.49	148.56	149.46	1799678.0
2019-08-07 15:00:00	IWM	ETF	149.46	149.71	148.6824	149.32	4459220.0
2019-08-07 16:00:00	IWM	ETF	149.31	149.65	148.91	149.06	1027807.0
2019-08-07 17:00:00	IWM	ETF	149.02	149.19	149.02	149.05	1082.0
2019-08-07 18:00:00	IWM	ETF	149.05	149.2	148.81	149.16	18185.0
2019-08-07 19:00:00	IWM	ETF	149.17	149.26	148.71	148.72	19934.0
2019-08-07 04:00:00	DIA	ETF	260.29	260.29	260.29	260.29	1200.0
2019-08-07 05:00:00	DIA	ETF	260.4	260.8	260.4	260.71	1650.0

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

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