PREVIEW / etf_1hour / 2021-03-18

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-03-18.parquet
  size:    422 KB
  rows:    14,661

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-18 04:00:00	SPY	ETF	396.09	398.0	394.9	395.12	157442.0
2021-03-18 05:00:00	SPY	ETF	395.05	395.74	395.04	395.41	62551.0
2021-03-18 06:00:00	SPY	ETF	395.29	396.09	395.29	395.65	144883.0
2021-03-18 07:00:00	SPY	ETF	395.7	395.84	394.15	394.59	552967.0
2021-03-18 08:00:00	SPY	ETF	395.3801	398.253	394.17	394.67	618179.0
2021-03-18 09:00:00	SPY	ETF	394.65	395.41	394.02	395.22	8363872.0
2021-03-18 10:00:00	SPY	ETF	395.21	395.58	394.18	395.2	9843372.0
2021-03-18 11:00:00	SPY	ETF	395.2	395.97	395.1	395.94	6321912.0
2021-03-18 12:00:00	SPY	ETF	395.935	396.72	394.42	394.665	5917744.0
2021-03-18 13:00:00	SPY	ETF	394.66	396.13	394.62	396.03	4722564.0
2021-03-18 14:00:00	SPY	ETF	396.03	396.085	392.205	393.34	13674535.0
2021-03-18 15:00:00	SPY	ETF	393.345	393.5896	390.75	391.41	25214405.0
2021-03-18 16:00:00	SPY	ETF	391.41	392.5	391.2947	391.86	7103502.0
2021-03-18 17:00:00	SPY	ETF	391.9899	392.22	391.48	392.08	684778.0
2021-03-18 18:00:00	SPY	ETF	392.06	392.45	391.48	391.52	163513.0
2021-03-18 19:00:00	SPY	ETF	391.51	392.07	391.46	391.86	103265.0
2021-03-18 04:00:00	QQQ	ETF	321.33	321.33	317.49	317.5	231000.0
2021-03-18 05:00:00	QQQ	ETF	317.56	318.66	317.39	318.13	116479.0
2021-03-18 06:00:00	QQQ	ETF	318.08	318.78	317.93	318.28	149077.0
2021-03-18 07:00:00	QQQ	ETF	318.32	318.46	316.16	316.73	1264662.0
2021-03-18 08:00:00	QQQ	ETF	316.7	323.32	316.2	316.621	883290.0
2021-03-18 09:00:00	QQQ	ETF	316.63	317.8801	315.74	317.26	8276148.0
2021-03-18 10:00:00	QQQ	ETF	317.23	317.24	315.31	316.56	8260743.0
2021-03-18 11:00:00	QQQ	ETF	316.56	317.09	315.65	316.252	5868220.0
2021-03-18 12:00:00	QQQ	ETF	316.25	317.59	314.87	314.96	6108311.0
2021-03-18 13:00:00	QQQ	ETF	314.97	316.85	314.9082	316.6899	4674805.0
2021-03-18 14:00:00	QQQ	ETF	316.68	316.77	313.055	313.63	10728122.0
2021-03-18 15:00:00	QQQ	ETF	313.61	313.975	311.57	312.01	15205201.0
2021-03-18 16:00:00	QQQ	ETF	312.01	313.07	311.8096	312.27	2008097.0
2021-03-18 17:00:00	QQQ	ETF	312.49	312.87	311.89	312.8	486450.0
2021-03-18 18:00:00	QQQ	ETF	312.5	313.01	312.08	312.11	239592.0
2021-03-18 19:00:00	QQQ	ETF	312.09	312.35	311.84	312.1	100700.0
2021-03-18 04:00:00	IWM	ETF	231.35	231.35	230.58	230.85	16555.0
2021-03-18 05:00:00	IWM	ETF	230.84	231.31	230.74	230.91	9571.0
2021-03-18 06:00:00	IWM	ETF	230.96	231.82	230.96	231.82	13692.0
2021-03-18 07:00:00	IWM	ETF	231.58	231.58	229.93	230.01	115992.0
2021-03-18 08:00:00	IWM	ETF	231.1201	232.84	229.91	230.6099	119192.0
2021-03-18 09:00:00	IWM	ETF	230.64	231.1	229.42	230.535	2255675.0
2021-03-18 10:00:00	IWM	ETF	230.51	231.65	229.69	231.38	2706448.0
2021-03-18 11:00:00	IWM	ETF	231.4	232.63	231.23	232.36	2394690.0
2021-03-18 12:00:00	IWM	ETF	232.36	232.93	230.42	230.62	2105249.0
2021-03-18 13:00:00	IWM	ETF	230.63	231.79	230.55	231.35	1113335.0
2021-03-18 14:00:00	IWM	ETF	231.35	231.41	227.64	228.58	3261485.0
2021-03-18 15:00:00	IWM	ETF	228.55	228.56	224.61	225.3	10261959.0
2021-03-18 16:00:00	IWM	ETF	225.24	226.18	225.05	225.6	1549684.0
2021-03-18 17:00:00	IWM	ETF	225.66	225.88	225.24	225.24	56143.0
2021-03-18 18:00:00	IWM	ETF	225.76	226.08	225.24	225.48	48743.0
2021-03-18 19:00:00	IWM	ETF	225.48	225.98	225.42	225.85	55940.0
2021-03-18 04:00:00	DIA	ETF	331.1	331.25	330.55	330.55	3700.0
2021-03-18 05:00:00	DIA	ETF	330.66	331.13	330.66	331.01	6600.0

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

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