PREVIEW / etf_30min / 2023-03-03

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-03-03.parquet
  size:    683 KB
  rows:    27,187

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
2023-03-03 04:00:00	SPY	ETF	397.56	398.22	397.56	398.05	24848.0
2023-03-03 04:30:00	SPY	ETF	398.19	398.42	397.99	398.17	7185.0
2023-03-03 05:00:00	SPY	ETF	398.23	398.7	398.23	398.65	22735.0
2023-03-03 05:30:00	SPY	ETF	398.63	398.79	398.37	398.63	19450.0
2023-03-03 06:00:00	SPY	ETF	398.72	399.1	398.7	399.0	15951.0
2023-03-03 06:30:00	SPY	ETF	398.96	399.03	398.84	398.99	21041.0
2023-03-03 07:00:00	SPY	ETF	399.05	399.4	398.9	398.99	179238.0
2023-03-03 07:30:00	SPY	ETF	399.01	399.2	398.59	398.65	122836.0
2023-03-03 08:00:00	SPY	ETF	399.27	399.4299	397.0	399.03	229588.0
2023-03-03 08:30:00	SPY	ETF	398.98	399.9	398.77	399.87	369415.0
2023-03-03 09:00:00	SPY	ETF	399.87	400.28	399.68	399.71	573143.0
2023-03-03 09:30:00	SPY	ETF	399.71	400.92	399.155	400.55	8143110.0
2023-03-03 10:00:00	SPY	ETF	400.52	401.39	399.03	401.37	8665699.0
2023-03-03 10:30:00	SPY	ETF	401.36	401.5	400.56	400.71	4938435.0
2023-03-03 11:00:00	SPY	ETF	400.75	401.4	400.52	401.22	3209187.0
2023-03-03 11:30:00	SPY	ETF	401.225	402.15	400.9402	401.9214	3981993.0
2023-03-03 12:00:00	SPY	ETF	401.93	402.33	401.84	402.19	2899985.0
2023-03-03 12:30:00	SPY	ETF	402.19	403.0	401.92	402.95	2893858.0
2023-03-03 13:00:00	SPY	ETF	402.96	403.24	402.67	402.97	3251813.0
2023-03-03 13:30:00	SPY	ETF	402.98	403.045	402.65	402.875	2037259.0
2023-03-03 14:00:00	SPY	ETF	402.89	403.77	402.58	403.73	3711549.0
2023-03-03 14:30:00	SPY	ETF	403.72	403.89	403.505	403.845	3197867.0
2023-03-03 15:00:00	SPY	ETF	403.85	404.45	403.66	404.01	5228484.0
2023-03-03 15:30:00	SPY	ETF	404.01	404.23	403.48	404.14	11747716.0
2023-03-03 16:00:00	SPY	ETF	404.13	405.0	403.89	404.39	5027886.0
2023-03-03 16:30:00	SPY	ETF	404.39	404.5	404.14	404.44	400815.0
2023-03-03 17:00:00	SPY	ETF	404.47	404.62	404.38	404.52	72971.0
2023-03-03 17:30:00	SPY	ETF	404.53	404.55	404.43	404.48	26757.0
2023-03-03 18:00:00	SPY	ETF	404.49	404.65	404.41	404.65	8064.0
2023-03-03 18:30:00	SPY	ETF	404.57	404.65	404.54	404.59	6066.0
2023-03-03 19:00:00	SPY	ETF	404.6	404.63	404.58	404.62	5613.0
2023-03-03 19:30:00	SPY	ETF	404.64	404.95	404.57	404.73	44152.0
2023-03-03 04:00:00	QQQ	ETF	293.71	294.33	293.71	294.05	53519.0
2023-03-03 04:30:00	QQQ	ETF	294.03	294.27	293.82	294.0	24939.0
2023-03-03 05:00:00	QQQ	ETF	294.21	294.61	294.11	294.51	28819.0
2023-03-03 05:30:00	QQQ	ETF	294.54	294.65	294.22	294.43	10743.0
2023-03-03 06:00:00	QQQ	ETF	294.38	294.92	294.38	294.89	65364.0
2023-03-03 06:30:00	QQQ	ETF	294.8	294.87	294.69	294.87	12817.0
2023-03-03 07:00:00	QQQ	ETF	294.83	295.12	294.4	294.501	187223.0
2023-03-03 07:30:00	QQQ	ETF	294.54	294.7	294.08	294.22	220559.0
2023-03-03 08:00:00	QQQ	ETF	295.048	295.12	292.64	294.51	384945.0
2023-03-03 08:30:00	QQQ	ETF	294.51	295.56	294.34	295.5	393521.0
2023-03-03 09:00:00	QQQ	ETF	295.52	295.87	295.36	295.38	509705.0
2023-03-03 09:30:00	QQQ	ETF	295.39	296.9752	294.87	296.75	5995465.0
2023-03-03 10:00:00	QQQ	ETF	296.72	297.6	295.335	297.5886	5844876.0
2023-03-03 10:30:00	QQQ	ETF	297.5883	297.8	296.54	296.65	3049826.0
2023-03-03 11:00:00	QQQ	ETF	296.67	297.215	296.28	296.96	2303186.0
2023-03-03 11:30:00	QQQ	ETF	296.97	297.75	296.58	297.54	2403152.0
2023-03-03 12:00:00	QQQ	ETF	297.56	297.87	297.38	297.77	1821205.0
2023-03-03 12:30:00	QQQ	ETF	297.765	298.62	297.45	298.5699	2133280.0

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

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