PREVIEW / etf_30min / 2021-01-27

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-01-27.parquet
  size:    654 KB
  rows:    25,197

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-01-27 04:00:00	SPY	ETF	383.25	383.79	383.22	383.6	13359.0
2021-01-27 04:30:00	SPY	ETF	383.5	383.5	383.32	383.39	2770.0
2021-01-27 05:00:00	SPY	ETF	383.3	383.34	382.96	383.13	20713.0
2021-01-27 05:30:00	SPY	ETF	383.07	383.2	382.61	382.61	22500.0
2021-01-27 06:00:00	SPY	ETF	382.65	382.65	381.97	382.4	141139.0
2021-01-27 06:30:00	SPY	ETF	382.45	382.49	379.73	380.69	369104.0
2021-01-27 07:00:00	SPY	ETF	380.78	381.2	379.52	380.0	469998.0
2021-01-27 07:30:00	SPY	ETF	380.0	380.3	378.86	379.02	510069.0
2021-01-27 08:00:00	SPY	ETF	378.95	383.41	378.76	379.81	796365.0
2021-01-27 08:30:00	SPY	ETF	379.75	380.1	379.05	379.95	600560.0
2021-01-27 09:00:00	SPY	ETF	380.01	380.32	379.04	380.23	650554.0
2021-01-27 09:30:00	SPY	ETF	380.22	380.32	375.63	377.57	12702949.0
2021-01-27 10:00:00	SPY	ETF	377.57	379.64	377.2	379.22	5956885.0
2021-01-27 10:30:00	SPY	ETF	379.22	379.92	378.28	379.75	3812750.0
2021-01-27 11:00:00	SPY	ETF	379.76	379.77	377.94	378.18	3095845.0
2021-01-27 11:30:00	SPY	ETF	378.2	378.35	376.16	376.28	4215911.0
2021-01-27 12:00:00	SPY	ETF	376.26	378.06	375.91	377.79	4056759.0
2021-01-27 12:30:00	SPY	ETF	377.79	378.74	376.91	378.65	2737100.0
2021-01-27 13:00:00	SPY	ETF	378.65	378.89	377.68	378.48	2421002.0
2021-01-27 13:30:00	SPY	ETF	378.485	378.58	377.04	377.39	2175847.0
2021-01-27 14:00:00	SPY	ETF	377.39	378.16	375.9	376.01	4248288.0
2021-01-27 14:30:00	SPY	ETF	375.98	376.13	373.63	374.07	8956106.0
2021-01-27 15:00:00	SPY	ETF	374.06	375.165	373.1188	373.48	8361485.0
2021-01-27 15:30:00	SPY	ETF	373.48	374.53	372.01	374.44	20286867.0
2021-01-27 16:00:00	SPY	ETF	374.44	375.24	370.0	370.0	7248042.0
2021-01-27 16:30:00	SPY	ETF	370.0	373.75	370.0	372.98	792605.0
2021-01-27 17:00:00	SPY	ETF	373.1162	374.41	372.54	372.54	157755.0
2021-01-27 17:30:00	SPY	ETF	372.51	373.2	372.13	372.86	84239.0
2021-01-27 18:00:00	SPY	ETF	372.95	374.41	370.62	371.48	300983.0
2021-01-27 18:30:00	SPY	ETF	374.41	374.41	370.06	370.55	151994.0
2021-01-27 19:00:00	SPY	ETF	370.82	371.8	370.82	371.4	192425.0
2021-01-27 19:30:00	SPY	ETF	371.31	372.46	371.27	372.26	128581.0
2021-01-27 04:00:00	QQQ	ETF	329.93	330.58	329.93	330.18	22651.0
2021-01-27 04:30:00	QQQ	ETF	330.17	330.34	330.1	330.23	11203.0
2021-01-27 05:00:00	QQQ	ETF	330.13	330.28	329.82	330.15	10190.0
2021-01-27 05:30:00	QQQ	ETF	330.01	330.06	329.61	329.63	33782.0
2021-01-27 06:00:00	QQQ	ETF	329.56	329.6	328.99	329.56	97778.0
2021-01-27 06:30:00	QQQ	ETF	329.55	329.55	327.78	327.8	181385.0
2021-01-27 07:00:00	QQQ	ETF	327.8	328.53	325.71	326.71	458028.0
2021-01-27 07:30:00	QQQ	ETF	326.7	327.04	325.6	325.6	387499.0
2021-01-27 08:00:00	QQQ	ETF	325.51	330.5	325.46	325.89	1062667.0
2021-01-27 08:30:00	QQQ	ETF	326.0	328.88	325.5	326.44	499133.0
2021-01-27 09:00:00	QQQ	ETF	326.44	326.6	325.75	326.26	379519.0
2021-01-27 09:30:00	QQQ	ETF	326.26	326.3	321.0	323.67	6994977.0
2021-01-27 10:00:00	QQQ	ETF	323.665	325.88	323.25	325.41	2966327.0
2021-01-27 10:30:00	QQQ	ETF	325.33	326.18	324.36	325.71	1437270.0
2021-01-27 11:00:00	QQQ	ETF	325.7	325.74	323.72	323.81	1460325.0
2021-01-27 11:30:00	QQQ	ETF	323.81	323.99	322.0311	322.14	1735544.0
2021-01-27 12:00:00	QQQ	ETF	322.12	324.42	321.81	324.235	1870215.0
2021-01-27 12:30:00	QQQ	ETF	324.2497	324.83	323.18	324.6	1097971.0

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

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