PREVIEW / etf_30min / 2022-06-07

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-06-07.parquet
  size:    662 KB
  rows:    25,596

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-07 04:00:00	SPY	ETF	410.5	410.68	410.16	410.4	29161.0
2022-06-07 04:30:00	SPY	ETF	410.4	410.85	410.4	410.54	12347.0
2022-06-07 05:00:00	SPY	ETF	410.35	410.52	409.89	410.5	17619.0
2022-06-07 05:30:00	SPY	ETF	410.56	410.61	409.86	409.88	9366.0
2022-06-07 06:00:00	SPY	ETF	409.98	410.07	409.09	409.46	21462.0
2022-06-07 06:30:00	SPY	ETF	409.49	410.09	408.67	408.8	38848.0
2022-06-07 07:00:00	SPY	ETF	408.87	409.43	407.66	408.7	301723.0
2022-06-07 07:30:00	SPY	ETF	408.62	408.91	408.4	408.65	208627.0
2022-06-07 08:00:00	SPY	ETF	409.38	410.08	407.76	408.46	191894.0
2022-06-07 08:30:00	SPY	ETF	408.39	408.66	407.75	407.77	315364.0
2022-06-07 09:00:00	SPY	ETF	407.72	408.1	407.42	408.05	257729.0
2022-06-07 09:30:00	SPY	ETF	408.1	410.54	407.61	409.7	5119212.0
2022-06-07 10:00:00	SPY	ETF	409.71	411.5	408.965	411.34	3435971.0
2022-06-07 10:30:00	SPY	ETF	411.37	413.65	411.1893	413.03	4696875.0
2022-06-07 11:00:00	SPY	ETF	413.03	413.38	411.555	411.76	2605492.0
2022-06-07 11:30:00	SPY	ETF	411.77	411.99	410.86	411.77	2207125.0
2022-06-07 12:00:00	SPY	ETF	411.79	411.9999	410.6644	411.35	1715020.0
2022-06-07 12:30:00	SPY	ETF	411.35	412.67	411.09	412.4801	1841117.0
2022-06-07 13:00:00	SPY	ETF	412.5	413.6	412.23	413.35	2085342.0
2022-06-07 13:30:00	SPY	ETF	413.37	413.555	413.0	413.105	1464117.0
2022-06-07 14:00:00	SPY	ETF	413.12	414.69	412.91	414.44	2243918.0
2022-06-07 14:30:00	SPY	ETF	414.44	414.91	413.37	414.1	2596404.0
2022-06-07 15:00:00	SPY	ETF	414.11	414.968	413.96	414.865	2976720.0
2022-06-07 15:30:00	SPY	ETF	414.87	416.22	414.71	415.7	8948369.0
2022-06-07 16:00:00	SPY	ETF	415.68	415.767	415.0	415.0	3156128.0
2022-06-07 16:30:00	SPY	ETF	415.03	415.08	414.75	414.8	203077.0
2022-06-07 17:00:00	SPY	ETF	414.87	414.96	414.77	414.82	33401.0
2022-06-07 17:30:00	SPY	ETF	414.94	415.1	414.94	415.02	54736.0
2022-06-07 18:00:00	SPY	ETF	415.02	415.38	414.9	415.21	77721.0
2022-06-07 18:30:00	SPY	ETF	415.13	415.16	414.95	415.05	10524.0
2022-06-07 19:00:00	SPY	ETF	415.1	415.25	415.03	415.21	8558.0
2022-06-07 19:30:00	SPY	ETF	415.14	415.14	414.45	414.55	96430.0
2022-06-07 04:00:00	QQQ	ETF	305.8	306.12	305.64	305.87	31249.0
2022-06-07 04:30:00	QQQ	ETF	305.79	306.36	305.77	306.12	13226.0
2022-06-07 05:00:00	QQQ	ETF	306.12	306.12	305.49	305.93	17853.0
2022-06-07 05:30:00	QQQ	ETF	305.99	306.13	305.42	305.56	14285.0
2022-06-07 06:00:00	QQQ	ETF	305.63	305.73	304.64	305.0	27379.0
2022-06-07 06:30:00	QQQ	ETF	304.99	305.53	304.37	304.38	33664.0
2022-06-07 07:00:00	QQQ	ETF	304.57	305.07	303.4	304.27	186691.0
2022-06-07 07:30:00	QQQ	ETF	304.22	304.45	303.67	304.03	187069.0
2022-06-07 08:00:00	QQQ	ETF	304.08	307.45	303.5	303.79	193786.0
2022-06-07 08:30:00	QQQ	ETF	303.79	303.96	303.13	303.2	262450.0
2022-06-07 09:00:00	QQQ	ETF	303.2	303.85	303.0495	303.8	287849.0
2022-06-07 09:30:00	QQQ	ETF	303.81	306.78	302.6886	305.495	6189258.0
2022-06-07 10:00:00	QQQ	ETF	305.53	307.26	304.63	307.03	3524368.0
2022-06-07 10:30:00	QQQ	ETF	307.05	309.82	306.85	308.95	3933389.0
2022-06-07 11:00:00	QQQ	ETF	308.96	309.17	307.08	307.2193	2522126.0
2022-06-07 11:30:00	QQQ	ETF	307.19	307.75	306.33	307.6	2479064.0
2022-06-07 12:00:00	QQQ	ETF	307.6016	307.83	306.3813	306.93	1597009.0
2022-06-07 12:30:00	QQQ	ETF	306.91	308.0999	306.5514	307.8711	1633185.0

> showing 50 of 25,596 rows — these rows as CSV

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