PREVIEW / etf_30min / 2022-12-09

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-12-09.parquet
  size:    674 KB
  rows:    26,941

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-12-09 04:00:00	SPY	ETF	397.1	397.9	396.83	397.08	13234.0
2022-12-09 04:30:00	SPY	ETF	397.13	397.13	396.72	396.91	5011.0
2022-12-09 05:00:00	SPY	ETF	396.88	397.32	396.88	397.3	13237.0
2022-12-09 05:30:00	SPY	ETF	397.34	397.59	397.23	397.57	8693.0
2022-12-09 06:00:00	SPY	ETF	397.66	397.96	397.52	397.65	20585.0
2022-12-09 06:30:00	SPY	ETF	397.69	397.75	397.4	397.74	21713.0
2022-12-09 07:00:00	SPY	ETF	397.7	398.14	397.47	398.13	132538.0
2022-12-09 07:30:00	SPY	ETF	398.2	398.63	398.18	398.55	183007.0
2022-12-09 08:00:00	SPY	ETF	397.6	398.68	397.06	398.3499	335886.0
2022-12-09 08:30:00	SPY	ETF	398.35	398.7	392.75	395.45	1357031.0
2022-12-09 09:00:00	SPY	ETF	395.44	395.5	394.25	394.93	393556.0
2022-12-09 09:30:00	SPY	ETF	394.94	396.89	394.12	395.7426	5205743.0
2022-12-09 10:00:00	SPY	ETF	395.7	396.7	394.72	395.8	3919514.0
2022-12-09 10:30:00	SPY	ETF	395.77	397.16	395.455	397.1121	3690720.0
2022-12-09 11:00:00	SPY	ETF	397.13	397.44	396.2	396.91	3322328.0
2022-12-09 11:30:00	SPY	ETF	396.9	397.62	396.29	397.36	2545740.0
2022-12-09 12:00:00	SPY	ETF	397.39	397.47	396.48	396.584	1788834.0
2022-12-09 12:30:00	SPY	ETF	396.595	397.2251	396.34	396.56	1867536.0
2022-12-09 13:00:00	SPY	ETF	396.53	396.53	395.3495	395.82	2561101.0
2022-12-09 13:30:00	SPY	ETF	395.8202	396.3	395.69	395.9853	1618848.0
2022-12-09 14:00:00	SPY	ETF	395.97	396.05	395.01	395.8813	3013418.0
2022-12-09 14:30:00	SPY	ETF	395.89	396.11	395.54	395.85	1609313.0
2022-12-09 15:00:00	SPY	ETF	395.81	396.29	395.41	395.4501	2808161.0
2022-12-09 15:30:00	SPY	ETF	395.45	395.59	393.15	393.285	11874580.0
2022-12-09 16:00:00	SPY	ETF	393.29	394.0	393.0	393.04	4970680.0
2022-12-09 16:30:00	SPY	ETF	393.05	393.14	392.8101	392.85	428313.0
2022-12-09 17:00:00	SPY	ETF	392.9	393.01	392.85	392.99	36967.0
2022-12-09 17:30:00	SPY	ETF	392.99	393.0	392.85	392.94	22072.0
2022-12-09 18:00:00	SPY	ETF	392.94	393.0	392.94	393.0	30002.0
2022-12-09 18:30:00	SPY	ETF	392.97	393.02	392.94	393.02	8650.0
2022-12-09 19:00:00	SPY	ETF	393.0	393.05	392.96	392.97	13807.0
2022-12-09 19:30:00	SPY	ETF	392.97	393.0	392.55	392.55	25545.0
2022-12-09 04:00:00	QQQ	ETF	284.98	285.21	284.74	284.9	32865.0
2022-12-09 04:30:00	QQQ	ETF	284.96	284.96	284.41	284.65	16142.0
2022-12-09 05:00:00	QQQ	ETF	284.6	284.95	284.6	284.92	19140.0
2022-12-09 05:30:00	QQQ	ETF	284.96	285.29	284.9	285.15	17609.0
2022-12-09 06:00:00	QQQ	ETF	285.25	285.45	285.0	285.15	12554.0
2022-12-09 06:30:00	QQQ	ETF	285.25	285.25	284.97	285.23	12795.0
2022-12-09 07:00:00	QQQ	ETF	285.25	285.68	285.03	285.65	77864.0
2022-12-09 07:30:00	QQQ	ETF	285.62	286.06	285.61	285.96	182688.0
2022-12-09 08:00:00	QQQ	ETF	285.3	286.08	284.062	285.7	337520.0
2022-12-09 08:30:00	QQQ	ETF	285.84	286.3	280.93	283.21	2274420.0
2022-12-09 09:00:00	QQQ	ETF	283.2	283.35	282.15	282.83	513511.0
2022-12-09 09:30:00	QQQ	ETF	282.81	284.27	281.59	283.1763	5175409.0
2022-12-09 10:00:00	QQQ	ETF	283.19	284.22	282.19	283.5131	4294035.0
2022-12-09 10:30:00	QQQ	ETF	283.53	285.34	283.47	285.3101	2805024.0
2022-12-09 11:00:00	QQQ	ETF	285.32	285.58	284.43	284.93	2271318.0
2022-12-09 11:30:00	QQQ	ETF	284.91	285.64	284.36	285.365	1881398.0
2022-12-09 12:00:00	QQQ	ETF	285.365	285.64	284.83	285.0	1513472.0
2022-12-09 12:30:00	QQQ	ETF	285.01	285.61	284.71	284.82	1400849.0

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

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