PREVIEW / etf_30min / 2022-11-11

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-11-11.parquet
  size:    691 KB
  rows:    27,521

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-11 04:00:00	SPY	ETF	398.0	398.11	396.53	396.53	68010.0
2022-11-11 04:30:00	SPY	ETF	396.63	397.04	396.41	396.87	36974.0
2022-11-11 05:00:00	SPY	ETF	396.89	397.25	396.35	396.38	42155.0
2022-11-11 05:30:00	SPY	ETF	396.38	396.64	396.0	396.35	28992.0
2022-11-11 06:00:00	SPY	ETF	396.15	396.44	395.84	396.33	191602.0
2022-11-11 06:30:00	SPY	ETF	396.47	396.8	396.29	396.53	74759.0
2022-11-11 07:00:00	SPY	ETF	396.51	396.64	395.77	396.0	167480.0
2022-11-11 07:30:00	SPY	ETF	396.0	396.65	395.8	396.61	255512.0
2022-11-11 08:00:00	SPY	ETF	396.44	398.0	395.29	396.61	623164.0
2022-11-11 08:30:00	SPY	ETF	396.57	396.94	396.19	396.83	357230.0
2022-11-11 09:00:00	SPY	ETF	396.84	397.03	395.19	395.62	458407.0
2022-11-11 09:30:00	SPY	ETF	395.59	396.155	393.61	395.16	7474251.0
2022-11-11 10:00:00	SPY	ETF	395.14	397.55	393.68	396.9511	6691398.0
2022-11-11 10:30:00	SPY	ETF	397.01	397.3766	395.8601	396.33	3950423.0
2022-11-11 11:00:00	SPY	ETF	396.33	397.11	394.36	394.39	4631344.0
2022-11-11 11:30:00	SPY	ETF	394.41	395.67	394.03	395.19	3432851.0
2022-11-11 12:00:00	SPY	ETF	395.19	396.23	394.64	395.95	2553859.0
2022-11-11 12:30:00	SPY	ETF	395.97	396.63	395.27	396.165	2010291.0
2022-11-11 13:00:00	SPY	ETF	396.17	397.78	396.13	397.75	2903690.0
2022-11-11 13:30:00	SPY	ETF	397.755	398.32	397.23	398.18	3449134.0
2022-11-11 14:00:00	SPY	ETF	398.16	398.87	397.66	398.78	3317627.0
2022-11-11 14:30:00	SPY	ETF	398.77	399.34	398.65	399.23	3404395.0
2022-11-11 15:00:00	SPY	ETF	399.23	399.28	397.32	398.535	4699626.0
2022-11-11 15:30:00	SPY	ETF	398.53	399.35	397.89	398.5	10957820.0
2022-11-11 16:00:00	SPY	ETF	398.49	398.7	398.02	398.45	3913563.0
2022-11-11 16:30:00	SPY	ETF	398.44	398.48	398.31	398.31	290955.0
2022-11-11 17:00:00	SPY	ETF	398.42	398.63	398.2	398.58	77161.0
2022-11-11 17:30:00	SPY	ETF	398.56	398.87	398.55	398.63	73879.0
2022-11-11 18:00:00	SPY	ETF	398.77	398.94	398.61	398.7	8209.0
2022-11-11 18:30:00	SPY	ETF	398.7	398.82	398.57	398.6	31293.0
2022-11-11 19:00:00	SPY	ETF	398.6	398.6	398.33	398.53	13940.0
2022-11-11 19:30:00	SPY	ETF	398.54	398.57	398.5	398.51	11382.0
2022-11-11 04:00:00	QQQ	ETF	285.46	286.12	284.88	284.92	95448.0
2022-11-11 04:30:00	QQQ	ETF	284.94	285.21	284.72	285.09	39034.0
2022-11-11 05:00:00	QQQ	ETF	285.07	285.38	284.53	284.65	58739.0
2022-11-11 05:30:00	QQQ	ETF	284.65	284.82	284.14	284.36	68135.0
2022-11-11 06:00:00	QQQ	ETF	284.26	284.64	284.01	284.58	110967.0
2022-11-11 06:30:00	QQQ	ETF	284.65	284.84	284.17	284.44	44554.0
2022-11-11 07:00:00	QQQ	ETF	284.46	284.5	283.7	283.94	190216.0
2022-11-11 07:30:00	QQQ	ETF	283.9	284.55	283.76	284.531	117385.0
2022-11-11 08:00:00	QQQ	ETF	284.2	286.23	282.538	284.44	296897.0
2022-11-11 08:30:00	QQQ	ETF	284.43	284.71	284.01	284.46	228396.0
2022-11-11 09:00:00	QQQ	ETF	284.4	285.25	282.36	282.51	795272.0
2022-11-11 09:30:00	QQQ	ETF	282.56	284.17	281.19	283.0	7364627.0
2022-11-11 10:00:00	QQQ	ETF	283.0	285.87	281.75	285.67	5621975.0
2022-11-11 10:30:00	QQQ	ETF	285.71	286.3399	284.53	285.57	3095371.0
2022-11-11 11:00:00	QQQ	ETF	285.57	286.29	283.3	283.3052	3324730.0
2022-11-11 11:30:00	QQQ	ETF	283.3299	284.86	282.9	284.56	2509545.0
2022-11-11 12:00:00	QQQ	ETF	284.53	285.59	284.01	285.41	1674548.0
2022-11-11 12:30:00	QQQ	ETF	285.42	286.27	284.915	285.9	1695001.0

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

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