PREVIEW / etf_30min / 2021-07-22

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-07-22.parquet
  size:    590 KB
  rows:    22,328

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-07-22 04:00:00	SPY	ETF	435.04	435.24	435.03	435.24	18612.0
2021-07-22 04:30:00	SPY	ETF	435.21	435.29	435.11	435.21	7096.0
2021-07-22 05:00:00	SPY	ETF	435.19	435.36	435.18	435.36	2950.0
2021-07-22 05:30:00	SPY	ETF	435.38	435.41	435.27	435.33	11078.0
2021-07-22 06:00:00	SPY	ETF	435.34	435.34	435.25	435.3	15158.0
2021-07-22 06:30:00	SPY	ETF	435.3	435.59	435.3	435.51	23310.0
2021-07-22 07:00:00	SPY	ETF	435.5	435.51	435.01	435.06	65844.0
2021-07-22 07:30:00	SPY	ETF	435.04	435.2	434.89	435.16	61276.0
2021-07-22 08:00:00	SPY	ETF	435.45	435.5296	434.76	434.98	88654.0
2021-07-22 08:30:00	SPY	ETF	435.03	435.03	434.14	434.35	265785.0
2021-07-22 09:00:00	SPY	ETF	434.34	434.8	434.22	434.78	242996.0
2021-07-22 09:30:00	SPY	ETF	434.74	435.03	433.93	434.4	5472286.0
2021-07-22 10:00:00	SPY	ETF	434.39	434.84	434.07	434.71	3345189.0
2021-07-22 10:30:00	SPY	ETF	434.7	435.365	434.66	435.04	2289925.0
2021-07-22 11:00:00	SPY	ETF	435.04	435.145	434.41	434.69	2108064.0
2021-07-22 11:30:00	SPY	ETF	434.69	434.8	434.17	434.505	1911681.0
2021-07-22 12:00:00	SPY	ETF	434.5099	434.62	433.69	434.26	2705492.0
2021-07-22 12:30:00	SPY	ETF	434.26	434.82	434.14	434.81	1801362.0
2021-07-22 13:00:00	SPY	ETF	434.81	435.08	434.68	435.02	1456545.0
2021-07-22 13:30:00	SPY	ETF	435.02	435.24	434.975	435.229	1131603.0
2021-07-22 14:00:00	SPY	ETF	435.225	435.6	435.157	435.455	2015290.0
2021-07-22 14:30:00	SPY	ETF	435.455	435.72	435.325	435.6619	1680391.0
2021-07-22 15:00:00	SPY	ETF	435.6501	435.71	435.38	435.535	1904492.0
2021-07-22 15:30:00	SPY	ETF	435.53	435.56	435.11	435.49	5406747.0
2021-07-22 16:00:00	SPY	ETF	435.52	436.28	435.46	436.22	1815476.0
2021-07-22 16:30:00	SPY	ETF	436.23	436.65	435.46	436.6	579170.0
2021-07-22 17:00:00	SPY	ETF	436.61	436.71	436.49	436.69	53104.0
2021-07-22 17:30:00	SPY	ETF	436.64	436.69	436.54	436.63	33324.0
2021-07-22 18:00:00	SPY	ETF	436.63	436.67	436.49	436.5	30896.0
2021-07-22 18:30:00	SPY	ETF	435.46	436.55	435.46	436.52	13056.0
2021-07-22 19:00:00	SPY	ETF	436.51	436.58	436.46	436.5	7846.0
2021-07-22 19:30:00	SPY	ETF	436.53	436.54	436.41	436.5	20271.0
2021-07-22 04:00:00	QQQ	ETF	362.01	362.37	362.01	362.1	17400.0
2021-07-22 04:30:00	QQQ	ETF	362.06	362.06	361.86	361.97	9162.0
2021-07-22 05:00:00	QQQ	ETF	361.95	362.18	361.95	362.15	2569.0
2021-07-22 05:30:00	QQQ	ETF	362.08	362.13	361.93	361.93	2900.0
2021-07-22 06:00:00	QQQ	ETF	361.92	362.01	361.72	361.86	5952.0
2021-07-22 06:30:00	QQQ	ETF	361.94	362.15	361.91	362.1	21687.0
2021-07-22 07:00:00	QQQ	ETF	362.08	362.28	361.86	362.01	72553.0
2021-07-22 07:30:00	QQQ	ETF	362.0	362.16	361.72	361.93	50470.0
2021-07-22 08:00:00	QQQ	ETF	361.9396	362.2599	361.7396	362.03	59714.0
2021-07-22 08:30:00	QQQ	ETF	361.99	362.08	361.57	361.68	76160.0
2021-07-22 09:00:00	QQQ	ETF	361.66	361.81	361.47	361.77	58117.0
2021-07-22 09:30:00	QQQ	ETF	361.75	363.08	361.75	362.68	3987194.0
2021-07-22 10:00:00	QQQ	ETF	362.6705	363.4	362.53	363.331	2526299.0
2021-07-22 10:30:00	QQQ	ETF	363.33	363.77	363.08	363.435	1574059.0
2021-07-22 11:00:00	QQQ	ETF	363.4288	363.75	362.69	363.0682	1817406.0
2021-07-22 11:30:00	QQQ	ETF	363.07	363.3982	362.7	363.32	975433.0
2021-07-22 12:00:00	QQQ	ETF	363.32	363.4185	361.99	362.63	1591891.0
2021-07-22 12:30:00	QQQ	ETF	362.64	362.96	362.45	362.9499	1062372.0

> showing 50 of 22,328 rows — these rows as CSV

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