PREVIEW / etf_1hour / 2021-02-23

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-02-23.parquet
  size:    433 KB
  rows:    15,233

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
2021-02-23 04:00:00	SPY	ETF	387.27	387.27	385.29	385.4	91632.0
2021-02-23 05:00:00	SPY	ETF	385.38	385.57	383.69	384.25	113324.0
2021-02-23 06:00:00	SPY	ETF	384.3	385.5	383.79	385.5	207265.0
2021-02-23 07:00:00	SPY	ETF	385.41	385.69	385.02	385.58	623987.0
2021-02-23 08:00:00	SPY	ETF	385.57	389.0	384.0096	385.14	1072893.0
2021-02-23 09:00:00	SPY	ETF	385.14	385.15	380.2	382.2394	16274209.0
2021-02-23 10:00:00	SPY	ETF	382.23	385.71	381.43	385.24	17723435.0
2021-02-23 11:00:00	SPY	ETF	385.245	386.13	383.79	383.99	9474780.0
2021-02-23 12:00:00	SPY	ETF	383.98	384.62	382.56	382.7799	8162168.0
2021-02-23 13:00:00	SPY	ETF	382.78	385.4699	382.5	385.15	7293006.0
2021-02-23 14:00:00	SPY	ETF	385.14	386.74	384.735	386.7087	7284146.0
2021-02-23 15:00:00	SPY	ETF	386.73	388.945	386.59	387.5	16736847.0
2021-02-23 16:00:00	SPY	ETF	387.51	387.88	386.99	387.31	3126604.0
2021-02-23 17:00:00	SPY	ETF	387.33	387.5	387.11	387.35	163057.0
2021-02-23 18:00:00	SPY	ETF	387.35	387.6	386.35	387.1	353547.0
2021-02-23 19:00:00	SPY	ETF	387.05	387.5	386.6	387.1	126130.0
2021-02-23 04:00:00	QQQ	ETF	321.5	322.0	318.93	319.23	133111.0
2021-02-23 05:00:00	QQQ	ETF	319.22	319.36	315.62	316.43	430682.0
2021-02-23 06:00:00	QQQ	ETF	316.48	317.79	315.86	317.49	358166.0
2021-02-23 07:00:00	QQQ	ETF	317.49	318.11	317.2	317.66	420115.0
2021-02-23 08:00:00	QQQ	ETF	317.67	324.95	316.0804	317.45	827237.0
2021-02-23 09:00:00	QQQ	ETF	317.45	317.51	311.0	314.21	15930415.0
2021-02-23 10:00:00	QQQ	ETF	314.2	319.38	313.64	318.8	16327206.0
2021-02-23 11:00:00	QQQ	ETF	318.79	319.86	316.21	316.39	8009292.0
2021-02-23 12:00:00	QQQ	ETF	316.38	317.335	314.19	314.55	9031535.0
2021-02-23 13:00:00	QQQ	ETF	314.58	318.485	314.18	318.11	6079030.0
2021-02-23 14:00:00	QQQ	ETF	318.06	320.06	317.74	320.06	5251017.0
2021-02-23 15:00:00	QQQ	ETF	320.07	323.2	319.81	321.53	10860519.0
2021-02-23 16:00:00	QQQ	ETF	321.52	321.75	320.6	320.81	1449198.0
2021-02-23 17:00:00	QQQ	ETF	320.79	321.0	320.5	320.95	46787.0
2021-02-23 18:00:00	QQQ	ETF	321.0	321.5	320.28	321.08	183520.0
2021-02-23 19:00:00	QQQ	ETF	321.16	321.5	320.73	321.0	94718.0
2021-02-23 04:00:00	IWM	ETF	224.12	224.12	222.27	222.45	36555.0
2021-02-23 05:00:00	IWM	ETF	222.42	222.43	220.91	221.41	62691.0
2021-02-23 06:00:00	IWM	ETF	221.3	222.4	220.85	222.04	67466.0
2021-02-23 07:00:00	IWM	ETF	222.12	222.25	220.92	221.71	227217.0
2021-02-23 08:00:00	IWM	ETF	221.3896	225.25	220.58	220.96	232290.0
2021-02-23 09:00:00	IWM	ETF	220.79	221.15	215.56	218.3	7848627.0
2021-02-23 10:00:00	IWM	ETF	218.24	221.0808	217.9	220.56	6232717.0
2021-02-23 11:00:00	IWM	ETF	220.54	221.44	218.31	218.72	3527928.0
2021-02-23 12:00:00	IWM	ETF	218.72	219.42	217.83	217.96	2656059.0
2021-02-23 13:00:00	IWM	ETF	217.97	219.95	217.65	219.69	2329053.0
2021-02-23 14:00:00	IWM	ETF	219.69	221.16	219.49	221.04	2360246.0
2021-02-23 15:00:00	IWM	ETF	221.08	222.975	220.86	221.74	5883430.0
2021-02-23 16:00:00	IWM	ETF	221.74	221.98	221.35	221.55	1468737.0
2021-02-23 17:00:00	IWM	ETF	221.32	221.7	221.32	221.65	13989.0
2021-02-23 18:00:00	IWM	ETF	221.73	221.94	220.86	221.55	58472.0
2021-02-23 19:00:00	IWM	ETF	221.76	221.94	221.37	221.91	31703.0
2021-02-23 04:00:00	DIA	ETF	314.99	315.19	314.9	314.9	1690.0
2021-02-23 05:00:00	DIA	ETF	314.76	314.76	314.15	314.52	55395.0

> showing 50 of 15,233 rows — these rows as CSV

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