PREVIEW / etf_1hour / 2020-12-30

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-12-30.parquet
  size:    399 KB
  rows:    13,713

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-12-30 04:00:00	SPY	ETF	372.72	372.72	372.57	372.71	8257.0
2020-12-30 05:00:00	SPY	ETF	372.7	373.0	372.7	373.0	28506.0
2020-12-30 06:00:00	SPY	ETF	372.95	372.98	372.5	372.71	65213.0
2020-12-30 07:00:00	SPY	ETF	372.7	372.77	372.37	372.62	97327.0
2020-12-30 08:00:00	SPY	ETF	372.63	373.01	372.2	372.21	132922.0
2020-12-30 09:00:00	SPY	ETF	372.21	372.879	372.01	372.79	3855673.0
2020-12-30 10:00:00	SPY	ETF	372.79	373.1	372.21	372.6554	6863245.0
2020-12-30 11:00:00	SPY	ETF	372.64	372.79	372.22	372.4799	3983149.0
2020-12-30 12:00:00	SPY	ETF	372.48	372.62	372.12	372.28	2403269.0
2020-12-30 13:00:00	SPY	ETF	372.2801	372.55	372.11	372.24	2395414.0
2020-12-30 14:00:00	SPY	ETF	372.23	372.3	371.67	371.78	3674783.0
2020-12-30 15:00:00	SPY	ETF	371.77	372.44	371.57	371.93	15114334.0
2020-12-30 16:00:00	SPY	ETF	371.92	373.0	371.54	371.9	7523931.0
2020-12-30 17:00:00	SPY	ETF	371.88	372.01	371.86	371.92	48298.0
2020-12-30 18:00:00	SPY	ETF	371.99	372.21	371.93	372.12	55854.0
2020-12-30 19:00:00	SPY	ETF	372.1	372.3	372.1	372.27	27394.0
2020-12-30 04:00:00	QQQ	ETF	313.82	313.94	313.72	313.94	17963.0
2020-12-30 05:00:00	QQQ	ETF	313.97	314.05	313.97	314.01	13767.0
2020-12-30 06:00:00	QQQ	ETF	313.93	313.94	313.65	313.89	13280.0
2020-12-30 07:00:00	QQQ	ETF	313.9	314.03	313.74	313.99	36998.0
2020-12-30 08:00:00	QQQ	ETF	313.98	314.36	313.75	314.19	114589.0
2020-12-30 09:00:00	QQQ	ETF	314.21	314.49	313.04	313.41	2313805.0
2020-12-30 10:00:00	QQQ	ETF	313.41	313.5	312.33	313.12	3179038.0
2020-12-30 11:00:00	QQQ	ETF	313.13	313.56	312.875	313.52	1646554.0
2020-12-30 12:00:00	QQQ	ETF	313.53	313.59	313.02	313.18	843690.0
2020-12-30 13:00:00	QQQ	ETF	313.18	313.61	313.155	313.495	990695.0
2020-12-30 14:00:00	QQQ	ETF	313.49	313.535	312.84	313.04	1074792.0
2020-12-30 15:00:00	QQQ	ETF	313.01	313.28	312.41	312.9	2678614.0
2020-12-30 16:00:00	QQQ	ETF	312.92	313.07	312.68	312.86	759579.0
2020-12-30 17:00:00	QQQ	ETF	312.83	312.97	312.81	312.97	13793.0
2020-12-30 18:00:00	QQQ	ETF	312.97	313.2	312.91	313.09	50203.0
2020-12-30 19:00:00	QQQ	ETF	313.17	313.21	313.08	313.09	23403.0
2020-12-30 04:00:00	IWM	ETF	195.39	195.42	195.2	195.2	8900.0
2020-12-30 05:00:00	IWM	ETF	195.29	195.52	195.29	195.5	15537.0
2020-12-30 06:00:00	IWM	ETF	195.51	195.88	195.27	195.52	24673.0
2020-12-30 07:00:00	IWM	ETF	195.55	195.57	195.29	195.39	59549.0
2020-12-30 08:00:00	IWM	ETF	195.4704	195.5	194.93	194.93	160468.0
2020-12-30 09:00:00	IWM	ETF	195.04	197.24	194.69	196.928	2618539.0
2020-12-30 10:00:00	IWM	ETF	196.94	197.48	196.45	197.06	2181449.0
2020-12-30 11:00:00	IWM	ETF	197.0489	197.22	196.12	196.22	1705597.0
2020-12-30 12:00:00	IWM	ETF	196.22	197.12	196.11	196.795	2066846.0
2020-12-30 13:00:00	IWM	ETF	196.8	197.18	196.63	196.74	1032241.0
2020-12-30 14:00:00	IWM	ETF	196.72	196.87	196.32	196.5022	1152588.0
2020-12-30 15:00:00	IWM	ETF	196.5001	196.86	196.233	196.47	3107721.0
2020-12-30 16:00:00	IWM	ETF	196.41	196.64	196.22	196.37	1745972.0
2020-12-30 17:00:00	IWM	ETF	196.37	196.48	196.22	196.41	393988.0
2020-12-30 18:00:00	IWM	ETF	196.39	196.74	196.35	196.6	15540.0
2020-12-30 19:00:00	IWM	ETF	196.68	196.71	196.64	196.65	5215.0
2020-12-30 04:00:00	DIA	ETF	304.24	304.32	304.24	304.32	5500.0
2020-12-30 05:00:00	DIA	ETF	304.27	304.52	304.27	304.52	1200.0

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

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