PREVIEW / etf_30min / 2023-01-10

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-01-10.parquet
  size:    678 KB
  rows:    26,861

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-01-10 04:00:00	SPY	ETF	387.86	387.86	386.91	387.33	19426.0
2023-01-10 04:30:00	SPY	ETF	387.28	387.73	387.28	387.67	27062.0
2023-01-10 05:00:00	SPY	ETF	387.82	387.83	387.4	387.62	8750.0
2023-01-10 05:30:00	SPY	ETF	387.76	387.95	387.63	387.63	14089.0
2023-01-10 06:00:00	SPY	ETF	387.63	387.63	386.9	387.09	20512.0
2023-01-10 06:30:00	SPY	ETF	387.1	387.1	386.5	386.76	93078.0
2023-01-10 07:00:00	SPY	ETF	386.71	386.75	385.81	386.29	344841.0
2023-01-10 07:30:00	SPY	ETF	386.28	386.31	385.74	386.28	128168.0
2023-01-10 08:00:00	SPY	ETF	386.25	387.7396	385.79	385.79	344557.0
2023-01-10 08:30:00	SPY	ETF	385.79	386.65	385.75	386.6	189675.0
2023-01-10 09:00:00	SPY	ETF	386.6	387.75	386.3	387.26	769837.0
2023-01-10 09:30:00	SPY	ETF	387.25	389.23	387.02	388.45	5101319.0
2023-01-10 10:00:00	SPY	ETF	388.46	389.99	387.84	388.255	4125420.0
2023-01-10 10:30:00	SPY	ETF	388.26	388.58	386.27	388.3701	4250691.0
2023-01-10 11:00:00	SPY	ETF	388.39	388.8	387.81	388.009	2095642.0
2023-01-10 11:30:00	SPY	ETF	387.98	388.41	387.35	388.12	2076777.0
2023-01-10 12:00:00	SPY	ETF	388.12	388.67	387.19	388.07	2199879.0
2023-01-10 12:30:00	SPY	ETF	388.04	389.1896	387.96	388.78	2034539.0
2023-01-10 13:00:00	SPY	ETF	388.78	389.39	388.53	388.93	2089023.0
2023-01-10 13:30:00	SPY	ETF	388.935	389.6101	388.81	389.52	2521455.0
2023-01-10 14:00:00	SPY	ETF	389.57	390.13	389.38	389.905	2601901.0
2023-01-10 14:30:00	SPY	ETF	389.91	390.22	389.24	389.49	2342065.0
2023-01-10 15:00:00	SPY	ETF	389.485	389.8	388.76	389.5	2825730.0
2023-01-10 15:30:00	SPY	ETF	389.5	390.65	389.29	390.63	7865567.0
2023-01-10 16:00:00	SPY	ETF	390.62	390.82	390.37	390.549	6779645.0
2023-01-10 16:30:00	SPY	ETF	390.52	390.7	390.5	390.62	100237.0
2023-01-10 17:00:00	SPY	ETF	390.69	390.69	390.53	390.54	20824.0
2023-01-10 17:30:00	SPY	ETF	390.54	390.72	390.54	390.65	37237.0
2023-01-10 18:00:00	SPY	ETF	390.65	390.69	390.37	390.63	73281.0
2023-01-10 18:30:00	SPY	ETF	390.6	390.77	390.48	390.7	23624.0
2023-01-10 19:00:00	SPY	ETF	390.75	391.15	390.73	390.9	105946.0
2023-01-10 19:30:00	SPY	ETF	390.93	391.07	390.79	391.07	94832.0
2023-01-10 04:00:00	QQQ	ETF	270.12	270.35	269.84	270.28	51173.0
2023-01-10 04:30:00	QQQ	ETF	270.22	270.57	270.19	270.54	16765.0
2023-01-10 05:00:00	QQQ	ETF	270.64	270.7	270.36	270.5	7654.0
2023-01-10 05:30:00	QQQ	ETF	270.62	270.99	270.62	270.92	9553.0
2023-01-10 06:00:00	QQQ	ETF	270.86	270.86	269.96	270.17	27184.0
2023-01-10 06:30:00	QQQ	ETF	270.17	270.17	269.4	269.6	111806.0
2023-01-10 07:00:00	QQQ	ETF	269.6	269.62	268.37	268.77	227046.0
2023-01-10 07:30:00	QQQ	ETF	268.75	268.93	268.4	268.85	68689.0
2023-01-10 08:00:00	QQQ	ETF	269.15	271.01	268.4	268.52	169845.0
2023-01-10 08:30:00	QQQ	ETF	268.51	269.16	268.4	269.08	191669.0
2023-01-10 09:00:00	QQQ	ETF	269.13	270.48	268.92	269.57	923226.0
2023-01-10 09:30:00	QQQ	ETF	269.53	272.02	269.38	271.145	4966221.0
2023-01-10 10:00:00	QQQ	ETF	271.14	272.888	270.46	271.07	2928553.0
2023-01-10 10:30:00	QQQ	ETF	271.06	271.34	268.97	271.055	3235581.0
2023-01-10 11:00:00	QQQ	ETF	271.055	271.45	270.6	270.74	1509185.0
2023-01-10 11:30:00	QQQ	ETF	270.73	270.96	270.1	270.66	1322886.0
2023-01-10 12:00:00	QQQ	ETF	270.64	271.2	269.84	270.749	1096591.0
2023-01-10 12:30:00	QQQ	ETF	270.73	271.6899	270.65	271.345	1011417.0

> showing 50 of 26,861 rows — these rows as CSV

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