PREVIEW / etf_30min / 2022-07-13

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-07-13.parquet
  size:    641 KB
  rows:    25,957

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-07-13 04:00:00	SPY	ETF	380.8	381.19	380.42	381.19	18942.0
2022-07-13 04:30:00	SPY	ETF	381.2	382.2	381.2	382.15	9061.0
2022-07-13 05:00:00	SPY	ETF	382.14	382.2	381.84	381.84	11653.0
2022-07-13 05:30:00	SPY	ETF	382.14	382.17	381.79	381.83	2233.0
2022-07-13 06:00:00	SPY	ETF	381.75	381.75	381.45	381.53	6572.0
2022-07-13 06:30:00	SPY	ETF	381.45	381.61	381.14	381.61	56341.0
2022-07-13 07:00:00	SPY	ETF	381.61	382.03	381.41	381.48	148328.0
2022-07-13 07:30:00	SPY	ETF	381.46	382.25	381.43	382.11	92518.0
2022-07-13 08:00:00	SPY	ETF	381.52	385.71	380.7	384.34	470399.0
2022-07-13 08:30:00	SPY	ETF	383.99	384.55	373.18	375.71	3703808.0
2022-07-13 09:00:00	SPY	ETF	375.59	376.49	374.84	375.08	1023521.0
2022-07-13 09:30:00	SPY	ETF	375.1	378.14	374.658	377.57	8598394.0
2022-07-13 10:00:00	SPY	ETF	377.55	377.85	375.05	376.57	5543666.0
2022-07-13 10:30:00	SPY	ETF	376.555	380.2	376.17	379.58	6027828.0
2022-07-13 11:00:00	SPY	ETF	379.6	380.87	378.75	378.7773	4084937.0
2022-07-13 11:30:00	SPY	ETF	378.77	379.49	377.99	378.7501	3025681.0
2022-07-13 12:00:00	SPY	ETF	378.76	379.8699	378.59	379.79	2351311.0
2022-07-13 12:30:00	SPY	ETF	379.8	380.83	379.55	380.81	2125810.0
2022-07-13 13:00:00	SPY	ETF	380.83	381.92	380.17	380.71	3545572.0
2022-07-13 13:30:00	SPY	ETF	380.74	381.1	379.89	380.84	2111269.0
2022-07-13 14:00:00	SPY	ETF	380.8299	380.84	378.55	380.38	4612929.0
2022-07-13 14:30:00	SPY	ETF	380.38	381.41	379.991	381.38	3314439.0
2022-07-13 15:00:00	SPY	ETF	381.41	381.46	380.02	380.25	3120803.0
2022-07-13 15:30:00	SPY	ETF	380.21	380.4078	378.86	378.87	7846885.0
2022-07-13 16:00:00	SPY	ETF	378.87	379.0017	378.09	378.28	2940483.0
2022-07-13 16:30:00	SPY	ETF	378.29	378.34	378.01	378.15	361689.0
2022-07-13 17:00:00	SPY	ETF	378.2	378.2	378.0	378.09	49352.0
2022-07-13 17:30:00	SPY	ETF	378.09	378.1	378.02	378.09	13337.0
2022-07-13 18:00:00	SPY	ETF	378.03	378.08	377.65	377.85	51831.0
2022-07-13 18:30:00	SPY	ETF	377.78	377.8	376.89	377.16	105717.0
2022-07-13 19:00:00	SPY	ETF	377.13	377.58	376.66	376.78	49539.0
2022-07-13 19:30:00	SPY	ETF	376.82	376.96	376.1	376.44	64184.0
2022-07-13 04:00:00	QQQ	ETF	286.59	286.95	286.06	286.95	29319.0
2022-07-13 04:30:00	QQQ	ETF	287.0	287.6	287.0	287.6	24582.0
2022-07-13 05:00:00	QQQ	ETF	287.6	287.6	287.15	287.49	30618.0
2022-07-13 05:30:00	QQQ	ETF	287.5	287.5	287.13	287.13	10678.0
2022-07-13 06:00:00	QQQ	ETF	287.11	287.17	286.88	286.93	30671.0
2022-07-13 06:30:00	QQQ	ETF	286.91	287.16	286.66	287.14	30069.0
2022-07-13 07:00:00	QQQ	ETF	287.12	287.43	286.92	286.97	121008.0
2022-07-13 07:30:00	QQQ	ETF	287.05	287.61	286.83	287.45	145710.0
2022-07-13 08:00:00	QQQ	ETF	286.9301	290.6	286.31	289.0516	507956.0
2022-07-13 08:30:00	QQQ	ETF	290.31	290.31	279.03	281.0	4859300.0
2022-07-13 09:00:00	QQQ	ETF	280.95	281.72	280.15	280.59	1184556.0
2022-07-13 09:30:00	QQQ	ETF	280.6	284.99	280.02	283.845	10172917.0
2022-07-13 10:00:00	QQQ	ETF	283.85	284.27	281.88	283.52	5844261.0
2022-07-13 10:30:00	QQQ	ETF	283.46	287.54	283.14	286.45	6141557.0
2022-07-13 11:00:00	QQQ	ETF	286.51	287.49	285.3317	285.37	3434657.0
2022-07-13 11:30:00	QQQ	ETF	285.36	285.97	284.455	285.4731	2248758.0
2022-07-13 12:00:00	QQQ	ETF	285.47	286.44	285.15	286.15	2030619.0
2022-07-13 12:30:00	QQQ	ETF	286.16	287.23	285.99	287.2192	1580483.0

> showing 50 of 25,957 rows — these rows as CSV

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