PREVIEW / etf_1hour / 2020-02-26

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-02-26.parquet
  size:    394 KB
  rows:    13,063

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-02-26 04:00:00	SPY	ETF	311.76	312.15	309.08	311.32	423539.0
2020-02-26 05:00:00	SPY	ETF	311.55	313.16	311.38	311.78	157384.0
2020-02-26 06:00:00	SPY	ETF	311.82	314.36	311.82	313.4	255934.0
2020-02-26 07:00:00	SPY	ETF	313.38	314.17	312.16	313.72	1132092.0
2020-02-26 08:00:00	SPY	ETF	314.1033	315.9	311.54	313.99	1953691.0
2020-02-26 09:00:00	SPY	ETF	313.98	317.45	313.84	315.5248	21967466.0
2020-02-26 10:00:00	SPY	ETF	315.51	318.11	314.65	317.17	23178178.0
2020-02-26 11:00:00	SPY	ETF	317.16	317.74	315.12	315.41	14332014.0
2020-02-26 12:00:00	SPY	ETF	315.42	315.61	312.69	314.34	24669292.0
2020-02-26 13:00:00	SPY	ETF	314.33	314.78	310.7	311.1	29383472.0
2020-02-26 14:00:00	SPY	ETF	311.09	313.13	310.74	311.41	23507235.0
2020-02-26 15:00:00	SPY	ETF	311.41	313.46	311.41	311.55	33302432.0
2020-02-26 16:00:00	SPY	ETF	311.56	311.72	309.82	309.99	14335234.0
2020-02-26 17:00:00	SPY	ETF	309.95	310.4	309.92	310.23	638024.0
2020-02-26 18:00:00	SPY	ETF	310.15	311.64	309.3	310.28	1098248.0
2020-02-26 19:00:00	SPY	ETF	310.28	310.7	307.88	309.32	813192.0
2020-02-26 04:00:00	QQQ	ETF	214.58	214.82	212.39	214.13	251604.0
2020-02-26 05:00:00	QQQ	ETF	214.25	215.69	214.25	214.66	194539.0
2020-02-26 06:00:00	QQQ	ETF	214.61	216.97	214.6	216.0	287862.0
2020-02-26 07:00:00	QQQ	ETF	215.95	216.64	214.94	216.05	733164.0
2020-02-26 08:00:00	QQQ	ETF	215.97	217.61	214.5	216.6298	1014787.0
2020-02-26 09:00:00	QQQ	ETF	216.62	219.74	216.36	218.265	11244563.0
2020-02-26 10:00:00	QQQ	ETF	218.24	220.28	217.55	219.57	11646753.0
2020-02-26 11:00:00	QQQ	ETF	219.57	220.01	218.14	218.38	6406785.0
2020-02-26 12:00:00	QQQ	ETF	218.38	218.55	216.12	217.67	8333108.0
2020-02-26 13:00:00	QQQ	ETF	217.69	218.04	214.9	215.52	9513429.0
2020-02-26 14:00:00	QQQ	ETF	215.51	217.04	215.25	216.0	7076392.0
2020-02-26 15:00:00	QQQ	ETF	216.02	217.65	215.99	216.43	9060761.0
2020-02-26 16:00:00	QQQ	ETF	216.43	217.1751	214.78	215.01	3642128.0
2020-02-26 17:00:00	QQQ	ETF	215.01	215.15	214.81	215.0	101426.0
2020-02-26 18:00:00	QQQ	ETF	214.85	216.4	214.23	215.22	461768.0
2020-02-26 19:00:00	QQQ	ETF	215.29	215.75	213.23	214.75	489426.0
2020-02-26 04:00:00	IWM	ETF	156.0	156.37	155.0	156.37	31400.0
2020-02-26 05:00:00	IWM	ETF	156.45	156.81	156.3	156.3	8912.0
2020-02-26 06:00:00	IWM	ETF	156.58	157.52	156.58	157.52	12185.0
2020-02-26 07:00:00	IWM	ETF	157.01	157.35	156.31	157.17	180445.0
2020-02-26 08:00:00	IWM	ETF	157.06	157.77	156.75	157.3	166636.0
2020-02-26 09:00:00	IWM	ETF	157.33	158.49	156.75	157.25	4338585.0
2020-02-26 10:00:00	IWM	ETF	157.23	158.35	156.7	157.81	5425310.0
2020-02-26 11:00:00	IWM	ETF	157.8	158.23	156.89	156.98	2348738.0
2020-02-26 12:00:00	IWM	ETF	157.0	157.09	155.59	156.24	4565612.0
2020-02-26 13:00:00	IWM	ETF	156.25	156.47	154.25	154.48	4909325.0
2020-02-26 14:00:00	IWM	ETF	154.44	155.32	154.215	154.29	3558121.0
2020-02-26 15:00:00	IWM	ETF	154.29	155.22	154.25	154.58	6040740.0
2020-02-26 16:00:00	IWM	ETF	154.59	156.4465	153.91	153.92	1868196.0
2020-02-26 17:00:00	IWM	ETF	154.2	154.24	153.81	154.2	2232.0
2020-02-26 18:00:00	IWM	ETF	153.9	154.66	153.5	153.73	117519.0
2020-02-26 19:00:00	IWM	ETF	153.97	154.19	153.0	153.5	17868.0
2020-02-26 04:00:00	DIA	ETF	268.99	270.04	267.18	269.28	8391.0
2020-02-26 05:00:00	DIA	ETF	270.22	270.74	269.36	269.57	4410.0

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

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