PREVIEW / etf_30min / 2022-08-12

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-08-12.parquet
  size:    654 KB
  rows:    25,518

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-08-12 04:00:00	SPY	ETF	422.0	422.35	422.0	422.34	20457.0
2022-08-12 04:30:00	SPY	ETF	422.37	422.64	422.03	422.03	13086.0
2022-08-12 05:00:00	SPY	ETF	422.12	422.2	422.0	422.0	4665.0
2022-08-12 05:30:00	SPY	ETF	421.96	422.45	421.96	422.33	16487.0
2022-08-12 06:00:00	SPY	ETF	422.2	422.2	421.42	421.62	39277.0
2022-08-12 06:30:00	SPY	ETF	421.65	421.75	421.47	421.6	12432.0
2022-08-12 07:00:00	SPY	ETF	421.51	421.56	420.96	421.33	93576.0
2022-08-12 07:30:00	SPY	ETF	421.29	421.61	421.2	421.43	171940.0
2022-08-12 08:00:00	SPY	ETF	421.46	422.5304	420.71	421.8	191066.0
2022-08-12 08:30:00	SPY	ETF	421.8	422.14	421.67	422.05	84969.0
2022-08-12 09:00:00	SPY	ETF	422.11	422.51	421.96	422.04	152773.0
2022-08-12 09:30:00	SPY	ETF	422.03	422.89	421.4585	422.6	3762601.0
2022-08-12 10:00:00	SPY	ETF	422.58	422.91	421.03	422.52	4233964.0
2022-08-12 10:30:00	SPY	ETF	422.53	422.79	421.71	422.449	2337342.0
2022-08-12 11:00:00	SPY	ETF	422.45	423.75	422.32	423.41	2772730.0
2022-08-12 11:30:00	SPY	ETF	423.42	423.83	423.28	423.42	1770581.0
2022-08-12 12:00:00	SPY	ETF	423.42	424.28	423.38	424.2201	1623611.0
2022-08-12 12:30:00	SPY	ETF	424.25	424.34	424.01	424.18	1719413.0
2022-08-12 13:00:00	SPY	ETF	424.18	424.67	424.0601	424.58	1585865.0
2022-08-12 13:30:00	SPY	ETF	424.58	425.03	424.47	424.81	1384702.0
2022-08-12 14:00:00	SPY	ETF	424.82	425.24	424.7	425.1899	1494250.0
2022-08-12 14:30:00	SPY	ETF	425.1801	425.81	425.17	425.72	2552166.0
2022-08-12 15:00:00	SPY	ETF	425.715	426.5499	425.59	426.33	3672611.0
2022-08-12 15:30:00	SPY	ETF	426.33	427.21	426.11	427.06	11484193.0
2022-08-12 16:00:00	SPY	ETF	427.06	427.1511	426.68	426.89	3645671.0
2022-08-12 16:30:00	SPY	ETF	426.91	427.09	426.85	427.03	96913.0
2022-08-12 17:00:00	SPY	ETF	427.03	427.15	426.99	427.15	65145.0
2022-08-12 17:30:00	SPY	ETF	427.15	427.15	426.76	426.8	30535.0
2022-08-12 18:00:00	SPY	ETF	426.92	426.98	426.73	426.95	9538.0
2022-08-12 18:30:00	SPY	ETF	426.99	426.99	426.85	426.95	3171.0
2022-08-12 19:00:00	SPY	ETF	426.99	427.1	426.9	426.95	13946.0
2022-08-12 19:30:00	SPY	ETF	426.95	427.19	426.95	427.19	6736.0
2022-08-12 04:00:00	QQQ	ETF	325.42	326.09	325.42	326.03	25998.0
2022-08-12 04:30:00	QQQ	ETF	326.21	326.28	325.69	325.69	16603.0
2022-08-12 05:00:00	QQQ	ETF	325.8	325.95	325.62	325.78	13035.0
2022-08-12 05:30:00	QQQ	ETF	325.76	326.28	325.71	325.99	32220.0
2022-08-12 06:00:00	QQQ	ETF	325.96	325.96	325.38	325.52	30456.0
2022-08-12 06:30:00	QQQ	ETF	325.58	325.75	325.35	325.36	25530.0
2022-08-12 07:00:00	QQQ	ETF	325.34	325.34	324.77	325.0	86650.0
2022-08-12 07:30:00	QQQ	ETF	324.98	325.65	324.91	325.22	122461.0
2022-08-12 08:00:00	QQQ	ETF	325.12	326.0204	324.323	325.58	208884.0
2022-08-12 08:30:00	QQQ	ETF	325.58	325.95	325.5	325.92	92215.0
2022-08-12 09:00:00	QQQ	ETF	325.92	326.51	325.77	326.16	306245.0
2022-08-12 09:30:00	QQQ	ETF	326.175	326.96	325.1001	326.7009	3999192.0
2022-08-12 10:00:00	QQQ	ETF	326.69	327.6	325.2356	326.94	3395228.0
2022-08-12 10:30:00	QQQ	ETF	326.96	327.2	325.72	326.8701	1927456.0
2022-08-12 11:00:00	QQQ	ETF	326.88	328.11	326.73	327.765	2162025.0
2022-08-12 11:30:00	QQQ	ETF	327.78	328.25	327.42	327.46	1255130.0
2022-08-12 12:00:00	QQQ	ETF	327.47	328.48	327.4	328.425	1258297.0
2022-08-12 12:30:00	QQQ	ETF	328.455	328.5	327.9401	328.055	931227.0

> showing 50 of 25,518 rows — these rows as CSV

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