PREVIEW / etf_30min / 2022-01-18

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-01-18.parquet
  size:    704 KB
  rows:    28,080

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-18 04:00:00	SPY	ETF	461.45	461.45	458.5	458.99	79881.0
2022-01-18 04:30:00	SPY	ETF	459.03	459.6	458.47	459.36	32077.0
2022-01-18 05:00:00	SPY	ETF	459.35	460.02	459.32	460.02	18973.0
2022-01-18 05:30:00	SPY	ETF	460.1	460.1	459.11	459.59	35000.0
2022-01-18 06:00:00	SPY	ETF	459.49	459.6	459.0	459.49	42920.0
2022-01-18 06:30:00	SPY	ETF	459.4	459.9	459.2	459.59	14325.0
2022-01-18 07:00:00	SPY	ETF	459.74	460.42	459.69	460.26	235522.0
2022-01-18 07:30:00	SPY	ETF	460.27	460.8	459.87	460.699	152458.0
2022-01-18 08:00:00	SPY	ETF	459.99	462.93	458.9796	460.2	261317.0
2022-01-18 08:30:00	SPY	ETF	460.19	460.75	459.75	460.49	247991.0
2022-01-18 09:00:00	SPY	ETF	460.49	460.58	459.64	459.74	257466.0
2022-01-18 09:30:00	SPY	ETF	459.73	459.96	457.14	458.12	11084118.0
2022-01-18 10:00:00	SPY	ETF	458.1	459.55	457.46	459.12	6608454.0
2022-01-18 10:30:00	SPY	ETF	459.09	459.09	457.24	457.5	4009272.0
2022-01-18 11:00:00	SPY	ETF	457.52	458.06	456.82	457.49	3996748.0
2022-01-18 11:30:00	SPY	ETF	457.48	458.7277	456.58	458.07	4344439.0
2022-01-18 12:00:00	SPY	ETF	458.09	458.28	456.58	456.84	3336676.0
2022-01-18 12:30:00	SPY	ETF	456.84	457.03	455.7199	455.8001	4463529.0
2022-01-18 13:00:00	SPY	ETF	455.81	456.8	455.46	456.08	4545763.0
2022-01-18 13:30:00	SPY	ETF	456.07	457.32	455.7804	457.15	4245126.0
2022-01-18 14:00:00	SPY	ETF	457.14	457.61	456.72	457.19	3286581.0
2022-01-18 14:30:00	SPY	ETF	457.17	458.9	457.15	458.425	4027451.0
2022-01-18 15:00:00	SPY	ETF	458.42	458.65	456.39	457.03	5348733.0
2022-01-18 15:30:00	SPY	ETF	457.04	457.25	455.31	456.51	15721736.0
2022-01-18 16:00:00	SPY	ETF	456.51	456.91	456.01	456.68	3535330.0
2022-01-18 16:30:00	SPY	ETF	456.7	457.07	456.18	456.98	202463.0
2022-01-18 17:00:00	SPY	ETF	456.98	457.01	456.94	457.0	47997.0
2022-01-18 17:30:00	SPY	ETF	456.99	457.02	456.99	457.01	26029.0
2022-01-18 18:00:00	SPY	ETF	457.02	457.29	456.76	456.88	38481.0
2022-01-18 18:30:00	SPY	ETF	456.49	456.9	456.15	456.16	43721.0
2022-01-18 19:00:00	SPY	ETF	456.18	456.56	456.0	456.22	30463.0
2022-01-18 19:30:00	SPY	ETF	456.08	456.34	455.53	455.82	56207.0
2022-01-18 04:00:00	QQQ	ETF	380.49	380.49	372.35	372.93	166511.0
2022-01-18 04:30:00	QQQ	ETF	372.89	373.58	372.23	373.21	96028.0
2022-01-18 05:00:00	QQQ	ETF	373.26	373.97	373.26	373.97	71979.0
2022-01-18 05:30:00	QQQ	ETF	373.9	373.95	373.05	373.4	24407.0
2022-01-18 06:00:00	QQQ	ETF	373.3	373.54	372.75	373.32	40163.0
2022-01-18 06:30:00	QQQ	ETF	373.3	373.73	372.92	373.45	47894.0
2022-01-18 07:00:00	QQQ	ETF	373.49	374.45	373.49	374.29	232033.0
2022-01-18 07:30:00	QQQ	ETF	374.32	374.85	373.8	374.64	174591.0
2022-01-18 08:00:00	QQQ	ETF	373.87	376.79	372.3896	374.2	473602.0
2022-01-18 08:30:00	QQQ	ETF	374.25	374.99	373.84	374.62	338174.0
2022-01-18 09:00:00	QQQ	ETF	374.59	374.93	373.69	374.09	327087.0
2022-01-18 09:30:00	QQQ	ETF	374.12	374.78	372.31	373.75	8178465.0
2022-01-18 10:00:00	QQQ	ETF	373.73	376.22	372.98	375.88	6672180.0
2022-01-18 10:30:00	QQQ	ETF	375.85	375.85	373.02	373.31	3398590.0
2022-01-18 11:00:00	QQQ	ETF	373.32	373.67	372.375	372.72	3110539.0
2022-01-18 11:30:00	QQQ	ETF	372.72	374.48	371.85	374.0117	3615289.0
2022-01-18 12:00:00	QQQ	ETF	374.02	374.2999	372.41	372.66	2608006.0
2022-01-18 12:30:00	QQQ	ETF	372.65	372.6705	371.69	371.82	2967406.0

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

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