PREVIEW / etf_30min / 2022-11-22

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-11-22.parquet
  size:    686 KB
  rows:    27,010

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-11-22 04:00:00	SPY	ETF	394.2	394.95	394.06	394.95	12602.0
2022-11-22 04:30:00	SPY	ETF	394.99	395.81	394.99	395.75	20014.0
2022-11-22 05:00:00	SPY	ETF	395.67	395.82	395.2	395.42	18920.0
2022-11-22 05:30:00	SPY	ETF	395.28	395.44	395.13	395.34	2660.0
2022-11-22 06:00:00	SPY	ETF	395.36	395.5	394.61	395.15	30505.0
2022-11-22 06:30:00	SPY	ETF	395.15	395.15	394.57	395.03	10862.0
2022-11-22 07:00:00	SPY	ETF	395.13	395.7	394.95	395.69	43156.0
2022-11-22 07:30:00	SPY	ETF	395.68	395.81	395.45	395.7	37534.0
2022-11-22 08:00:00	SPY	ETF	395.68	396.45	393.82	395.98	163162.0
2022-11-22 08:30:00	SPY	ETF	396.0	396.71	395.96	396.62	125035.0
2022-11-22 09:00:00	SPY	ETF	396.69	396.79	396.35	396.57	219948.0
2022-11-22 09:30:00	SPY	ETF	396.63	396.86	395.1527	395.92	4074358.0
2022-11-22 10:00:00	SPY	ETF	395.91	397.44	395.7092	397.13	4083411.0
2022-11-22 10:30:00	SPY	ETF	397.13	397.7901	396.57	397.645	3245220.0
2022-11-22 11:00:00	SPY	ETF	397.65	397.73	396.73	397.36	2363820.0
2022-11-22 11:30:00	SPY	ETF	397.35	397.5476	396.82	397.47	1747131.0
2022-11-22 12:00:00	SPY	ETF	397.46	397.89	397.28	397.48	1614955.0
2022-11-22 12:30:00	SPY	ETF	397.46	397.78	397.345	397.46	1096794.0
2022-11-22 13:00:00	SPY	ETF	397.48	398.54	397.33	398.44	1931470.0
2022-11-22 13:30:00	SPY	ETF	398.45	398.69	398.15	398.535	1914708.0
2022-11-22 14:00:00	SPY	ETF	398.53	398.74	398.16	398.52	1786709.0
2022-11-22 14:30:00	SPY	ETF	398.5	399.0125	398.28	398.9	1897504.0
2022-11-22 15:00:00	SPY	ETF	398.91	399.54	398.83	399.45	3719915.0
2022-11-22 15:30:00	SPY	ETF	399.445	400.07	399.34	399.87	10123579.0
2022-11-22 16:00:00	SPY	ETF	399.86	399.92	399.63	399.83	4773704.0
2022-11-22 16:30:00	SPY	ETF	399.79	399.9	399.58	399.8	385650.0
2022-11-22 17:00:00	SPY	ETF	399.85	399.97	399.7	399.82	60515.0
2022-11-22 17:30:00	SPY	ETF	399.83	399.96	399.81	399.95	42003.0
2022-11-22 18:00:00	SPY	ETF	399.89	400.07	399.79	399.94	66292.0
2022-11-22 18:30:00	SPY	ETF	399.98	400.0	399.79	399.96	29544.0
2022-11-22 19:00:00	SPY	ETF	399.97	400.27	399.97	400.07	35862.0
2022-11-22 19:30:00	SPY	ETF	400.05	400.07	399.82	399.86	58905.0
2022-11-22 04:00:00	QQQ	ETF	281.0	281.93	281.0	281.92	42551.0
2022-11-22 04:30:00	QQQ	ETF	281.95	282.76	281.95	282.59	34529.0
2022-11-22 05:00:00	QQQ	ETF	282.6	282.68	282.2	282.25	11740.0
2022-11-22 05:30:00	QQQ	ETF	282.26	282.43	282.14	282.4	19027.0
2022-11-22 06:00:00	QQQ	ETF	282.56	282.56	281.9	282.13	10461.0
2022-11-22 06:30:00	QQQ	ETF	282.2	282.22	281.46	281.8	17927.0
2022-11-22 07:00:00	QQQ	ETF	281.89	282.47	281.74	282.43	146734.0
2022-11-22 07:30:00	QQQ	ETF	282.42	282.58	282.18	282.39	97105.0
2022-11-22 08:00:00	QQQ	ETF	281.8	283.03	280.92	282.56	244161.0
2022-11-22 08:30:00	QQQ	ETF	282.56	283.21	282.53	283.11	238258.0
2022-11-22 09:00:00	QQQ	ETF	283.14	283.21	282.5	282.64	170957.0
2022-11-22 09:30:00	QQQ	ETF	282.64	282.9	280.46	280.93	4707470.0
2022-11-22 10:00:00	QQQ	ETF	280.93	282.7	280.78	282.42	3342302.0
2022-11-22 10:30:00	QQQ	ETF	282.43	283.54	281.75	283.46	2456511.0
2022-11-22 11:00:00	QQQ	ETF	283.46	283.58	282.76	283.26	2374789.0
2022-11-22 11:30:00	QQQ	ETF	283.28	283.39	282.63	283.29	1754093.0
2022-11-22 12:00:00	QQQ	ETF	283.29	283.89	283.26	283.51	1430347.0
2022-11-22 12:30:00	QQQ	ETF	283.51	283.78	283.35	283.55	1124881.0

> showing 50 of 27,010 rows — these rows as CSV

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