PREVIEW / etf_30min / 2023-09-27

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-09-27.parquet
  size:    717 KB
  rows:    28,881

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
2023-09-27 04:00:00	SPY	ETF	428.0	428.1	427.41	427.78	18055.0
2023-09-27 04:30:00	SPY	ETF	427.8	427.98	427.72	427.76	10165.0
2023-09-27 05:00:00	SPY	ETF	427.89	427.94	427.69	427.81	27625.0
2023-09-27 05:30:00	SPY	ETF	427.8	427.8	427.23	427.4	12603.0
2023-09-27 06:00:00	SPY	ETF	427.38	427.42	427.2	427.42	16552.0
2023-09-27 06:30:00	SPY	ETF	427.4	427.54	427.16	427.52	27707.0
2023-09-27 07:00:00	SPY	ETF	427.46	427.84	427.27	427.79	134284.0
2023-09-27 07:30:00	SPY	ETF	427.83	427.83	427.12	427.69	128495.0
2023-09-27 08:00:00	SPY	ETF	427.41	428.0696	426.87	427.18	314324.0
2023-09-27 08:30:00	SPY	ETF	427.19	427.8	426.9	427.73	334412.0
2023-09-27 09:00:00	SPY	ETF	427.68	427.94	427.05	427.05	509411.0
2023-09-27 09:30:00	SPY	ETF	427.09	427.67	426.64	426.88	5075380.0
2023-09-27 10:00:00	SPY	ETF	426.905	427.119	425.8501	426.83	6013543.0
2023-09-27 10:30:00	SPY	ETF	426.82	426.93	425.01	425.16	5065945.0
2023-09-27 11:00:00	SPY	ETF	425.17	426.06	425.045	425.96	4097778.0
2023-09-27 11:30:00	SPY	ETF	425.97	426.12	424.59	424.8809	4237591.0
2023-09-27 12:00:00	SPY	ETF	424.88	424.89	423.76	424.1999	4914364.0
2023-09-27 12:30:00	SPY	ETF	424.2	424.88	423.97	424.07	3943705.0
2023-09-27 13:00:00	SPY	ETF	424.0699	424.68	422.76	422.8094	4480935.0
2023-09-27 13:30:00	SPY	ETF	422.8	423.335	422.29	423.31	5261714.0
2023-09-27 14:00:00	SPY	ETF	423.309	424.4399	422.605	424.38	5028944.0
2023-09-27 14:30:00	SPY	ETF	424.385	426.33	424.37	425.88	8205671.0
2023-09-27 15:00:00	SPY	ETF	425.885	427.539	425.69	426.5	8145543.0
2023-09-27 15:30:00	SPY	ETF	426.52	426.61	424.855	426.02	12152313.0
2023-09-27 16:00:00	SPY	ETF	426.02	427.0	425.11	426.55	3414440.0
2023-09-27 16:30:00	SPY	ETF	426.55	426.85	426.55	426.67	217717.0
2023-09-27 17:00:00	SPY	ETF	426.8	426.89	426.62	426.82	84398.0
2023-09-27 17:30:00	SPY	ETF	426.8	426.88	426.77	426.87	7655.0
2023-09-27 18:00:00	SPY	ETF	426.85	426.89	426.06	426.18	100404.0
2023-09-27 18:30:00	SPY	ETF	426.16	426.38	426.15	426.36	29519.0
2023-09-27 19:00:00	SPY	ETF	426.36	426.53	426.24	426.49	17645.0
2023-09-27 19:30:00	SPY	ETF	426.48	426.73	426.47	426.66	36967.0
2023-09-27 04:00:00	QQQ	ETF	356.29	356.35	355.37	355.98	69393.0
2023-09-27 04:30:00	QQQ	ETF	355.99	356.21	355.9	356.04	16017.0
2023-09-27 05:00:00	QQQ	ETF	355.98	356.01	355.75	355.96	22169.0
2023-09-27 05:30:00	QQQ	ETF	355.92	355.97	355.41	355.59	15704.0
2023-09-27 06:00:00	QQQ	ETF	355.54	355.67	355.2	355.67	14285.0
2023-09-27 06:30:00	QQQ	ETF	355.65	355.72	355.31	355.58	18760.0
2023-09-27 07:00:00	QQQ	ETF	355.65	355.93	355.52	355.93	47194.0
2023-09-27 07:30:00	QQQ	ETF	355.94	355.94	355.26	355.75	37575.0
2023-09-27 08:00:00	QQQ	ETF	355.16	356.3296	354.475	355.28	115168.0
2023-09-27 08:30:00	QQQ	ETF	355.16	355.9	354.88	355.8	193364.0
2023-09-27 09:00:00	QQQ	ETF	355.71	355.99	355.29	355.38	233293.0
2023-09-27 09:30:00	QQQ	ETF	355.38	356.63	355.28	355.61	3409465.0
2023-09-27 10:00:00	QQQ	ETF	355.64	355.859	354.23	355.61	4246011.0
2023-09-27 10:30:00	QQQ	ETF	355.58	355.81	353.67	353.82	3194496.0
2023-09-27 11:00:00	QQQ	ETF	353.84	355.1297	353.75	355.0062	2290592.0
2023-09-27 11:30:00	QQQ	ETF	355.03	355.07	353.43	353.69	2066145.0
2023-09-27 12:00:00	QQQ	ETF	353.69	353.7	352.73	353.19	2281281.0
2023-09-27 12:30:00	QQQ	ETF	353.19	353.7	352.92	353.044	1855323.0

> showing 50 of 28,881 rows — these rows as CSV

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