PREVIEW / etf_1hour / 2021-04-14

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-04-14.parquet
  size:    413 KB
  rows:    14,489

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-04-14 04:00:00	SPY	ETF	412.94	413.42	412.94	413.36	16188.0
2021-04-14 05:00:00	SPY	ETF	413.36	413.39	413.3	413.39	8073.0
2021-04-14 06:00:00	SPY	ETF	413.17	413.31	412.97	413.03	148968.0
2021-04-14 07:00:00	SPY	ETF	413.03	413.44	413.0	413.38	236362.0
2021-04-14 08:00:00	SPY	ETF	413.2799	413.44	412.65	412.74	148926.0
2021-04-14 09:00:00	SPY	ETF	412.74	413.83	412.55	413.83	5443547.0
2021-04-14 10:00:00	SPY	ETF	413.82	413.96	413.19	413.41	5857335.0
2021-04-14 11:00:00	SPY	ETF	413.4	413.57	412.73	413.415	4115179.0
2021-04-14 12:00:00	SPY	ETF	413.4194	413.57	412.8899	413.445	3125210.0
2021-04-14 13:00:00	SPY	ETF	413.45	413.48	411.83	412.11	3994124.0
2021-04-14 14:00:00	SPY	ETF	412.11	412.59	411.19	411.35	9534236.0
2021-04-14 15:00:00	SPY	ETF	411.33	412.12	410.87	411.49	15438735.0
2021-04-14 16:00:00	SPY	ETF	411.48	411.97	411.45	411.82	2253647.0
2021-04-14 17:00:00	SPY	ETF	411.78	411.95	411.45	411.94	62251.0
2021-04-14 18:00:00	SPY	ETF	411.9	412.2	411.45	411.96	85937.0
2021-04-14 19:00:00	SPY	ETF	412.02	412.02	411.73	411.82	96277.0
2021-04-14 04:00:00	QQQ	ETF	340.61	341.31	340.6	341.23	61808.0
2021-04-14 05:00:00	QQQ	ETF	341.23	341.42	341.12	341.28	41336.0
2021-04-14 06:00:00	QQQ	ETF	341.23	341.27	341.1	341.25	53578.0
2021-04-14 07:00:00	QQQ	ETF	341.22	341.95	341.22	341.85	146017.0
2021-04-14 08:00:00	QQQ	ETF	341.22	341.96	340.36	341.38	205916.0
2021-04-14 09:00:00	QQQ	ETF	341.32	341.38	339.87	340.63	4004579.0
2021-04-14 10:00:00	QQQ	ETF	340.62	340.63	339.11	339.2	5296919.0
2021-04-14 11:00:00	QQQ	ETF	339.19	339.54	337.7	338.97	4675128.0
2021-04-14 12:00:00	QQQ	ETF	338.965	339.23	338.11	339.08	2301641.0
2021-04-14 13:00:00	QQQ	ETF	339.1	339.11	336.9	337.11	2599654.0
2021-04-14 14:00:00	QQQ	ETF	337.09	337.81	335.96	336.53	6035729.0
2021-04-14 15:00:00	QQQ	ETF	336.51	337.24	335.67	336.49	9756917.0
2021-04-14 16:00:00	QQQ	ETF	336.5	337.0	336.48	336.99	739879.0
2021-04-14 17:00:00	QQQ	ETF	337.0	337.12	336.51	337.04	64788.0
2021-04-14 18:00:00	QQQ	ETF	336.98	337.2	336.75	336.9	75913.0
2021-04-14 19:00:00	QQQ	ETF	336.92	336.94	336.44	336.6	70416.0
2021-04-14 04:00:00	IWM	ETF	221.66	222.07	221.66	221.99	10300.0
2021-04-14 05:00:00	IWM	ETF	221.7	221.7	221.44	221.44	3749.0
2021-04-14 06:00:00	IWM	ETF	221.37	221.66	221.12	221.23	134327.0
2021-04-14 07:00:00	IWM	ETF	221.27	221.86	221.27	221.8	50397.0
2021-04-14 08:00:00	IWM	ETF	221.4399	221.98	221.2096	221.39	71021.0
2021-04-14 09:00:00	IWM	ETF	221.39	225.18	221.37	225.08	4663007.0
2021-04-14 10:00:00	IWM	ETF	225.071	226.0	224.4901	225.64	3727462.0
2021-04-14 11:00:00	IWM	ETF	225.66	225.91	224.96	225.43	1743761.0
2021-04-14 12:00:00	IWM	ETF	225.42	225.54	224.63	225.0811	1522863.0
2021-04-14 13:00:00	IWM	ETF	225.1	225.37	223.744	223.91	1348038.0
2021-04-14 14:00:00	IWM	ETF	223.92	224.66	223.13	223.23	3053864.0
2021-04-14 15:00:00	IWM	ETF	223.21	223.91	222.4	223.33	4591737.0
2021-04-14 16:00:00	IWM	ETF	223.32	223.85	223.1	223.1	1151009.0
2021-04-14 17:00:00	IWM	ETF	223.42	223.62	223.32	223.54	403850.0
2021-04-14 18:00:00	IWM	ETF	223.55	224.1	223.55	223.79	42222.0
2021-04-14 19:00:00	IWM	ETF	223.87	223.87	223.6	223.62	10513.0
2021-04-14 04:00:00	DIA	ETF	336.84	336.88	336.81	336.81	5300.0
2021-04-14 06:00:00	DIA	ETF	336.8	336.84	336.75	336.84	4218.0

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

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