PREVIEW / etf_30min / 2021-10-13

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-10-13.parquet
  size:    618 KB
  rows:    23,599

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-10-13 04:00:00	SPY	ETF	433.52	434.36	433.52	434.26	15044.0
2021-10-13 04:30:00	SPY	ETF	434.25	434.99	434.2	434.62	17013.0
2021-10-13 05:00:00	SPY	ETF	434.55	434.6	434.36	434.45	18545.0
2021-10-13 05:30:00	SPY	ETF	434.63	434.72	434.55	434.55	20470.0
2021-10-13 06:00:00	SPY	ETF	434.71	434.96	434.5	434.55	8929.0
2021-10-13 06:30:00	SPY	ETF	434.52	434.65	434.2	434.2	30661.0
2021-10-13 07:00:00	SPY	ETF	434.28	434.52	433.93	434.52	195860.0
2021-10-13 07:30:00	SPY	ETF	434.56	434.74	434.36	434.51	129347.0
2021-10-13 08:00:00	SPY	ETF	434.53	434.83	433.2	434.4	191888.0
2021-10-13 08:30:00	SPY	ETF	434.25	435.09	433.0	433.52	787200.0
2021-10-13 09:00:00	SPY	ETF	433.5	434.88	433.36	434.67	534813.0
2021-10-13 09:30:00	SPY	ETF	434.71	435.3	432.71	433.09	7795842.0
2021-10-13 10:00:00	SPY	ETF	433.11	433.27	431.54	431.96	6062515.0
2021-10-13 10:30:00	SPY	ETF	431.96	433.44	431.76	432.74	3975470.0
2021-10-13 11:00:00	SPY	ETF	432.74	433.42	432.62	432.91	2937426.0
2021-10-13 11:30:00	SPY	ETF	432.91	434.25	432.31	433.62	3445746.0
2021-10-13 12:00:00	SPY	ETF	433.63	433.96	433.35	433.92	1786280.0
2021-10-13 12:30:00	SPY	ETF	433.92	434.13	433.32	433.6605	1878149.0
2021-10-13 13:00:00	SPY	ETF	433.67	434.6999	433.53	434.6564	2066728.0
2021-10-13 13:30:00	SPY	ETF	434.65	435.22	434.59	434.76	2571715.0
2021-10-13 14:00:00	SPY	ETF	434.76	436.05	434.13	434.67	5414075.0
2021-10-13 14:30:00	SPY	ETF	434.66	434.87	433.94	434.48	2673302.0
2021-10-13 15:00:00	SPY	ETF	434.48	435.16	434.12	434.44	3166855.0
2021-10-13 15:30:00	SPY	ETF	434.45	435.37	434.43	435.13	7807681.0
2021-10-13 16:00:00	SPY	ETF	435.13	435.28	434.5	435.06	2180264.0
2021-10-13 16:30:00	SPY	ETF	435.07	435.14	434.98	435.12	136953.0
2021-10-13 17:00:00	SPY	ETF	435.12	435.24	435.02	435.09	30983.0
2021-10-13 17:30:00	SPY	ETF	435.09	435.13	435.05	435.13	13208.0
2021-10-13 18:00:00	SPY	ETF	435.1	435.7	435.1	435.68	59137.0
2021-10-13 18:30:00	SPY	ETF	435.18	435.88	435.18	435.63	34749.0
2021-10-13 19:00:00	SPY	ETF	435.74	435.82	435.55	435.6799	12234.0
2021-10-13 19:30:00	SPY	ETF	435.65	436.01	435.6	435.86	36443.0
2021-10-13 04:00:00	QQQ	ETF	357.74	358.37	357.49	358.36	38397.0
2021-10-13 04:30:00	QQQ	ETF	358.36	359.1	358.1	358.67	33925.0
2021-10-13 05:00:00	QQQ	ETF	358.65	358.94	358.47	358.78	15724.0
2021-10-13 05:30:00	QQQ	ETF	358.81	359.09	358.79	358.79	22002.0
2021-10-13 06:00:00	QQQ	ETF	358.9	359.45	358.75	358.96	24732.0
2021-10-13 06:30:00	QQQ	ETF	358.93	359.03	358.67	358.71	27303.0
2021-10-13 07:00:00	QQQ	ETF	358.71	358.75	358.13	358.72	111922.0
2021-10-13 07:30:00	QQQ	ETF	358.74	358.95	358.63	358.67	145409.0
2021-10-13 08:00:00	QQQ	ETF	358.56	359.06	356.3	358.8	162495.0
2021-10-13 08:30:00	QQQ	ETF	358.66	359.31	357.15	357.94	529164.0
2021-10-13 09:00:00	QQQ	ETF	357.94	359.69	357.77	359.49	393071.0
2021-10-13 09:30:00	QQQ	ETF	359.49	360.2899	358.22	358.73	5153712.0
2021-10-13 10:00:00	QQQ	ETF	358.75	359.33	357.59	357.91	3453038.0
2021-10-13 10:30:00	QQQ	ETF	357.92	359.14	357.61	358.32	2340313.0
2021-10-13 11:00:00	QQQ	ETF	358.32	358.96	358.15	358.39	1227858.0
2021-10-13 11:30:00	QQQ	ETF	358.38	359.33	357.43	359.01	2268296.0
2021-10-13 12:00:00	QQQ	ETF	359.02	359.09	358.46	359.0824	924080.0
2021-10-13 12:30:00	QQQ	ETF	359.06	359.06	358.32	358.52	1080279.0

> showing 50 of 23,599 rows — these rows as CSV

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