PREVIEW / etf_1hour / 2020-09-03

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-09-03.parquet
  size:    399 KB
  rows:    13,723

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-09-03 04:00:00	SPY	ETF	358.08	358.36	357.55	357.71	90216.0
2020-09-03 05:00:00	SPY	ETF	357.56	357.6	356.61	356.61	60360.0
2020-09-03 06:00:00	SPY	ETF	356.68	356.93	356.3	356.42	269160.0
2020-09-03 07:00:00	SPY	ETF	356.35	356.75	356.14	356.55	420261.0
2020-09-03 08:00:00	SPY	ETF	356.59	357.93	355.99	356.29	834095.0
2020-09-03 09:00:00	SPY	ETF	356.25	358.056	355.16	355.8	7646541.0
2020-09-03 10:00:00	SPY	ETF	355.77	355.92	350.3507	351.325	18732959.0
2020-09-03 11:00:00	SPY	ETF	351.33	351.48	345.201	348.05	29929290.0
2020-09-03 12:00:00	SPY	ETF	348.06	348.85	345.49	345.66	13421800.0
2020-09-03 13:00:00	SPY	ETF	345.65	346.98	344.26	345.58	15257487.0
2020-09-03 14:00:00	SPY	ETF	345.59	347.6	343.97	344.0	13582491.0
2020-09-03 15:00:00	SPY	ETF	344.0	345.92	342.59	345.41	32151701.0
2020-09-03 16:00:00	SPY	ETF	345.42	346.85	345.39	346.34	11301318.0
2020-09-03 17:00:00	SPY	ETF	346.28	346.37	345.3	345.35	1912125.0
2020-09-03 18:00:00	SPY	ETF	345.53	345.86	343.71	343.81	451131.0
2020-09-03 19:00:00	SPY	ETF	343.83	344.06	342.82	343.27	228905.0
2020-09-03 04:00:00	QQQ	ETF	302.12	302.3	301.45	301.66	77413.0
2020-09-03 05:00:00	QQQ	ETF	301.64	301.64	299.9	299.96	68691.0
2020-09-03 06:00:00	QQQ	ETF	299.99	300.6	299.62	299.72	84084.0
2020-09-03 07:00:00	QQQ	ETF	299.75	300.28	299.24	299.4	532590.0
2020-09-03 08:00:00	QQQ	ETF	299.48	302.16	298.95	299.27	469409.0
2020-09-03 09:00:00	QQQ	ETF	299.27	299.27	296.0	297.08	8032433.0
2020-09-03 10:00:00	QQQ	ETF	297.06	297.79	290.08	292.35	15540232.0
2020-09-03 11:00:00	QQQ	ETF	292.34	292.49	286.49	289.58	16005546.0
2020-09-03 12:00:00	QQQ	ETF	289.55	290.39	287.05	287.4	7238394.0
2020-09-03 13:00:00	QQQ	ETF	287.4	289.2199	286.01	287.53	7575675.0
2020-09-03 14:00:00	QQQ	ETF	287.5	288.85	285.86	285.92	6144791.0
2020-09-03 15:00:00	QQQ	ETF	285.92	287.72	284.41	287.21	17490491.0
2020-09-03 16:00:00	QQQ	ETF	287.18	288.54	287.1362	287.9	4848268.0
2020-09-03 17:00:00	QQQ	ETF	287.75	287.96	285.73	285.79	234607.0
2020-09-03 18:00:00	QQQ	ETF	285.82	287.9	283.71	283.83	784439.0
2020-09-03 19:00:00	QQQ	ETF	283.8299	284.12	282.61	283.02	393122.0
2020-09-03 04:00:00	IWM	ETF	158.84	158.84	158.65	158.65	2209.0
2020-09-03 05:00:00	IWM	ETF	158.57	158.61	158.41	158.61	3400.0
2020-09-03 06:00:00	IWM	ETF	158.62	158.72	158.45	158.45	8726.0
2020-09-03 07:00:00	IWM	ETF	158.43	158.52	158.12	158.39	57862.0
2020-09-03 08:00:00	IWM	ETF	158.35	158.81	158.13	158.35	91447.0
2020-09-03 09:00:00	IWM	ETF	158.36	158.39	157.5	157.98	2400259.0
2020-09-03 10:00:00	IWM	ETF	157.97	157.99	155.435	155.75	5803296.0
2020-09-03 11:00:00	IWM	ETF	155.74	155.84	152.96	154.76	5288872.0
2020-09-03 12:00:00	IWM	ETF	154.73	155.23	154.04	154.1	2520436.0
2020-09-03 13:00:00	IWM	ETF	154.11	154.68	153.6	154.1	2095126.0
2020-09-03 14:00:00	IWM	ETF	154.1	154.96	153.86	153.86	2245766.0
2020-09-03 15:00:00	IWM	ETF	153.87	154.105	153.1	153.81	5424284.0
2020-09-03 16:00:00	IWM	ETF	153.8	154.55	153.73	154.37	1726154.0
2020-09-03 17:00:00	IWM	ETF	154.37	154.42	154.0	154.22	65818.0
2020-09-03 18:00:00	IWM	ETF	154.22	154.37	153.84	153.84	44364.0
2020-09-03 19:00:00	IWM	ETF	153.87	153.99	153.58	153.81	55320.0
2020-09-03 04:00:00	DIA	ETF	292.07	292.07	292.07	292.07	150.0
2020-09-03 05:00:00	DIA	ETF	291.3	291.3	291.22	291.22	800.0

> showing 50 of 13,723 rows — these rows as CSV

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