PREVIEW / etf_30min / 2022-06-23

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-06-23.parquet
  size:    667 KB
  rows:    26,763

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-06-23 04:00:00	SPY	ETF	372.55	375.51	372.24	374.25	55563.0
2022-06-23 04:30:00	SPY	ETF	374.2	374.25	373.78	373.92	27836.0
2022-06-23 05:00:00	SPY	ETF	373.98	375.28	373.98	374.89	40739.0
2022-06-23 05:30:00	SPY	ETF	374.8	375.81	374.65	375.54	67441.0
2022-06-23 06:00:00	SPY	ETF	375.65	376.58	375.56	376.56	45113.0
2022-06-23 06:30:00	SPY	ETF	376.55	377.53	376.18	377.39	106093.0
2022-06-23 07:00:00	SPY	ETF	377.41	377.85	376.85	377.85	257121.0
2022-06-23 07:30:00	SPY	ETF	377.781	377.85	377.13	377.32	123582.0
2022-06-23 08:00:00	SPY	ETF	377.21	377.8	372.0	376.44	506988.0
2022-06-23 08:30:00	SPY	ETF	376.4	376.41	375.61	376.25	436150.0
2022-06-23 09:00:00	SPY	ETF	376.24	377.29	376.11	376.64	524783.0
2022-06-23 09:30:00	SPY	ETF	376.64	377.38	374.8	377.0125	7574923.0
2022-06-23 10:00:00	SPY	ETF	377.015	377.56	375.32	376.39	3793457.0
2022-06-23 10:30:00	SPY	ETF	376.4	378.1	375.78	377.82	4352110.0
2022-06-23 11:00:00	SPY	ETF	377.83	378.2	376.74	376.95	2885672.0
2022-06-23 11:30:00	SPY	ETF	376.93	377.26	375.05	375.2	3570430.0
2022-06-23 12:00:00	SPY	ETF	375.21	375.43	373.8914	374.62	3892296.0
2022-06-23 12:30:00	SPY	ETF	374.61	374.87	373.08	373.5766	3544027.0
2022-06-23 13:00:00	SPY	ETF	373.58	374.65	372.89	373.9	3862650.0
2022-06-23 13:30:00	SPY	ETF	373.88	374.99	373.31	374.86	2814872.0
2022-06-23 14:00:00	SPY	ETF	374.865	375.6	374.52	375.5	2725481.0
2022-06-23 14:30:00	SPY	ETF	375.52	376.515	375.47	376.19	3341432.0
2022-06-23 15:00:00	SPY	ETF	376.17	377.19	375.71	376.95	3741472.0
2022-06-23 15:30:00	SPY	ETF	376.93	378.83	376.93	378.13	8863311.0
2022-06-23 16:00:00	SPY	ETF	378.12	378.14	376.1653	377.53	2432307.0
2022-06-23 16:30:00	SPY	ETF	377.51	378.1186	376.51	376.67	566965.0
2022-06-23 17:00:00	SPY	ETF	376.64	376.9	376.64	376.7	58989.0
2022-06-23 17:30:00	SPY	ETF	376.7	376.84	376.66	376.84	12589.0
2022-06-23 18:00:00	SPY	ETF	376.84	377.1	376.6	376.66	66021.0
2022-06-23 18:30:00	SPY	ETF	376.75	377.34	376.67	377.19	27145.0
2022-06-23 19:00:00	SPY	ETF	377.21	377.44	377.19	377.36	15704.0
2022-06-23 19:30:00	SPY	ETF	377.2	377.49	376.7	376.77	40333.0
2022-06-23 04:00:00	QQQ	ETF	279.5	282.32	279.5	281.55	135521.0
2022-06-23 04:30:00	QQQ	ETF	281.52	281.55	281.1	281.43	45278.0
2022-06-23 05:00:00	QQQ	ETF	281.4	282.58	281.4	282.06	83172.0
2022-06-23 05:30:00	QQQ	ETF	282.01	282.89	281.85	282.69	59424.0
2022-06-23 06:00:00	QQQ	ETF	282.7	283.35	282.5	283.28	57507.0
2022-06-23 06:30:00	QQQ	ETF	283.3	284.18	282.9	284.02	115377.0
2022-06-23 07:00:00	QQQ	ETF	283.94	284.27	283.39	284.2	162849.0
2022-06-23 07:30:00	QQQ	ETF	284.16	284.2	283.49	283.67	167400.0
2022-06-23 08:00:00	QQQ	ETF	283.69	284.21	279.8	282.82	396234.0
2022-06-23 08:30:00	QQQ	ETF	282.8	282.87	282.04	282.7996	407588.0
2022-06-23 09:00:00	QQQ	ETF	282.83	283.71	282.61	283.23	372024.0
2022-06-23 09:30:00	QQQ	ETF	283.2	283.78	280.31	282.83	7732784.0
2022-06-23 10:00:00	QQQ	ETF	282.8	283.76	281.54	282.971	4249079.0
2022-06-23 10:30:00	QQQ	ETF	282.98	284.84	282.5	284.6201	3571245.0
2022-06-23 11:00:00	QQQ	ETF	284.63	285.14	283.4638	284.415	2892214.0
2022-06-23 11:30:00	QQQ	ETF	284.49	284.78	282.84	282.91	2275263.0
2022-06-23 12:00:00	QQQ	ETF	282.93	283.05	281.61	282.5	2913253.0
2022-06-23 12:30:00	QQQ	ETF	282.53	282.72	280.91	281.1967	2605484.0

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

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