PREVIEW / etf_30min / 2022-06-17

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-06-17.parquet
  size:    689 KB
  rows:    27,459

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-17 04:00:00	SPY	ETF	367.67	368.91	367.67	368.67	48277.0
2022-06-17 04:30:00	SPY	ETF	368.7	369.51	368.39	368.6	45938.0
2022-06-17 05:00:00	SPY	ETF	368.5	369.36	368.5	369.02	24340.0
2022-06-17 05:30:00	SPY	ETF	369.0	369.04	367.57	368.75	38338.0
2022-06-17 06:00:00	SPY	ETF	368.69	368.86	368.26	368.59	48219.0
2022-06-17 06:30:00	SPY	ETF	368.63	369.1	368.11	368.37	68718.0
2022-06-17 07:00:00	SPY	ETF	368.46	369.24	368.2	369.24	130765.0
2022-06-17 07:30:00	SPY	ETF	369.27	369.5	368.1	368.58	225744.0
2022-06-17 08:00:00	SPY	ETF	368.35	369.5	366.7	368.66	315323.0
2022-06-17 08:30:00	SPY	ETF	368.63	368.85	367.01	367.24	496569.0
2022-06-17 09:00:00	SPY	ETF	367.19	367.23	365.42	365.49	1236434.0
2022-06-17 09:30:00	SPY	ETF	365.48	369.38	365.43	368.39	7706813.0
2022-06-17 10:00:00	SPY	ETF	368.41	368.59	364.12	364.58	6213330.0
2022-06-17 10:30:00	SPY	ETF	364.57	364.95	362.17	363.54	6170044.0
2022-06-17 11:00:00	SPY	ETF	363.57	366.8108	362.8	366.45	5944466.0
2022-06-17 11:30:00	SPY	ETF	366.46	367.26	364.45	364.78	4253266.0
2022-06-17 12:00:00	SPY	ETF	364.81	366.02	364.03	365.78	2968932.0
2022-06-17 12:30:00	SPY	ETF	365.77	366.2306	364.97	365.71	2834199.0
2022-06-17 13:00:00	SPY	ETF	365.72	368.75	365.4526	367.23	4535571.0
2022-06-17 13:30:00	SPY	ETF	367.27	367.83	366.23	367.2599	3287202.0
2022-06-17 14:00:00	SPY	ETF	367.26	368.67	367.1	367.75	3652664.0
2022-06-17 14:30:00	SPY	ETF	367.75	369.0	366.98	367.46	3767535.0
2022-06-17 15:00:00	SPY	ETF	367.48	368.2299	365.65	367.94	6019419.0
2022-06-17 15:30:00	SPY	ETF	367.955	368.06	365.68	365.84	12076060.0
2022-06-17 16:00:00	SPY	ETF	365.84	367.0	365.71	366.71	5404025.0
2022-06-17 16:30:00	SPY	ETF	366.67	366.94	366.41	366.59	290929.0
2022-06-17 17:00:00	SPY	ETF	366.38	366.99	365.5	366.15	231879.0
2022-06-17 17:30:00	SPY	ETF	366.2	366.4	365.86	366.2301	102127.0
2022-06-17 18:00:00	SPY	ETF	366.24	366.45	366.24	366.43	15247.0
2022-06-17 18:30:00	SPY	ETF	366.45	366.72	366.45	366.52	11016.0
2022-06-17 19:00:00	SPY	ETF	366.52	366.68	366.45	366.45	3047.0
2022-06-17 19:30:00	SPY	ETF	366.5	366.59	366.21	366.33	5623.0
2022-06-17 04:00:00	QQQ	ETF	273.06	274.3	272.76	274.2	129345.0
2022-06-17 04:30:00	QQQ	ETF	274.32	274.88	273.65	274.0	62429.0
2022-06-17 05:00:00	QQQ	ETF	273.9	274.67	273.9	274.61	26162.0
2022-06-17 05:30:00	QQQ	ETF	274.5	274.75	273.7	274.49	40303.0
2022-06-17 06:00:00	QQQ	ETF	274.45	274.61	274.06	274.43	66727.0
2022-06-17 06:30:00	QQQ	ETF	274.36	275.1	274.22	274.56	150658.0
2022-06-17 07:00:00	QQQ	ETF	274.53	275.18	274.35	275.12	140689.0
2022-06-17 07:30:00	QQQ	ETF	275.14	275.35	274.23	274.6	288458.0
2022-06-17 08:00:00	QQQ	ETF	274.5	275.35	272.3	274.47	327745.0
2022-06-17 08:30:00	QQQ	ETF	274.45	274.61	273.15	273.41	440785.0
2022-06-17 09:00:00	QQQ	ETF	273.32	273.32	271.63	272.23	1267417.0
2022-06-17 09:30:00	QQQ	ETF	272.15	276.06	272.03	275.18	6911455.0
2022-06-17 10:00:00	QQQ	ETF	275.24	275.37	272.02	272.47	4536945.0
2022-06-17 10:30:00	QQQ	ETF	272.44	272.75	270.5119	271.77	4273221.0
2022-06-17 11:00:00	QQQ	ETF	271.77	274.919	270.94	274.7	4496130.0
2022-06-17 11:30:00	QQQ	ETF	274.7	275.28	272.85	273.2997	2480388.0
2022-06-17 12:00:00	QQQ	ETF	273.29	274.29	272.62	274.05	2093208.0
2022-06-17 12:30:00	QQQ	ETF	274.07	275.1101	273.62	274.6554	2195313.0

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

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