PREVIEW / etf_30min / 2023-10-11

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-10-11.parquet
  size:    716 KB
  rows:    28,395

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-10-11 04:00:00	SPY	ETF	434.86	435.12	434.58	434.58	14046.0
2023-10-11 04:30:00	SPY	ETF	434.58	435.35	434.58	435.23	15510.0
2023-10-11 05:00:00	SPY	ETF	435.17	435.36	435.04	435.12	7301.0
2023-10-11 05:30:00	SPY	ETF	435.13	435.55	435.13	435.46	14664.0
2023-10-11 06:00:00	SPY	ETF	435.56	435.6	435.3	435.46	65018.0
2023-10-11 06:30:00	SPY	ETF	435.55	435.69	435.42	435.64	11244.0
2023-10-11 07:00:00	SPY	ETF	435.6	436.08	435.59	436.08	192918.0
2023-10-11 07:30:00	SPY	ETF	436.05	436.28	435.76	435.9	248322.0
2023-10-11 08:00:00	SPY	ETF	436.0	436.1	434.39	435.85	246517.0
2023-10-11 08:30:00	SPY	ETF	435.88	436.16	434.86	436.14	718487.0
2023-10-11 09:00:00	SPY	ETF	436.15	436.37	435.4	435.66	448001.0
2023-10-11 09:30:00	SPY	ETF	435.65	436.46	435.3	435.52	5333906.0
2023-10-11 10:00:00	SPY	ETF	435.53	435.62	434.68	435.01	3565010.0
2023-10-11 10:30:00	SPY	ETF	435.025	435.6	434.51	435.505	3228002.0
2023-10-11 11:00:00	SPY	ETF	435.51	435.83	434.26	434.4401	3150618.0
2023-10-11 11:30:00	SPY	ETF	434.44	435.05	434.21	434.47	2661709.0
2023-10-11 12:00:00	SPY	ETF	434.46	434.5501	433.66	433.89	2793008.0
2023-10-11 12:30:00	SPY	ETF	433.9	434.3199	433.56	434.1571	2478548.0
2023-10-11 13:00:00	SPY	ETF	434.15	434.38	433.3601	433.7109	3116613.0
2023-10-11 13:30:00	SPY	ETF	433.7	433.97	433.18	433.8296	2187177.0
2023-10-11 14:00:00	SPY	ETF	433.83	435.3	433.8	434.63	3823039.0
2023-10-11 14:30:00	SPY	ETF	434.64	435.32	434.58	435.06	2920194.0
2023-10-11 15:00:00	SPY	ETF	435.05	435.57	434.92	435.42	2865736.0
2023-10-11 15:30:00	SPY	ETF	435.42	436.58	435.3	436.31	9243702.0
2023-10-11 16:00:00	SPY	ETF	436.31	437.25	435.107	437.11	2231118.0
2023-10-11 16:30:00	SPY	ETF	437.1299	437.34	437.09	437.3	322058.0
2023-10-11 17:00:00	SPY	ETF	437.29	437.33	436.3632	437.15	176657.0
2023-10-11 17:30:00	SPY	ETF	437.14	437.2	437.12	437.18	14246.0
2023-10-11 18:00:00	SPY	ETF	437.15	437.15	436.95	437.04	68118.0
2023-10-11 18:30:00	SPY	ETF	437.04	437.18	437.04	437.18	16232.0
2023-10-11 19:00:00	SPY	ETF	437.16	437.3	437.09	437.25	16573.0
2023-10-11 19:30:00	SPY	ETF	437.25	437.36	437.24	437.35	48256.0
2023-10-11 04:00:00	QQQ	ETF	369.23	369.45	368.75	368.78	22755.0
2023-10-11 04:30:00	QQQ	ETF	368.97	369.54	368.85	369.41	11737.0
2023-10-11 05:00:00	QQQ	ETF	369.35	369.55	369.12	369.12	10226.0
2023-10-11 05:30:00	QQQ	ETF	369.23	369.73	369.23	369.54	3686.0
2023-10-11 06:00:00	QQQ	ETF	369.66	369.77	369.38	369.58	11256.0
2023-10-11 06:30:00	QQQ	ETF	369.7	369.97	369.49	369.88	20086.0
2023-10-11 07:00:00	QQQ	ETF	369.87	370.3	369.87	370.19	75147.0
2023-10-11 07:30:00	QQQ	ETF	370.16	370.44	369.99	370.14	49939.0
2023-10-11 08:00:00	QQQ	ETF	370.3	370.44	368.83	370.12	145142.0
2023-10-11 08:30:00	QQQ	ETF	370.0	370.22	368.5	370.2	1075907.0
2023-10-11 09:00:00	QQQ	ETF	370.19	370.39	369.67	369.91	350060.0
2023-10-11 09:30:00	QQQ	ETF	369.94	371.412	369.74	370.05	4310398.0
2023-10-11 10:00:00	QQQ	ETF	370.06	370.15	369.35	369.73	2590439.0
2023-10-11 10:30:00	QQQ	ETF	369.75	370.91	369.34	370.7097	2454544.0
2023-10-11 11:00:00	QQQ	ETF	370.73	371.32	369.6201	369.6384	2048633.0
2023-10-11 11:30:00	QQQ	ETF	369.64	370.05	369.12	369.65	1603548.0
2023-10-11 12:00:00	QQQ	ETF	369.64	369.66	368.74	369.22	1842646.0
2023-10-11 12:30:00	QQQ	ETF	369.25	369.5725	368.75	369.42	1607143.0

> showing 50 of 28,395 rows — these rows as CSV

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