PREVIEW / etf_30min / 2022-01-13

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-01-13.parquet
  size:    675 KB
  rows:    26,432

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-01-13 04:00:00	SPY	ETF	470.82	470.82	470.44	470.72	6235.0
2022-01-13 04:30:00	SPY	ETF	470.84	470.93	470.72	470.83	2065.0
2022-01-13 05:00:00	SPY	ETF	471.0	471.34	470.93	471.18	19705.0
2022-01-13 05:30:00	SPY	ETF	471.27	471.45	471.2	471.2	4978.0
2022-01-13 06:00:00	SPY	ETF	471.27	471.59	471.02	471.12	6096.0
2022-01-13 06:30:00	SPY	ETF	471.05	471.12	470.79	470.79	15760.0
2022-01-13 07:00:00	SPY	ETF	470.79	471.28	470.79	471.28	17943.0
2022-01-13 07:30:00	SPY	ETF	471.3	471.43	471.09	471.29	45883.0
2022-01-13 08:00:00	SPY	ETF	470.9504	471.44	470.0	471.38	86139.0
2022-01-13 08:30:00	SPY	ETF	471.41	472.14	471.29	471.99	276065.0
2022-01-13 09:00:00	SPY	ETF	471.98	472.34	471.97	472.17	117676.0
2022-01-13 09:30:00	SPY	ETF	472.21	472.88	471.75	472.36	4229686.0
2022-01-13 10:00:00	SPY	ETF	472.34	472.53	470.5099	471.14	3452306.0
2022-01-13 10:30:00	SPY	ETF	471.12	471.4097	469.18	469.9499	4515713.0
2022-01-13 11:00:00	SPY	ETF	469.91	471.08	469.44	470.96	3904154.0
2022-01-13 11:30:00	SPY	ETF	470.95	471.355	470.68	470.91	2433417.0
2022-01-13 12:00:00	SPY	ETF	470.9	470.905	467.2	467.72	4847253.0
2022-01-13 12:30:00	SPY	ETF	467.725	468.54	466.91	467.6201	4348551.0
2022-01-13 13:00:00	SPY	ETF	467.61	468.86	466.97	468.47	4104333.0
2022-01-13 13:30:00	SPY	ETF	468.46	468.71	467.8	468.6596	2255815.0
2022-01-13 14:00:00	SPY	ETF	468.66	469.2067	467.37	467.44	2731338.0
2022-01-13 14:30:00	SPY	ETF	467.4382	467.58	466.78	467.34	3713726.0
2022-01-13 15:00:00	SPY	ETF	467.34	467.38	465.545	466.25	5342556.0
2022-01-13 15:30:00	SPY	ETF	466.24	466.55	463.44	464.54	15838085.0
2022-01-13 16:00:00	SPY	ETF	464.54	467.392	463.93	464.0	5306505.0
2022-01-13 16:30:00	SPY	ETF	464.13	464.53	463.9	464.53	179432.0
2022-01-13 17:00:00	SPY	ETF	464.33	464.57	464.33	464.44	45623.0
2022-01-13 17:30:00	SPY	ETF	464.45	464.58	464.4	464.58	35091.0
2022-01-13 18:00:00	SPY	ETF	464.59	464.98	464.56	464.65	165765.0
2022-01-13 18:30:00	SPY	ETF	464.53	464.84	464.53	464.65	12564.0
2022-01-13 19:00:00	SPY	ETF	464.75	464.89	463.71	464.67	63661.0
2022-01-13 19:30:00	SPY	ETF	464.6	464.92	464.27	464.68	60529.0
2022-01-13 04:00:00	QQQ	ETF	387.34	387.34	386.71	387.2	18213.0
2022-01-13 04:30:00	QQQ	ETF	387.21	387.31	386.95	387.16	8509.0
2022-01-13 05:00:00	QQQ	ETF	387.39	387.93	387.35	387.82	34356.0
2022-01-13 05:30:00	QQQ	ETF	387.81	388.04	387.48	387.57	13655.0
2022-01-13 06:00:00	QQQ	ETF	387.71	387.85	387.15	387.15	18311.0
2022-01-13 06:30:00	QQQ	ETF	387.27	387.43	386.99	387.01	18515.0
2022-01-13 07:00:00	QQQ	ETF	387.0	387.61	387.0	387.59	43153.0
2022-01-13 07:30:00	QQQ	ETF	387.62	387.85	387.44	387.67	98820.0
2022-01-13 08:00:00	QQQ	ETF	387.68	387.8596	386.45	387.65	233014.0
2022-01-13 08:30:00	QQQ	ETF	387.58	388.8	387.51	388.52	560641.0
2022-01-13 09:00:00	QQQ	ETF	388.52	389.03	388.52	388.69	137689.0
2022-01-13 09:30:00	QQQ	ETF	388.75	389.47	387.88	388.48	5308674.0
2022-01-13 10:00:00	QQQ	ETF	388.47	388.67	385.84	386.74	5316828.0
2022-01-13 10:30:00	QQQ	ETF	386.7	386.94	383.29	384.19	5301443.0
2022-01-13 11:00:00	QQQ	ETF	384.18	385.46	383.35	385.3199	3929189.0
2022-01-13 11:30:00	QQQ	ETF	385.31	385.81	384.68	385.0662	2451902.0
2022-01-13 12:00:00	QQQ	ETF	385.06	385.06	380.71	380.9815	5973616.0
2022-01-13 12:30:00	QQQ	ETF	380.97	381.91	380.07	381.1	4130704.0

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

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