PREVIEW / etf_30min / 2023-02-02

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-02-02.parquet
  size:    773 KB
  rows:    30,505

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-02-02 04:00:00	SPY	ETF	413.32	413.34	412.24	412.37	54710.0
2023-02-02 04:30:00	SPY	ETF	412.35	412.95	412.35	412.84	121437.0
2023-02-02 05:00:00	SPY	ETF	412.96	413.1	412.63	412.71	14399.0
2023-02-02 05:30:00	SPY	ETF	412.69	412.85	412.57	412.71	16171.0
2023-02-02 06:00:00	SPY	ETF	412.62	412.97	412.33	412.88	20393.0
2023-02-02 06:30:00	SPY	ETF	412.92	413.0	412.21	412.5	11770.0
2023-02-02 07:00:00	SPY	ETF	412.55	412.55	412.07	412.07	89703.0
2023-02-02 07:30:00	SPY	ETF	412.2	413.11	412.18	413.08	222924.0
2023-02-02 08:00:00	SPY	ETF	412.2199	413.78	411.95	413.43	607474.0
2023-02-02 08:30:00	SPY	ETF	413.47	414.83	413.28	414.66	530333.0
2023-02-02 09:00:00	SPY	ETF	414.63	415.07	414.26	414.86	474865.0
2023-02-02 09:30:00	SPY	ETF	414.86	415.08	413.33	413.555	7553097.0
2023-02-02 10:00:00	SPY	ETF	413.57	414.86	412.88	414.67	5949256.0
2023-02-02 10:30:00	SPY	ETF	414.68	417.14	414.67	416.644	6447121.0
2023-02-02 11:00:00	SPY	ETF	416.65	417.05	415.96	416.53	4385599.0
2023-02-02 11:30:00	SPY	ETF	416.535	417.07	415.83	415.8592	3244409.0
2023-02-02 12:00:00	SPY	ETF	415.87	416.77	415.6	416.4509	3261757.0
2023-02-02 12:30:00	SPY	ETF	416.46	416.95	415.98	416.6795	3091457.0
2023-02-02 13:00:00	SPY	ETF	416.67	417.3	416.39	416.69	3215579.0
2023-02-02 13:30:00	SPY	ETF	416.685	418.07	416.68	418.055	3281930.0
2023-02-02 14:00:00	SPY	ETF	418.06	418.31	415.46	415.59	6115917.0
2023-02-02 14:30:00	SPY	ETF	415.595	415.77	413.67	413.8001	6510303.0
2023-02-02 15:00:00	SPY	ETF	413.8101	415.54	413.23	415.22	6128646.0
2023-02-02 15:30:00	SPY	ETF	415.25	416.8	414.65	416.78	10993290.0
2023-02-02 16:00:00	SPY	ETF	416.78	418.13	414.02	415.07	4289770.0
2023-02-02 16:30:00	SPY	ETF	415.06	416.78	412.97	414.0	1061911.0
2023-02-02 17:00:00	SPY	ETF	413.94	414.24	413.75	414.15	283007.0
2023-02-02 17:30:00	SPY	ETF	414.06	416.0	414.06	415.31	183249.0
2023-02-02 18:00:00	SPY	ETF	415.25	415.25	414.05	414.14	128893.0
2023-02-02 18:30:00	SPY	ETF	414.24	414.48	413.86	413.99	62935.0
2023-02-02 19:00:00	SPY	ETF	414.07	414.54	414.06	414.5	18220.0
2023-02-02 19:30:00	SPY	ETF	414.44	414.55	414.37	414.45	52120.0
2023-02-02 04:00:00	QQQ	ETF	305.69	306.0	304.58	304.91	197181.0
2023-02-02 04:30:00	QQQ	ETF	304.89	305.43	304.89	305.4	42874.0
2023-02-02 05:00:00	QQQ	ETF	305.41	305.61	305.03	305.1	33285.0
2023-02-02 05:30:00	QQQ	ETF	305.08	305.22	304.82	304.97	26680.0
2023-02-02 06:00:00	QQQ	ETF	304.97	305.33	304.6	305.24	25239.0
2023-02-02 06:30:00	QQQ	ETF	305.27	305.27	304.56	304.86	33120.0
2023-02-02 07:00:00	QQQ	ETF	304.8	304.93	304.49	304.72	132044.0
2023-02-02 07:30:00	QQQ	ETF	304.71	305.9	304.71	305.87	232127.0
2023-02-02 08:00:00	QQQ	ETF	305.85	306.15	301.145	306.04	534834.0
2023-02-02 08:30:00	QQQ	ETF	305.93	307.18	305.85	307.06	671322.0
2023-02-02 09:00:00	QQQ	ETF	307.09	307.52	306.71	307.52	560349.0
2023-02-02 09:30:00	QQQ	ETF	307.52	309.15	307.25	307.3462	9236569.0
2023-02-02 10:00:00	QQQ	ETF	307.3599	309.0618	306.73	308.801	4653487.0
2023-02-02 10:30:00	QQQ	ETF	308.8223	311.05	308.8223	310.51	4487051.0
2023-02-02 11:00:00	QQQ	ETF	310.52	311.16	309.95	310.6331	3369094.0
2023-02-02 11:30:00	QQQ	ETF	310.64	311.345	310.0	310.0679	2842320.0
2023-02-02 12:00:00	QQQ	ETF	310.07	310.9499	309.72	310.7605	2194450.0
2023-02-02 12:30:00	QQQ	ETF	310.77	311.4199	310.64	311.29	1816685.0

> showing 50 of 30,505 rows — these rows as CSV

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