PREVIEW / etf_30min / 2022-10-19

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-10-19.parquet
  size:    668 KB
  rows:    27,108

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-10-19 04:00:00	SPY	ETF	371.79	372.93	370.0	370.1	58387.0
2022-10-19 04:30:00	SPY	ETF	370.25	370.97	370.24	370.93	10986.0
2022-10-19 05:00:00	SPY	ETF	370.83	371.68	370.77	371.34	12557.0
2022-10-19 05:30:00	SPY	ETF	371.69	372.99	371.69	372.94	23679.0
2022-10-19 06:00:00	SPY	ETF	373.0	373.07	371.75	371.75	41499.0
2022-10-19 06:30:00	SPY	ETF	371.73	371.99	370.64	370.94	78608.0
2022-10-19 07:00:00	SPY	ETF	371.24	371.67	369.09	369.33	437677.0
2022-10-19 07:30:00	SPY	ETF	369.1	369.96	368.99	369.93	316432.0
2022-10-19 08:00:00	SPY	ETF	371.48	373.9	368.33	369.08	579592.0
2022-10-19 08:30:00	SPY	ETF	368.99	369.2	367.99	368.89	559330.0
2022-10-19 09:00:00	SPY	ETF	368.84	369.11	368.18	368.98	527398.0
2022-10-19 09:30:00	SPY	ETF	368.98	370.94	367.85	368.59	7384081.0
2022-10-19 10:00:00	SPY	ETF	368.58	371.83	368.23	371.58	5023289.0
2022-10-19 10:30:00	SPY	ETF	371.59	371.85	369.301	369.68	3720032.0
2022-10-19 11:00:00	SPY	ETF	369.68	370.74	369.205	369.5316	3301755.0
2022-10-19 11:30:00	SPY	ETF	369.55	370.35	368.67	369.73	3115217.0
2022-10-19 12:00:00	SPY	ETF	369.73	369.82	368.0	368.2	3031278.0
2022-10-19 12:30:00	SPY	ETF	368.2	368.9211	366.865	367.25	4204118.0
2022-10-19 13:00:00	SPY	ETF	367.23	367.48	365.55	366.61	5298664.0
2022-10-19 13:30:00	SPY	ETF	366.59	367.0	366.07	366.9301	2539755.0
2022-10-19 14:00:00	SPY	ETF	366.931	368.47	366.58	368.12	4070525.0
2022-10-19 14:30:00	SPY	ETF	368.12	368.32	367.06	367.19	2590844.0
2022-10-19 15:00:00	SPY	ETF	367.19	368.73	366.91	367.73	4451987.0
2022-10-19 15:30:00	SPY	ETF	367.72	368.67	367.35	368.56	6820334.0
2022-10-19 16:00:00	SPY	ETF	368.56	369.92	367.91	368.55	3267817.0
2022-10-19 16:30:00	SPY	ETF	368.59	369.25	368.5	368.93	1268887.0
2022-10-19 17:00:00	SPY	ETF	368.82	368.91	368.4459	368.51	240746.0
2022-10-19 17:30:00	SPY	ETF	368.51	368.83	368.5	368.57	40212.0
2022-10-19 18:00:00	SPY	ETF	368.58	368.84	368.17	368.78	56244.0
2022-10-19 18:30:00	SPY	ETF	368.7	368.84	367.5	367.66	63347.0
2022-10-19 19:00:00	SPY	ETF	367.67	367.7	367.16	367.25	51787.0
2022-10-19 19:30:00	SPY	ETF	367.22	367.6	367.0	367.49	67603.0
2022-10-19 04:00:00	QQQ	ETF	272.8	272.8	271.01	271.23	138442.0
2022-10-19 04:30:00	QQQ	ETF	271.3	272.0	271.3	271.89	85764.0
2022-10-19 05:00:00	QQQ	ETF	271.86	272.74	271.86	272.27	95585.0
2022-10-19 05:30:00	QQQ	ETF	272.5	273.79	272.5	273.72	60604.0
2022-10-19 06:00:00	QQQ	ETF	273.79	273.82	272.66	272.66	91433.0
2022-10-19 06:30:00	QQQ	ETF	272.65	272.88	271.49	272.0	196973.0
2022-10-19 07:00:00	QQQ	ETF	272.04	272.49	270.11	270.22	411404.0
2022-10-19 07:30:00	QQQ	ETF	270.16	270.9	269.91	270.87	253938.0
2022-10-19 08:00:00	QQQ	ETF	272.24	274.99	269.5	270.26	520825.0
2022-10-19 08:30:00	QQQ	ETF	270.25	270.3	269.33	270.0	560134.0
2022-10-19 09:00:00	QQQ	ETF	269.94	270.13	269.33	269.88	451226.0
2022-10-19 09:30:00	QQQ	ETF	269.93	271.95	269.445	270.11	6176130.0
2022-10-19 10:00:00	QQQ	ETF	270.11	273.65	269.72	273.4101	3740187.0
2022-10-19 10:30:00	QQQ	ETF	273.45	273.68	271.1	271.36	2814200.0
2022-10-19 11:00:00	QQQ	ETF	271.36	272.45	270.99	271.3199	2469745.0
2022-10-19 11:30:00	QQQ	ETF	271.33	272.295	270.63	271.72	2150205.0
2022-10-19 12:00:00	QQQ	ETF	271.7	271.86	270.3	270.4855	1840598.0
2022-10-19 12:30:00	QQQ	ETF	270.48	271.21	269.4801	269.7499	2156397.0

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

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