PREVIEW / etf_30min / 2022-09-14

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-09-14.parquet
  size:    648 KB
  rows:    26,016

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
2022-09-14 04:00:00	SPY	ETF	394.71	395.32	394.59	394.96	29663.0
2022-09-14 04:30:00	SPY	ETF	395.26	395.99	395.15	395.63	66491.0
2022-09-14 05:00:00	SPY	ETF	395.66	395.68	395.1	395.66	25319.0
2022-09-14 05:30:00	SPY	ETF	395.7	395.72	394.78	394.9	52325.0
2022-09-14 06:00:00	SPY	ETF	395.0	395.46	394.97	395.21	143456.0
2022-09-14 06:30:00	SPY	ETF	395.2	395.21	394.48	394.81	45972.0
2022-09-14 07:00:00	SPY	ETF	394.77	394.85	393.74	393.82	56787.0
2022-09-14 07:30:00	SPY	ETF	393.72	394.02	392.41	392.48	269688.0
2022-09-14 08:00:00	SPY	ETF	394.79	395.92	392.38	393.9	495528.0
2022-09-14 08:30:00	SPY	ETF	394.01	394.77	393.1	394.21	563849.0
2022-09-14 09:00:00	SPY	ETF	394.13	394.53	393.88	394.47	311725.0
2022-09-14 09:30:00	SPY	ETF	394.46	395.61	393.02	395.11	5982202.0
2022-09-14 10:00:00	SPY	ETF	395.11	395.16	391.96	391.99	4179271.0
2022-09-14 10:30:00	SPY	ETF	392.0	395.69	391.76	395.49	4438625.0
2022-09-14 11:00:00	SPY	ETF	395.47	396.2	394.5021	394.54	3434890.0
2022-09-14 11:30:00	SPY	ETF	394.54	395.48	394.27	394.66	2139388.0
2022-09-14 12:00:00	SPY	ETF	394.67	394.96	394.0199	394.42	1938285.0
2022-09-14 12:30:00	SPY	ETF	394.42	395.7	394.09	395.2599	2100762.0
2022-09-14 13:00:00	SPY	ETF	395.27	395.73	394.69	394.97	1803208.0
2022-09-14 13:30:00	SPY	ETF	394.98	395.1599	392.74	393.11	3096224.0
2022-09-14 14:00:00	SPY	ETF	393.13	393.395	392.28	393.125	2807785.0
2022-09-14 14:30:00	SPY	ETF	393.09	393.84	392.405	392.61	3117914.0
2022-09-14 15:00:00	SPY	ETF	392.62	393.38	391.32	392.06	5723470.0
2022-09-14 15:30:00	SPY	ETF	392.05	394.96	391.12	394.61	9498962.0
2022-09-14 16:00:00	SPY	ETF	394.61	395.4	394.4	395.35	2686029.0
2022-09-14 16:30:00	SPY	ETF	395.35	395.63	395.31	395.5	197122.0
2022-09-14 17:00:00	SPY	ETF	395.5	395.65	394.563	395.63	172148.0
2022-09-14 17:30:00	SPY	ETF	395.64	395.69	395.55	395.61	37451.0
2022-09-14 18:00:00	SPY	ETF	395.58	395.6	395.11	395.32	96515.0
2022-09-14 18:30:00	SPY	ETF	395.35	395.85	395.29	395.55	19301.0
2022-09-14 19:00:00	SPY	ETF	395.56	395.56	395.08	395.18	23585.0
2022-09-14 19:30:00	SPY	ETF	395.18	395.4	395.04	395.32	68110.0
2022-09-14 04:00:00	QQQ	ETF	294.67	295.55	294.57	295.09	106256.0
2022-09-14 04:30:00	QQQ	ETF	295.3	296.0	295.28	295.55	51433.0
2022-09-14 05:00:00	QQQ	ETF	295.34	295.65	295.03	295.63	18277.0
2022-09-14 05:30:00	QQQ	ETF	295.63	295.69	294.77	295.1	15787.0
2022-09-14 06:00:00	QQQ	ETF	295.25	295.46	295.11	295.35	22249.0
2022-09-14 06:30:00	QQQ	ETF	295.29	295.29	294.6	294.93	34473.0
2022-09-14 07:00:00	QQQ	ETF	294.86	294.93	293.9	293.95	140188.0
2022-09-14 07:30:00	QQQ	ETF	293.91	294.2	292.73	292.9	321352.0
2022-09-14 08:00:00	QQQ	ETF	294.83	295.9804	292.78	294.01	537775.0
2022-09-14 08:30:00	QQQ	ETF	294.0	295.1	293.42	294.65	1090955.0
2022-09-14 09:00:00	QQQ	ETF	294.64	294.92	294.35	294.87	488202.0
2022-09-14 09:30:00	QQQ	ETF	294.865	295.95	293.16	295.45	7580813.0
2022-09-14 10:00:00	QQQ	ETF	295.46	295.7	293.3	293.32	4363475.0
2022-09-14 10:30:00	QQQ	ETF	293.34	296.29	293.06	296.03	3841945.0
2022-09-14 11:00:00	QQQ	ETF	296.02	296.93	295.36	295.555	2601165.0
2022-09-14 11:30:00	QQQ	ETF	295.57	296.59	295.26	295.8799	1513852.0
2022-09-14 12:00:00	QQQ	ETF	295.89	296.26	295.145	295.81	1610815.0
2022-09-14 12:30:00	QQQ	ETF	295.81	296.74	295.46	296.2999	1589202.0

> showing 50 of 26,016 rows — these rows as CSV

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