PREVIEW / etf_30min / 2022-01-12

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-01-12.parquet
  size:    673 KB
  rows:    26,581

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-12 04:00:00	SPY	ETF	469.0	470.11	468.91	470.01	18968.0
2022-01-12 04:30:00	SPY	ETF	470.18	470.36	469.76	470.31	5888.0
2022-01-12 05:00:00	SPY	ETF	470.4	470.4	469.93	470.19	21277.0
2022-01-12 05:30:00	SPY	ETF	470.25	470.49	469.92	470.42	6673.0
2022-01-12 06:00:00	SPY	ETF	470.55	470.65	470.29	470.29	11755.0
2022-01-12 06:30:00	SPY	ETF	470.33	470.56	470.17	470.17	12388.0
2022-01-12 07:00:00	SPY	ETF	470.12	470.28	469.87	470.12	39869.0
2022-01-12 07:30:00	SPY	ETF	470.16	470.57	469.99	470.18	33913.0
2022-01-12 08:00:00	SPY	ETF	470.06	471.1	469.13	470.75	178823.0
2022-01-12 08:30:00	SPY	ETF	470.54	472.25	470.35	472.1	1144871.0
2022-01-12 09:00:00	SPY	ETF	472.12	472.14	471.34	471.6	330896.0
2022-01-12 09:30:00	SPY	ETF	471.59	472.68	470.89	472.6263	6582025.0
2022-01-12 10:00:00	SPY	ETF	472.64	473.2	472.05	472.3794	3739894.0
2022-01-12 10:30:00	SPY	ETF	472.38	472.5	470.12	470.7425	5130026.0
2022-01-12 11:00:00	SPY	ETF	470.74	471.24	468.94	470.37	4432819.0
2022-01-12 11:30:00	SPY	ETF	470.39	471.53	470.34	470.97	2701652.0
2022-01-12 12:00:00	SPY	ETF	470.99	471.28	470.25	470.93	2007142.0
2022-01-12 12:30:00	SPY	ETF	470.94	471.87	470.88	471.7	1765457.0
2022-01-12 13:00:00	SPY	ETF	471.71	471.77	470.68	470.84	2084160.0
2022-01-12 13:30:00	SPY	ETF	470.84	471.14	470.17	470.36	2195207.0
2022-01-12 14:00:00	SPY	ETF	470.3506	471.19	469.77	471.13	2932446.0
2022-01-12 14:30:00	SPY	ETF	471.12	471.1801	470.29	470.9199	2086327.0
2022-01-12 15:00:00	SPY	ETF	470.92	471.09	470.13	470.54	3198364.0
2022-01-12 15:30:00	SPY	ETF	470.515	471.67	470.14	471.07	8277638.0
2022-01-12 16:00:00	SPY	ETF	471.08	471.57	470.9761	471.5	2178511.0
2022-01-12 16:30:00	SPY	ETF	471.5	471.5	471.02	471.13	1076330.0
2022-01-12 17:00:00	SPY	ETF	471.03	471.19	471.01	471.1	50727.0
2022-01-12 17:30:00	SPY	ETF	471.12	471.12	471.05	471.06	12715.0
2022-01-12 18:00:00	SPY	ETF	471.09	471.2	471.02	471.06	54647.0
2022-01-12 18:30:00	SPY	ETF	471.13	471.26	470.85	470.91	31333.0
2022-01-12 19:00:00	SPY	ETF	470.92	470.96	470.59	470.71	26303.0
2022-01-12 19:30:00	SPY	ETF	470.77	471.03	470.73	470.77	45177.0
2022-01-12 04:00:00	QQQ	ETF	385.7	386.0	384.39	386.0	52885.0
2022-01-12 04:30:00	QQQ	ETF	386.05	386.59	385.64	386.47	13911.0
2022-01-12 05:00:00	QQQ	ETF	386.56	386.9	386.19	386.76	21617.0
2022-01-12 05:30:00	QQQ	ETF	386.54	387.07	386.34	386.97	12720.0
2022-01-12 06:00:00	QQQ	ETF	387.07	387.18	386.7	386.7	34260.0
2022-01-12 06:30:00	QQQ	ETF	386.68	386.98	386.4	386.41	18610.0
2022-01-12 07:00:00	QQQ	ETF	386.47	386.69	385.91	386.36	95870.0
2022-01-12 07:30:00	QQQ	ETF	386.44	386.98	386.35	386.61	231186.0
2022-01-12 08:00:00	QQQ	ETF	387.12	387.45	385.0	387.0	563844.0
2022-01-12 08:30:00	QQQ	ETF	387.0	389.33	385.83	389.22	1255484.0
2022-01-12 09:00:00	QQQ	ETF	389.28	389.44	388.29	388.5596	449910.0
2022-01-12 09:30:00	QQQ	ETF	388.47	389.75	387.14	389.13	7318227.0
2022-01-12 10:00:00	QQQ	ETF	389.13	390.2	388.38	389.38	3830975.0
2022-01-12 10:30:00	QQQ	ETF	389.37	389.45	385.97	386.51	5977182.0
2022-01-12 11:00:00	QQQ	ETF	386.49	387.18	385.01	386.68	4061793.0
2022-01-12 11:30:00	QQQ	ETF	386.72	388.05	386.66	387.51	2407055.0
2022-01-12 12:00:00	QQQ	ETF	387.52	387.89	386.5601	387.635	1790272.0
2022-01-12 12:30:00	QQQ	ETF	387.63	388.79	387.565	388.6	1634613.0

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

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