PREVIEW / etf_30min / 2022-12-07

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-12-07.parquet
  size:    684 KB
  rows:    27,423

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-07 04:00:00	SPY	ETF	395.0	395.0	393.91	393.91	43081.0
2022-12-07 04:30:00	SPY	ETF	393.87	393.94	393.02	393.24	30963.0
2022-12-07 05:00:00	SPY	ETF	393.32	393.42	392.9	392.9	10031.0
2022-12-07 05:30:00	SPY	ETF	392.91	393.2	392.77	393.2	31909.0
2022-12-07 06:00:00	SPY	ETF	393.37	393.52	392.97	392.97	38194.0
2022-12-07 06:30:00	SPY	ETF	392.95	393.3	392.26	392.5	31462.0
2022-12-07 07:00:00	SPY	ETF	392.55	392.76	391.11	391.34	174287.0
2022-12-07 07:30:00	SPY	ETF	391.33	391.62	390.99	391.5	206998.0
2022-12-07 08:00:00	SPY	ETF	392.3475	394.5096	391.07	392.04	237095.0
2022-12-07 08:30:00	SPY	ETF	392.17	393.21	392.17	392.8201	340166.0
2022-12-07 09:00:00	SPY	ETF	392.85	393.46	392.65	392.89	335496.0
2022-12-07 09:30:00	SPY	ETF	392.9	395.3	392.34	392.82	6034223.0
2022-12-07 10:00:00	SPY	ETF	392.81	394.81	391.97	394.76	6022749.0
2022-12-07 10:30:00	SPY	ETF	394.76	395.45	393.21	395.056	3276917.0
2022-12-07 11:00:00	SPY	ETF	395.06	395.64	392.49	392.6699	3882809.0
2022-12-07 11:30:00	SPY	ETF	392.65	393.64	392.31	393.39	2788852.0
2022-12-07 12:00:00	SPY	ETF	393.38	393.725	392.72	392.93	1863588.0
2022-12-07 12:30:00	SPY	ETF	392.93	394.09	392.68	393.71	1641961.0
2022-12-07 13:00:00	SPY	ETF	393.71	394.59	393.27	394.2	1699297.0
2022-12-07 13:30:00	SPY	ETF	394.1414	394.2001	392.87	393.0425	1730012.0
2022-12-07 14:00:00	SPY	ETF	393.02	393.3899	392.3246	393.13	2577442.0
2022-12-07 14:30:00	SPY	ETF	393.12	393.73	392.67	392.92	2336792.0
2022-12-07 15:00:00	SPY	ETF	392.91	393.4	392.09	392.785	2681198.0
2022-12-07 15:30:00	SPY	ETF	392.79	393.48	392.68	393.15	6184068.0
2022-12-07 16:00:00	SPY	ETF	393.15	393.37	392.92	393.06	2923441.0
2022-12-07 16:30:00	SPY	ETF	393.06	393.06	392.98	393.05	230929.0
2022-12-07 17:00:00	SPY	ETF	393.05	393.1	392.94	393.1	107337.0
2022-12-07 17:30:00	SPY	ETF	393.08	393.16	393.05	393.11	386611.0
2022-12-07 18:00:00	SPY	ETF	393.11	393.37	393.04	393.331	49924.0
2022-12-07 18:30:00	SPY	ETF	393.3	393.39	393.15	393.24	40178.0
2022-12-07 19:00:00	SPY	ETF	393.33	393.34	392.55	392.6	41936.0
2022-12-07 19:30:00	SPY	ETF	392.58	392.76	392.23	392.23	73730.0
2022-12-07 20:00:00	SPY	ETF	392.23	392.23	392.23	392.23	1000.0
2022-12-07 04:00:00	QQQ	ETF	281.82	281.87	281.33	281.41	19308.0
2022-12-07 04:30:00	QQQ	ETF	281.36	281.47	280.66	280.86	19485.0
2022-12-07 05:00:00	QQQ	ETF	280.97	281.07	280.69	280.71	10553.0
2022-12-07 05:30:00	QQQ	ETF	280.7	281.0	280.6	281.0	20312.0
2022-12-07 06:00:00	QQQ	ETF	281.08	281.22	280.8	280.8	25502.0
2022-12-07 06:30:00	QQQ	ETF	280.77	281.02	279.83	280.15	52299.0
2022-12-07 07:00:00	QQQ	ETF	280.15	280.36	278.6	278.8	166689.0
2022-12-07 07:30:00	QQQ	ETF	278.81	279.08	278.4	278.94	220558.0
2022-12-07 08:00:00	QQQ	ETF	280.21	282.31	278.47	279.46	302317.0
2022-12-07 08:30:00	QQQ	ETF	279.59	280.72	279.59	280.38	563181.0
2022-12-07 09:00:00	QQQ	ETF	280.42	280.89	280.0	280.43	518775.0
2022-12-07 09:30:00	QQQ	ETF	280.47	282.57	279.25	279.54	5619821.0
2022-12-07 10:00:00	QQQ	ETF	279.53	281.16	278.7801	280.75	4325216.0
2022-12-07 10:30:00	QQQ	ETF	280.7	281.97	279.31	281.52	2696556.0
2022-12-07 11:00:00	QQQ	ETF	281.55	282.22	279.41	279.52	2458733.0
2022-12-07 11:30:00	QQQ	ETF	279.49	280.69	279.23	280.41	1669556.0
2022-12-07 12:00:00	QQQ	ETF	280.38	280.68	279.73	279.8483	1515944.0

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

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