PREVIEW / etf_1hour / 2021-06-10

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-06-10.parquet
  size:    409 KB
  rows:    14,286

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-06-10 04:00:00	SPY	ETF	421.78	421.78	421.12	421.65	14376.0
2021-06-10 05:00:00	SPY	ETF	421.68	421.83	421.55	421.83	10700.0
2021-06-10 06:00:00	SPY	ETF	421.82	422.02	421.7	421.76	18292.0
2021-06-10 07:00:00	SPY	ETF	421.76	421.97	421.0	421.6	143050.0
2021-06-10 08:00:00	SPY	ETF	421.58	422.88	420.5	422.81	1531433.0
2021-06-10 09:00:00	SPY	ETF	422.8	424.52	422.72	424.25	5738288.0
2021-06-10 10:00:00	SPY	ETF	424.25	424.63	421.55	422.465	7931497.0
2021-06-10 11:00:00	SPY	ETF	422.46	423.52	422.13	423.46	4414061.0
2021-06-10 12:00:00	SPY	ETF	423.47	423.92	423.1	423.91	3258079.0
2021-06-10 13:00:00	SPY	ETF	423.9	424.09	423.525	424.08	2880123.0
2021-06-10 14:00:00	SPY	ETF	424.08	424.1	423.38	423.8	2917936.0
2021-06-10 15:00:00	SPY	ETF	423.79	423.83	423.17	423.59	8811835.0
2021-06-10 16:00:00	SPY	ETF	423.58	423.77	423.35	423.6	2007949.0
2021-06-10 17:00:00	SPY	ETF	423.61	423.69	423.5	423.69	73474.0
2021-06-10 18:00:00	SPY	ETF	423.7	423.71	423.56	423.61	51453.0
2021-06-10 19:00:00	SPY	ETF	423.61	423.65	423.45	423.51	18500.0
2021-06-10 04:00:00	QQQ	ETF	336.45	336.45	335.67	336.14	21176.0
2021-06-10 05:00:00	QQQ	ETF	336.23	336.3	335.72	336.0	46252.0
2021-06-10 06:00:00	QQQ	ETF	336.14	336.17	335.7	335.83	32427.0
2021-06-10 07:00:00	QQQ	ETF	335.79	336.32	335.16	335.84	241993.0
2021-06-10 08:00:00	QQQ	ETF	335.83	337.31	334.7	337.15	1288113.0
2021-06-10 09:00:00	QQQ	ETF	337.15	340.45	336.73	339.94	4790876.0
2021-06-10 10:00:00	QQQ	ETF	339.95	340.34	337.09	338.09	6687755.0
2021-06-10 11:00:00	QQQ	ETF	338.09	339.46	337.6399	339.41	3252641.0
2021-06-10 12:00:00	QQQ	ETF	339.43	339.99	339.23	339.98	2080198.0
2021-06-10 13:00:00	QQQ	ETF	339.96	340.33	339.425	340.32	1989559.0
2021-06-10 14:00:00	QQQ	ETF	340.32	340.35	339.75	340.28	1819436.0
2021-06-10 15:00:00	QQQ	ETF	340.28	340.46	339.66	340.36	4499835.0
2021-06-10 16:00:00	QQQ	ETF	340.36	340.74	340.32	340.64	1225276.0
2021-06-10 17:00:00	QQQ	ETF	340.66	340.84	340.35	340.81	54272.0
2021-06-10 18:00:00	QQQ	ETF	340.79	340.8	340.53	340.58	35384.0
2021-06-10 19:00:00	QQQ	ETF	340.59	340.63	340.43	340.53	40683.0
2021-06-10 04:00:00	IWM	ETF	231.13	231.15	230.91	231.12	3310.0
2021-06-10 05:00:00	IWM	ETF	231.13	231.23	231.1	231.23	4100.0
2021-06-10 06:00:00	IWM	ETF	231.25	231.39	231.22	231.3	22772.0
2021-06-10 07:00:00	IWM	ETF	231.3	231.48	230.82	231.28	87387.0
2021-06-10 08:00:00	IWM	ETF	231.31	231.95	230.14	231.88	401177.0
2021-06-10 09:00:00	IWM	ETF	231.84	232.18	230.612	230.85	3559507.0
2021-06-10 10:00:00	IWM	ETF	230.86	231.37	228.8001	229.61	4697898.0
2021-06-10 11:00:00	IWM	ETF	229.61	229.84	228.97	229.39	2021751.0
2021-06-10 12:00:00	IWM	ETF	229.39	229.955	228.71	229.91	1281695.0
2021-06-10 13:00:00	IWM	ETF	229.92	230.41	229.8	230.06	1064292.0
2021-06-10 14:00:00	IWM	ETF	230.06	230.34	229.8	230.11	1072683.0
2021-06-10 15:00:00	IWM	ETF	230.11	230.155	229.1	229.29	3396782.0
2021-06-10 16:00:00	IWM	ETF	229.28	229.48	229.09	229.28	3857341.0
2021-06-10 17:00:00	IWM	ETF	229.21	229.32	229.13	229.32	469511.0
2021-06-10 18:00:00	IWM	ETF	229.32	229.4	229.32	229.39	26192.0
2021-06-10 19:00:00	IWM	ETF	229.4	229.41	229.29	229.29	8118.0
2021-06-10 04:00:00	DIA	ETF	345.02	345.02	345.02	345.02	100.0
2021-06-10 05:00:00	DIA	ETF	345.21	345.25	345.21	345.25	250.0

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

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