PREVIEW / etf_30min / 2022-10-28

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-10-28.parquet
  size:    674 KB
  rows:    26,894

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-28 04:00:00	SPY	ETF	376.33	377.16	376.0	376.95	37429.0
2022-10-28 04:30:00	SPY	ETF	377.09	377.5	376.73	377.23	12537.0
2022-10-28 05:00:00	SPY	ETF	377.19	377.35	376.5	377.29	12099.0
2022-10-28 05:30:00	SPY	ETF	377.2	377.69	376.62	377.65	79090.0
2022-10-28 06:00:00	SPY	ETF	377.65	377.71	377.22	377.54	38712.0
2022-10-28 06:30:00	SPY	ETF	377.43	377.97	377.31	377.68	35485.0
2022-10-28 07:00:00	SPY	ETF	377.82	378.42	377.16	378.39	114681.0
2022-10-28 07:30:00	SPY	ETF	378.39	378.571	378.01	378.1	164255.0
2022-10-28 08:00:00	SPY	ETF	377.82	378.58	376.0	377.64	597877.0
2022-10-28 08:30:00	SPY	ETF	377.8	380.78	376.85	378.67	1237226.0
2022-10-28 09:00:00	SPY	ETF	378.67	380.34	378.42	379.88	675257.0
2022-10-28 09:30:00	SPY	ETF	379.88	383.36	379.68	382.52	7849401.0
2022-10-28 10:00:00	SPY	ETF	382.57	384.37	380.96	383.98	6776539.0
2022-10-28 10:30:00	SPY	ETF	383.98	385.8349	383.78	385.719	4974838.0
2022-10-28 11:00:00	SPY	ETF	385.72	386.2872	385.05	385.26	4455480.0
2022-10-28 11:30:00	SPY	ETF	385.26	386.25	384.85	385.77	3188155.0
2022-10-28 12:00:00	SPY	ETF	385.76	387.08	385.01	387.01	3405794.0
2022-10-28 12:30:00	SPY	ETF	387.03	387.42	386.44	387.1481	3383238.0
2022-10-28 13:00:00	SPY	ETF	387.16	387.78	387.04	387.39	2974182.0
2022-10-28 13:30:00	SPY	ETF	387.4	388.08	387.4	387.52	2727225.0
2022-10-28 14:00:00	SPY	ETF	387.52	388.06	387.21	387.79	2987052.0
2022-10-28 14:30:00	SPY	ETF	387.8	389.04	387.71	388.845	4111440.0
2022-10-28 15:00:00	SPY	ETF	388.86	389.24	388.21	389.0	3871562.0
2022-10-28 15:30:00	SPY	ETF	389.015	389.52	388.63	388.97	10592835.0
2022-10-28 16:00:00	SPY	ETF	388.97	390.14	388.9	390.0999	5311253.0
2022-10-28 16:30:00	SPY	ETF	390.1	390.28	390.03	390.15	270605.0
2022-10-28 17:00:00	SPY	ETF	390.12	390.2	389.98	390.12	77574.0
2022-10-28 17:30:00	SPY	ETF	390.1	390.1	389.7	389.7	50630.0
2022-10-28 18:00:00	SPY	ETF	389.71	389.88	389.63	389.7	23250.0
2022-10-28 18:30:00	SPY	ETF	389.8	390.07	389.65	389.9	34654.0
2022-10-28 19:00:00	SPY	ETF	389.99	390.05	389.82	389.82	7080.0
2022-10-28 19:30:00	SPY	ETF	389.88	390.23	389.5	390.2	27188.0
2022-10-28 04:00:00	QQQ	ETF	269.39	269.69	268.66	269.35	35401.0
2022-10-28 04:30:00	QQQ	ETF	269.31	269.9	269.31	269.75	15073.0
2022-10-28 05:00:00	QQQ	ETF	269.72	269.72	268.93	269.32	22026.0
2022-10-28 05:30:00	QQQ	ETF	269.31	269.85	268.94	269.85	23366.0
2022-10-28 06:00:00	QQQ	ETF	269.9	269.9	269.54	269.83	27275.0
2022-10-28 06:30:00	QQQ	ETF	269.68	270.17	269.64	269.95	52837.0
2022-10-28 07:00:00	QQQ	ETF	269.9	270.6	269.5	270.6	111586.0
2022-10-28 07:30:00	QQQ	ETF	270.6	270.77	270.18	270.24	187611.0
2022-10-28 08:00:00	QQQ	ETF	270.1	273.074	268.6704	269.71	359642.0
2022-10-28 08:30:00	QQQ	ETF	269.61	272.34	268.74	270.68	1187050.0
2022-10-28 09:00:00	QQQ	ETF	270.71	272.46	270.41	272.2	607085.0
2022-10-28 09:30:00	QQQ	ETF	272.23	275.88	272.06	274.8	7730905.0
2022-10-28 10:00:00	QQQ	ETF	274.83	276.73	273.275	276.27	5709352.0
2022-10-28 10:30:00	QQQ	ETF	276.3	278.47	276.21	278.22	4564383.0
2022-10-28 11:00:00	QQQ	ETF	278.23	279.0697	277.77	278.025	3086312.0
2022-10-28 11:30:00	QQQ	ETF	278.02	278.99	277.69	278.15	1995622.0
2022-10-28 12:00:00	QQQ	ETF	278.16	279.42	277.56	279.4063	2342998.0
2022-10-28 12:30:00	QQQ	ETF	279.41	279.87	278.7501	279.59	2408826.0

> showing 50 of 26,894 rows — these rows as CSV

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