PREVIEW / etf_1hour / 2021-03-31

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-03-31.parquet
  size:    413 KB
  rows:    14,417

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-03-31 04:00:00	SPY	ETF	394.22	394.4	393.93	394.4	10000.0
2021-03-31 05:00:00	SPY	ETF	394.27	394.5	394.18	394.35	9110.0
2021-03-31 06:00:00	SPY	ETF	394.4	394.83	394.35	394.75	37226.0
2021-03-31 07:00:00	SPY	ETF	394.73	395.05	394.49	394.95	91188.0
2021-03-31 08:00:00	SPY	ETF	394.5096	395.33	393.96	395.09	218333.0
2021-03-31 09:00:00	SPY	ETF	395.11	396.38	395.02	396.15	5883704.0
2021-03-31 10:00:00	SPY	ETF	396.13	396.98	395.97	396.82	7475736.0
2021-03-31 11:00:00	SPY	ETF	396.81	397.26	396.5	397.13	5473377.0
2021-03-31 12:00:00	SPY	ETF	397.13	397.66	397.125	397.61	4705680.0
2021-03-31 13:00:00	SPY	ETF	397.615	398.0	397.5	397.71	5460603.0
2021-03-31 14:00:00	SPY	ETF	397.71	397.7419	397.09	397.2501	9261402.0
2021-03-31 15:00:00	SPY	ETF	397.24	397.77	396.02	396.25	30048787.0
2021-03-31 16:00:00	SPY	ETF	396.26	397.5002	395.8795	396.22	10657985.0
2021-03-31 17:00:00	SPY	ETF	396.3	396.3	396.06	396.2	88093.0
2021-03-31 18:00:00	SPY	ETF	396.24	396.55	396.24	396.42	64397.0
2021-03-31 19:00:00	SPY	ETF	396.43	396.66	396.2	396.64	46015.0
2021-03-31 04:00:00	QQQ	ETF	314.44	314.7	314.17	314.6	74155.0
2021-03-31 05:00:00	QQQ	ETF	314.64	315.22	314.35	315.15	47597.0
2021-03-31 06:00:00	QQQ	ETF	315.13	316.22	315.12	315.98	68725.0
2021-03-31 07:00:00	QQQ	ETF	315.94	315.97	315.611	315.81	128797.0
2021-03-31 08:00:00	QQQ	ETF	315.91	316.47	313.79	316.05	180587.0
2021-03-31 09:00:00	QQQ	ETF	316.02	318.29	315.81	318.2	6010198.0
2021-03-31 10:00:00	QQQ	ETF	318.19	320.0	318.19	319.5	7390049.0
2021-03-31 11:00:00	QQQ	ETF	319.49	319.9	319.12	319.88	4758562.0
2021-03-31 12:00:00	QQQ	ETF	319.89	320.49	319.865	320.1	2731822.0
2021-03-31 13:00:00	QQQ	ETF	320.1	320.62	319.85	319.96	3431683.0
2021-03-31 14:00:00	QQQ	ETF	319.97	320.1	319.13	319.8	4074661.0
2021-03-31 15:00:00	QQQ	ETF	319.79	320.74	318.61	318.95	11002073.0
2021-03-31 16:00:00	QQQ	ETF	318.95	320.3715	318.8107	319.02	2215195.0
2021-03-31 17:00:00	QQQ	ETF	318.86	319.27	318.72	318.96	154331.0
2021-03-31 18:00:00	QQQ	ETF	318.94	319.52	318.94	319.5	122905.0
2021-03-31 19:00:00	QQQ	ETF	319.48	319.85	319.26	319.83	88019.0
2021-03-31 04:00:00	IWM	ETF	218.01	218.13	217.72	217.72	9100.0
2021-03-31 05:00:00	IWM	ETF	217.9	217.9	217.8	217.81	17800.0
2021-03-31 06:00:00	IWM	ETF	217.94	218.32	217.94	218.25	11337.0
2021-03-31 07:00:00	IWM	ETF	218.39	219.13	218.39	219.01	118351.0
2021-03-31 08:00:00	IWM	ETF	218.4	219.13	218.06	218.82	93552.0
2021-03-31 09:00:00	IWM	ETF	218.83	220.79	218.81	220.375	3439865.0
2021-03-31 10:00:00	IWM	ETF	220.39	220.79	219.77	220.17	4128705.0
2021-03-31 11:00:00	IWM	ETF	220.155	220.725	219.16	219.89	2762429.0
2021-03-31 12:00:00	IWM	ETF	219.9	220.54	219.77	220.42	1580810.0
2021-03-31 13:00:00	IWM	ETF	220.44	221.88	220.16	221.43	2787584.0
2021-03-31 14:00:00	IWM	ETF	221.45	221.91	220.7	221.56	2699628.0
2021-03-31 15:00:00	IWM	ETF	221.55	222.3999	220.75	220.9	7841128.0
2021-03-31 16:00:00	IWM	ETF	220.93	221.07	219.87	220.94	2578258.0
2021-03-31 17:00:00	IWM	ETF	220.57	220.94	220.2	220.36	128621.0
2021-03-31 18:00:00	IWM	ETF	220.31	220.57	220.31	220.56	17549.0
2021-03-31 19:00:00	IWM	ETF	220.49	220.69	220.41	220.69	24770.0
2021-03-31 04:00:00	DIA	ETF	330.1	330.13	329.93	329.93	1200.0
2021-03-31 05:00:00	DIA	ETF	330.15	330.15	330.14	330.14	1100.0

> showing 50 of 14,417 rows — these rows as CSV

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