PREVIEW / etf_30min / 2021-12-15

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-12-15.parquet
  size:    653 KB
  rows:    25,536

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-12-15 04:00:00	SPY	ETF	463.66	463.85	462.61	462.66	9997.0
2021-12-15 04:30:00	SPY	ETF	462.76	463.27	462.76	463.12	25241.0
2021-12-15 05:00:00	SPY	ETF	463.01	463.3	462.96	463.29	7950.0
2021-12-15 05:30:00	SPY	ETF	463.31	463.55	463.2	463.55	91432.0
2021-12-15 06:00:00	SPY	ETF	463.63	463.63	462.69	463.04	69167.0
2021-12-15 06:30:00	SPY	ETF	462.96	463.1	462.72	463.06	17388.0
2021-12-15 07:00:00	SPY	ETF	463.06	463.56	463.06	463.5	81297.0
2021-12-15 07:30:00	SPY	ETF	463.51	463.68	463.18	463.24	47049.0
2021-12-15 08:00:00	SPY	ETF	463.4899	463.787	462.7504	463.52	100803.0
2021-12-15 08:30:00	SPY	ETF	463.5	463.97	463.07	463.25	181839.0
2021-12-15 09:00:00	SPY	ETF	463.23	463.66	463.01	463.42	150335.0
2021-12-15 09:30:00	SPY	ETF	463.42	463.73	461.39	461.675	5276633.0
2021-12-15 10:00:00	SPY	ETF	461.71	462.2	461.16	461.96	3238927.0
2021-12-15 10:30:00	SPY	ETF	461.94	462.97	461.7914	462.13	2995393.0
2021-12-15 11:00:00	SPY	ETF	462.13	462.4	461.19	461.52	2434577.0
2021-12-15 11:30:00	SPY	ETF	461.53	461.655	460.7922	461.42	2889093.0
2021-12-15 12:00:00	SPY	ETF	461.4	462.11	460.95	462.05	1790275.0
2021-12-15 12:30:00	SPY	ETF	462.035	462.28	461.59	462.16	1735441.0
2021-12-15 13:00:00	SPY	ETF	462.17	462.38	461.925	462.16	1448676.0
2021-12-15 13:30:00	SPY	ETF	462.145	462.8	461.82	462.64	2361662.0
2021-12-15 14:00:00	SPY	ETF	462.61	465.58	460.74	463.66	12396336.0
2021-12-15 14:30:00	SPY	ETF	463.68	465.88	463.27	464.8	8064570.0
2021-12-15 15:00:00	SPY	ETF	464.8	469.68	464.72	469.515	9806568.0
2021-12-15 15:30:00	SPY	ETF	469.51	470.86	468.1244	470.58	17729796.0
2021-12-15 16:00:00	SPY	ETF	470.58	471.11	470.29	470.76	9785077.0
2021-12-15 16:30:00	SPY	ETF	470.79	470.9	470.06	470.82	244556.0
2021-12-15 17:00:00	SPY	ETF	470.8	470.99	470.77	470.9	89091.0
2021-12-15 17:30:00	SPY	ETF	470.9	470.97	470.86	470.86	48720.0
2021-12-15 18:00:00	SPY	ETF	470.85	471.7	470.75	471.53	140336.0
2021-12-15 18:30:00	SPY	ETF	470.6	471.68	470.6	471.24	49355.0
2021-12-15 19:00:00	SPY	ETF	471.3	471.3	470.6	470.75	165099.0
2021-12-15 19:30:00	SPY	ETF	470.82	471.17	470.75	470.91	42043.0
2021-12-15 04:00:00	QQQ	ETF	388.53	388.67	386.5	386.82	32211.0
2021-12-15 04:30:00	QQQ	ETF	386.84	387.52	386.84	387.27	12700.0
2021-12-15 05:00:00	QQQ	ETF	387.1	387.32	386.9	387.32	12434.0
2021-12-15 05:30:00	QQQ	ETF	387.41	387.63	387.3	387.61	9521.0
2021-12-15 06:00:00	QQQ	ETF	387.68	387.68	386.96	387.19	16843.0
2021-12-15 06:30:00	QQQ	ETF	387.14	387.45	386.81	387.41	15117.0
2021-12-15 07:00:00	QQQ	ETF	387.39	388.06	387.39	387.94	91949.0
2021-12-15 07:30:00	QQQ	ETF	388.0	388.27	387.71	387.8	49324.0
2021-12-15 08:00:00	QQQ	ETF	387.69	388.6196	386.83	388.3	136420.0
2021-12-15 08:30:00	QQQ	ETF	388.78	389.31	387.68	387.84	153449.0
2021-12-15 09:00:00	QQQ	ETF	387.82	388.27	387.54	387.96	163610.0
2021-12-15 09:30:00	QQQ	ETF	387.98	388.44	385.9	386.32	5459059.0
2021-12-15 10:00:00	QQQ	ETF	386.32	387.26	385.511	386.7	2854493.0
2021-12-15 10:30:00	QQQ	ETF	386.69	388.0	386.28	386.51	2250436.0
2021-12-15 11:00:00	QQQ	ETF	386.5	386.72	385.39	385.61	2210638.0
2021-12-15 11:30:00	QQQ	ETF	385.625	385.65	384.42	384.68	2275386.0
2021-12-15 12:00:00	QQQ	ETF	384.66	385.25	383.88	385.17	1896888.0
2021-12-15 12:30:00	QQQ	ETF	385.17	385.44	384.575	385.23	1598042.0

> showing 50 of 25,536 rows — these rows as CSV

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