PREVIEW / etf_30min / 2021-07-09

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-07-09.parquet
  size:    596 KB
  rows:    22,841

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
2021-07-09 04:00:00	SPY	ETF	431.3	432.14	431.3	431.83	32951.0
2021-07-09 04:30:00	SPY	ETF	431.91	432.17	431.91	432.06	15170.0
2021-07-09 05:00:00	SPY	ETF	432.13	432.56	432.13	432.44	11463.0
2021-07-09 05:30:00	SPY	ETF	432.47	432.59	431.88	431.9	24608.0
2021-07-09 06:00:00	SPY	ETF	431.84	432.06	431.46	431.91	29745.0
2021-07-09 06:30:00	SPY	ETF	431.89	432.28	431.88	432.15	69286.0
2021-07-09 07:00:00	SPY	ETF	432.16	432.64	432.15	432.39	64147.0
2021-07-09 07:30:00	SPY	ETF	432.32	433.06	432.16	432.9	118623.0
2021-07-09 08:00:00	SPY	ETF	432.5701	433.0301	431.0	432.92	164293.0
2021-07-09 08:30:00	SPY	ETF	432.87	432.93	432.57	432.66	152779.0
2021-07-09 09:00:00	SPY	ETF	432.67	432.76	432.38	432.56	404542.0
2021-07-09 09:30:00	SPY	ETF	432.53	433.64	432.31	433.5802	5918263.0
2021-07-09 10:00:00	SPY	ETF	433.58	434.38	433.58	434.155	4994239.0
2021-07-09 10:30:00	SPY	ETF	434.15	434.44	433.92	434.08	3395445.0
2021-07-09 11:00:00	SPY	ETF	434.09	434.85	434.09	434.72	2974122.0
2021-07-09 11:30:00	SPY	ETF	434.73	435.22	434.64	434.72	3514796.0
2021-07-09 12:00:00	SPY	ETF	434.7399	434.95	434.58	434.64	2071672.0
2021-07-09 12:30:00	SPY	ETF	434.65	435.09	434.59	434.8311	2057532.0
2021-07-09 13:00:00	SPY	ETF	434.83	434.91	434.61	434.86	1775510.0
2021-07-09 13:30:00	SPY	ETF	434.8501	435.005	434.72	434.97	1375796.0
2021-07-09 14:00:00	SPY	ETF	434.96	435.21	434.96	435.16	1935941.0
2021-07-09 14:30:00	SPY	ETF	435.15	435.66	435.11	435.57	1989129.0
2021-07-09 15:00:00	SPY	ETF	435.58	435.71	435.39	435.54	3238352.0
2021-07-09 15:30:00	SPY	ETF	435.53	435.84	435.29	435.49	13487993.0
2021-07-09 16:00:00	SPY	ETF	435.49	435.59	435.3	435.59	4373720.0
2021-07-09 16:30:00	SPY	ETF	435.59	435.65	435.48	435.62	308685.0
2021-07-09 17:00:00	SPY	ETF	435.63	435.65	435.52	435.58	1407301.0
2021-07-09 17:30:00	SPY	ETF	435.62	435.62	435.56	435.6	12199.0
2021-07-09 18:00:00	SPY	ETF	435.56	435.62	435.56	435.6	23923.0
2021-07-09 18:30:00	SPY	ETF	435.6	435.6	435.56	435.59	2782.0
2021-07-09 19:00:00	SPY	ETF	435.59	435.6	435.57	435.58	26243.0
2021-07-09 19:30:00	SPY	ETF	435.5801	435.65	435.58	435.65	7932.0
2021-07-09 04:00:00	QQQ	ETF	358.77	359.3	358.76	358.9	45537.0
2021-07-09 04:30:00	QQQ	ETF	358.9	359.1	358.8	358.82	28013.0
2021-07-09 05:00:00	QQQ	ETF	359.0	359.22	358.83	359.14	13842.0
2021-07-09 05:30:00	QQQ	ETF	359.11	359.13	358.18	358.36	40217.0
2021-07-09 06:00:00	QQQ	ETF	358.23	358.27	357.57	358.06	187411.0
2021-07-09 06:30:00	QQQ	ETF	358.04	358.3	357.96	358.09	131137.0
2021-07-09 07:00:00	QQQ	ETF	358.14	358.73	358.14	358.54	159470.0
2021-07-09 07:30:00	QQQ	ETF	358.54	359.0	358.24	358.94	68689.0
2021-07-09 08:00:00	QQQ	ETF	359.0	359.47	357.75	358.92	222028.0
2021-07-09 08:30:00	QQQ	ETF	358.89	358.95	358.28	358.43	265126.0
2021-07-09 09:00:00	QQQ	ETF	358.41	358.48	358.0	358.17	340010.0
2021-07-09 09:30:00	QQQ	ETF	358.17	358.94	357.57	358.64	4998346.0
2021-07-09 10:00:00	QQQ	ETF	358.64	359.18	358.36	358.76	2370792.0
2021-07-09 10:30:00	QQQ	ETF	358.76	360.15	358.41	360.12	2309999.0
2021-07-09 11:00:00	QQQ	ETF	360.12	360.74	360.02	360.67	1660558.0
2021-07-09 11:30:00	QQQ	ETF	360.67	361.01	360.5	360.6899	1411784.0
2021-07-09 12:00:00	QQQ	ETF	360.7	361.07	360.69	360.96	1373585.0
2021-07-09 12:30:00	QQQ	ETF	360.97	361.5	360.89	361.19	1549789.0

> showing 50 of 22,841 rows — these rows as CSV

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