PREVIEW / etf_30min / 2022-05-09

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-05-09.parquet
  size:    733 KB
  rows:    29,493

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-05-09 04:00:00	SPY	ETF	406.64	407.7	405.7	405.9	58117.0
2022-05-09 04:30:00	SPY	ETF	405.8	406.2	404.73	405.86	64462.0
2022-05-09 05:00:00	SPY	ETF	405.88	406.39	405.29	405.3	32517.0
2022-05-09 05:30:00	SPY	ETF	405.3	405.49	404.62	405.2	55127.0
2022-05-09 06:00:00	SPY	ETF	405.16	405.16	404.22	404.5	91921.0
2022-05-09 06:30:00	SPY	ETF	404.52	404.52	402.92	403.25	231333.0
2022-05-09 07:00:00	SPY	ETF	403.39	404.09	402.75	402.9	228165.0
2022-05-09 07:30:00	SPY	ETF	402.89	404.79	402.69	404.54	349155.0
2022-05-09 08:00:00	SPY	ETF	403.4699	408.56	402.7299	404.07	502232.0
2022-05-09 08:30:00	SPY	ETF	404.07	405.7	403.8	405.1	458167.0
2022-05-09 09:00:00	SPY	ETF	405.12	406.25	404.8	405.04	700145.0
2022-05-09 09:30:00	SPY	ETF	405.1	406.41	403.27	405.2	13236516.0
2022-05-09 10:00:00	SPY	ETF	405.19	405.46	402.26	402.46	7996872.0
2022-05-09 10:30:00	SPY	ETF	402.45	403.13	400.72	400.9633	8088792.0
2022-05-09 11:00:00	SPY	ETF	400.96	401.81	399.9	400.125	7812711.0
2022-05-09 11:30:00	SPY	ETF	400.11	402.51	399.34	401.9	7653906.0
2022-05-09 12:00:00	SPY	ETF	401.91	404.15	400.64	403.2	6442690.0
2022-05-09 12:30:00	SPY	ETF	403.19	403.91	400.68	400.72	4560830.0
2022-05-09 13:00:00	SPY	ETF	400.72	401.82	400.101	401.58	4620556.0
2022-05-09 13:30:00	SPY	ETF	401.58	401.955	399.41	400.54	5840376.0
2022-05-09 14:00:00	SPY	ETF	400.5	401.56	399.612	400.1	4924393.0
2022-05-09 14:30:00	SPY	ETF	400.09	401.62	399.11	401.31	7365464.0
2022-05-09 15:00:00	SPY	ETF	401.31	402.58	399.24	399.69	8392518.0
2022-05-09 15:30:00	SPY	ETF	399.68	399.6812	396.5	398.24	20635914.0
2022-05-09 16:00:00	SPY	ETF	398.25	411.3491	398.08	398.69	6889913.0
2022-05-09 16:30:00	SPY	ETF	398.79	398.91	398.29	398.4	116945.0
2022-05-09 17:00:00	SPY	ETF	398.35	398.54	398.35	398.39	71887.0
2022-05-09 17:30:00	SPY	ETF	398.39	398.73	398.3	398.73	86577.0
2022-05-09 18:00:00	SPY	ETF	398.7	399.44	398.7	399.31	80224.0
2022-05-09 18:30:00	SPY	ETF	399.35	399.7	399.35	399.44	35367.0
2022-05-09 19:00:00	SPY	ETF	399.54	399.57	398.65	398.89	27124.0
2022-05-09 19:30:00	SPY	ETF	398.8504	399.57	398.8504	399.47	41568.0
2022-05-09 04:00:00	QQQ	ETF	305.58	306.66	304.6	304.84	121554.0
2022-05-09 04:30:00	QQQ	ETF	304.68	304.86	303.74	304.55	131436.0
2022-05-09 05:00:00	QQQ	ETF	304.55	305.08	304.0	304.13	35146.0
2022-05-09 05:30:00	QQQ	ETF	304.19	304.26	303.09	303.69	82434.0
2022-05-09 06:00:00	QQQ	ETF	303.6	303.84	302.98	303.2	138017.0
2022-05-09 06:30:00	QQQ	ETF	303.25	303.25	301.5	301.96	302298.0
2022-05-09 07:00:00	QQQ	ETF	301.97	302.57	300.96	301.19	359531.0
2022-05-09 07:30:00	QQQ	ETF	301.11	302.83	300.94	302.62	473999.0
2022-05-09 08:00:00	QQQ	ETF	302.58	309.481	300.98	302.31	667450.0
2022-05-09 08:30:00	QQQ	ETF	302.25	304.02	301.96	303.32	564465.0
2022-05-09 09:00:00	QQQ	ETF	303.33	304.04	302.9	303.48	492359.0
2022-05-09 09:30:00	QQQ	ETF	303.46	306.0	302.71	303.46	11747643.0
2022-05-09 10:00:00	QQQ	ETF	303.47	303.78	300.9	300.9302	6466520.0
2022-05-09 10:30:00	QQQ	ETF	300.9	301.6	299.58	299.83	6695092.0
2022-05-09 11:00:00	QQQ	ETF	299.83	300.54	298.93	299.17	5850918.0
2022-05-09 11:30:00	QQQ	ETF	299.15	301.19	298.25	300.38	5082442.0
2022-05-09 12:00:00	QQQ	ETF	300.37	302.65	299.11	301.7	4432997.0
2022-05-09 12:30:00	QQQ	ETF	301.61	302.39	299.43	299.49	3641673.0

> showing 50 of 29,493 rows — these rows as CSV

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