PREVIEW / etf_30min / 2022-10-27

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-10-27.parquet
  size:    680 KB
  rows:    27,437

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-27 04:00:00	SPY	ETF	382.8	383.76	382.55	383.38	46827.0
2022-10-27 04:30:00	SPY	ETF	383.3	383.58	383.02	383.2	21105.0
2022-10-27 05:00:00	SPY	ETF	383.01	383.09	382.5	382.75	83531.0
2022-10-27 05:30:00	SPY	ETF	382.78	382.78	382.11	382.13	17322.0
2022-10-27 06:00:00	SPY	ETF	382.11	382.45	382.0	382.12	21027.0
2022-10-27 06:30:00	SPY	ETF	382.08	382.48	381.7	381.73	58614.0
2022-10-27 07:00:00	SPY	ETF	381.83	382.58	381.79	382.45	103130.0
2022-10-27 07:30:00	SPY	ETF	382.38	382.44	381.43	381.66	92790.0
2022-10-27 08:00:00	SPY	ETF	381.83	384.12	381.34	382.34	444977.0
2022-10-27 08:30:00	SPY	ETF	382.34	384.21	382.0	383.5	944756.0
2022-10-27 09:00:00	SPY	ETF	383.54	384.5	382.92	383.06	475769.0
2022-10-27 09:30:00	SPY	ETF	383.08	384.33	380.52	381.2	6530566.0
2022-10-27 10:00:00	SPY	ETF	381.195	384.702	380.83	384.548	5583132.0
2022-10-27 10:30:00	SPY	ETF	384.54	385.0	382.13	382.19	4618248.0
2022-10-27 11:00:00	SPY	ETF	382.18	383.46	381.91	382.42	3647711.0
2022-10-27 11:30:00	SPY	ETF	382.43	382.95	380.89	381.35	3295717.0
2022-10-27 12:00:00	SPY	ETF	381.39	382.415	380.18	380.2	3727695.0
2022-10-27 12:30:00	SPY	ETF	380.17	381.68	380.13	381.54	2682009.0
2022-10-27 13:00:00	SPY	ETF	381.56	382.77	381.07	381.62	4238358.0
2022-10-27 13:30:00	SPY	ETF	381.63	381.81	380.7323	380.7801	2171978.0
2022-10-27 14:00:00	SPY	ETF	380.78	381.06	380.05	380.6	2926301.0
2022-10-27 14:30:00	SPY	ETF	380.6	380.76	379.81	380.13	3134708.0
2022-10-27 15:00:00	SPY	ETF	380.13	380.83	379.53	380.74	3836860.0
2022-10-27 15:30:00	SPY	ETF	380.74	381.33	379.33	379.96	7946372.0
2022-10-27 16:00:00	SPY	ETF	379.96	380.32	374.53	375.3	3800665.0
2022-10-27 16:30:00	SPY	ETF	375.3	377.82	373.8	377.13	1565413.0
2022-10-27 17:00:00	SPY	ETF	377.25	379.98	376.0	376.3	364490.0
2022-10-27 17:30:00	SPY	ETF	376.3	378.48	376.01	377.8	241907.0
2022-10-27 18:00:00	SPY	ETF	377.8	378.63	377.5	377.99	132983.0
2022-10-27 18:30:00	SPY	ETF	378.02	378.5	377.82	377.85	39570.0
2022-10-27 19:00:00	SPY	ETF	377.9	378.21	377.61	377.93	87419.0
2022-10-27 19:30:00	SPY	ETF	377.9	377.94	377.39	377.5	61130.0
2022-10-27 04:00:00	QQQ	ETF	277.77	278.3	277.33	277.97	94499.0
2022-10-27 04:30:00	QQQ	ETF	278.11	278.19	277.75	277.78	12226.0
2022-10-27 05:00:00	QQQ	ETF	277.72	277.72	276.91	277.04	49738.0
2022-10-27 05:30:00	QQQ	ETF	277.3	277.33	276.5	276.5	48793.0
2022-10-27 06:00:00	QQQ	ETF	276.57	276.92	276.41	276.52	26234.0
2022-10-27 06:30:00	QQQ	ETF	276.65	276.77	275.92	276.07	176285.0
2022-10-27 07:00:00	QQQ	ETF	276.07	276.9	275.96	276.8	226236.0
2022-10-27 07:30:00	QQQ	ETF	276.78	276.78	275.97	276.14	160703.0
2022-10-27 08:00:00	QQQ	ETF	276.01	279.2	275.65	276.25	498017.0
2022-10-27 08:30:00	QQQ	ETF	276.47	278.14	276.32	277.66	1016959.0
2022-10-27 09:00:00	QQQ	ETF	277.75	277.84	276.78	276.81	609312.0
2022-10-27 09:30:00	QQQ	ETF	276.79	278.2795	273.395	274.1	5942522.0
2022-10-27 10:00:00	QQQ	ETF	274.08	277.8599	273.7	277.485	4303634.0
2022-10-27 10:30:00	QQQ	ETF	277.47	277.99	274.75	274.79	3251410.0
2022-10-27 11:00:00	QQQ	ETF	274.785	276.23	274.58	275.08	2228083.0
2022-10-27 11:30:00	QQQ	ETF	275.09	275.89	273.91	274.06	2285223.0
2022-10-27 12:00:00	QQQ	ETF	274.0399	274.99	273.04	273.05	2455435.0
2022-10-27 12:30:00	QQQ	ETF	273.04	274.33	273.01	274.0	1861571.0

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

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