PREVIEW / etf_30min / 2022-11-01

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-11-01.parquet
  size:    678 KB
  rows:    27,794

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-11-01 04:00:00	SPY	ETF	388.37	389.76	388.01	389.49	62631.0
2022-11-01 04:30:00	SPY	ETF	389.64	389.64	389.22	389.22	13772.0
2022-11-01 05:00:00	SPY	ETF	389.2	389.2	388.68	389.04	58904.0
2022-11-01 05:30:00	SPY	ETF	388.94	389.62	388.94	389.51	12433.0
2022-11-01 06:00:00	SPY	ETF	389.63	390.02	389.35	389.81	39855.0
2022-11-01 06:30:00	SPY	ETF	389.82	390.15	389.77	390.04	45591.0
2022-11-01 07:00:00	SPY	ETF	389.86	390.14	389.45	389.82	125936.0
2022-11-01 07:30:00	SPY	ETF	389.81	390.18	389.73	389.98	124600.0
2022-11-01 08:00:00	SPY	ETF	389.5625	390.61	387.6	390.31	467005.0
2022-11-01 08:30:00	SPY	ETF	390.468	390.73	390.34	390.35	162929.0
2022-11-01 09:00:00	SPY	ETF	390.36	390.45	389.82	390.14	586574.0
2022-11-01 09:30:00	SPY	ETF	390.14	390.39	387.74	388.0407	7469144.0
2022-11-01 10:00:00	SPY	ETF	388.12	388.4	384.95	386.35	8912518.0
2022-11-01 10:30:00	SPY	ETF	386.38	386.66	383.58	384.01	5376448.0
2022-11-01 11:00:00	SPY	ETF	384.01	384.75	383.65	384.4832	3659746.0
2022-11-01 11:30:00	SPY	ETF	384.4823	384.82	383.29	384.54	4147651.0
2022-11-01 12:00:00	SPY	ETF	384.5299	386.02	384.24	384.4769	4395574.0
2022-11-01 12:30:00	SPY	ETF	384.46	384.91	383.97	384.73	2465534.0
2022-11-01 13:00:00	SPY	ETF	384.73	385.45	384.31	384.88	2680438.0
2022-11-01 13:30:00	SPY	ETF	384.87	385.09	384.27	385.09	1874489.0
2022-11-01 14:00:00	SPY	ETF	385.08	385.2399	384.6	385.05	2419430.0
2022-11-01 14:30:00	SPY	ETF	385.04	385.55	384.2701	385.3899	2884200.0
2022-11-01 15:00:00	SPY	ETF	385.39	385.8	384.7	384.79	3375454.0
2022-11-01 15:30:00	SPY	ETF	384.795	385.52	384.48	384.53	8621531.0
2022-11-01 16:00:00	SPY	ETF	384.53	384.89	383.6	383.97	4532516.0
2022-11-01 16:30:00	SPY	ETF	383.98	384.52	383.95	384.23	303335.0
2022-11-01 17:00:00	SPY	ETF	384.2	384.52	384.12	384.3	38249.0
2022-11-01 17:30:00	SPY	ETF	384.28	384.28	384.161	384.161	5415.0
2022-11-01 18:00:00	SPY	ETF	384.22	384.65	384.22	384.55	64892.0
2022-11-01 18:30:00	SPY	ETF	384.53	384.63	384.51	384.6	4250.0
2022-11-01 19:00:00	SPY	ETF	384.62	384.83	384.56	384.83	87900.0
2022-11-01 19:30:00	SPY	ETF	384.79	384.87	384.36	384.49	54397.0
2022-11-01 04:00:00	QQQ	ETF	279.68	280.96	279.68	280.79	47472.0
2022-11-01 04:30:00	QQQ	ETF	280.75	280.88	280.47	280.5	16883.0
2022-11-01 05:00:00	QQQ	ETF	280.46	280.46	280.09	280.46	16863.0
2022-11-01 05:30:00	QQQ	ETF	280.41	280.94	280.39	280.93	20693.0
2022-11-01 06:00:00	QQQ	ETF	280.93	281.38	280.66	281.27	32855.0
2022-11-01 06:30:00	QQQ	ETF	281.15	281.43	281.13	281.23	46843.0
2022-11-01 07:00:00	QQQ	ETF	281.16	281.44	280.85	281.13	100083.0
2022-11-01 07:30:00	QQQ	ETF	281.16	281.37	281.0	281.28	148774.0
2022-11-01 08:00:00	QQQ	ETF	281.29	281.77	278.158	281.68	249669.0
2022-11-01 08:30:00	QQQ	ETF	281.69	281.93	281.6	281.64	183002.0
2022-11-01 09:00:00	QQQ	ETF	281.66	281.75	281.21	281.48	261285.0
2022-11-01 09:30:00	QQQ	ETF	281.495	282.07	279.18	279.51	5427982.0
2022-11-01 10:00:00	QQQ	ETF	279.53	279.83	276.19	277.74	7040468.0
2022-11-01 10:30:00	QQQ	ETF	277.75	277.8802	275.41	275.77	3857824.0
2022-11-01 11:00:00	QQQ	ETF	275.78	276.69	275.6	276.35	2271861.0
2022-11-01 11:30:00	QQQ	ETF	276.35	276.6	275.0	275.91	2082484.0
2022-11-01 12:00:00	QQQ	ETF	275.9	277.04	275.28	275.4	2514698.0
2022-11-01 12:30:00	QQQ	ETF	275.38	275.74	274.74	275.6999	1599512.0

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

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