PREVIEW / etf_30min / 2022-10-11

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-10-11.parquet
  size:    679 KB
  rows:    27,376

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-10-11 04:00:00	SPY	ETF	357.49	358.63	357.15	357.84	64985.0
2022-10-11 04:30:00	SPY	ETF	357.84	357.84	356.59	356.9	56113.0
2022-10-11 05:00:00	SPY	ETF	356.97	357.54	356.88	357.31	11090.0
2022-10-11 05:30:00	SPY	ETF	357.12	357.13	356.57	356.8	30737.0
2022-10-11 06:00:00	SPY	ETF	356.93	357.6	356.31	357.0	152587.0
2022-10-11 06:30:00	SPY	ETF	357.15	357.83	357.0	357.78	33335.0
2022-10-11 07:00:00	SPY	ETF	357.79	358.82	357.75	358.43	311705.0
2022-10-11 07:30:00	SPY	ETF	358.44	358.92	357.98	358.89	165123.0
2022-10-11 08:00:00	SPY	ETF	358.85	360.15	356.83	360.1	685833.0
2022-10-11 08:30:00	SPY	ETF	360.11	360.54	359.17	359.22	740630.0
2022-10-11 09:00:00	SPY	ETF	359.19	359.56	358.23	358.26	726487.0
2022-10-11 09:30:00	SPY	ETF	358.26	358.9	356.5	356.59	6335549.0
2022-10-11 10:00:00	SPY	ETF	356.59	357.45	355.81	356.77	5907733.0
2022-10-11 10:30:00	SPY	ETF	356.724	358.65	356.26	357.51	4603902.0
2022-10-11 11:00:00	SPY	ETF	357.53	359.56	357.45	359.35	4325809.0
2022-10-11 11:30:00	SPY	ETF	359.35	361.49	359.19	360.759	5159819.0
2022-10-11 12:00:00	SPY	ETF	360.76	361.74	359.485	361.26	3518779.0
2022-10-11 12:30:00	SPY	ETF	361.26	363.03	361.19	362.15	4036767.0
2022-10-11 13:00:00	SPY	ETF	362.16	362.38	361.12	361.41	3416761.0
2022-10-11 13:30:00	SPY	ETF	361.4	362.16	360.87	361.89	2291715.0
2022-10-11 14:00:00	SPY	ETF	361.88	362.13	360.44	361.3	3206493.0
2022-10-11 14:30:00	SPY	ETF	361.29	361.81	357.16	357.32	6517602.0
2022-10-11 15:00:00	SPY	ETF	357.3	357.6	355.71	357.1	9176290.0
2022-10-11 15:30:00	SPY	ETF	357.12	358.24	356.42	357.74	11098398.0
2022-10-11 16:00:00	SPY	ETF	357.74	358.15	357.59	358.06	3757382.0
2022-10-11 16:30:00	SPY	ETF	358.08	358.65	357.7898	358.6	390248.0
2022-10-11 17:00:00	SPY	ETF	358.51	358.69	358.35	358.35	82567.0
2022-10-11 17:30:00	SPY	ETF	358.47	358.5	358.31	358.45	19285.0
2022-10-11 18:00:00	SPY	ETF	358.41	358.48	358.11	358.11	85537.0
2022-10-11 18:30:00	SPY	ETF	358.15	358.29	357.86	358.2	102702.0
2022-10-11 19:00:00	SPY	ETF	358.19	358.4	357.8	357.83	45016.0
2022-10-11 19:30:00	SPY	ETF	357.84	358.28	357.82	358.24	61863.0
2022-10-11 04:00:00	QQQ	ETF	265.46	265.88	264.46	264.6	47433.0
2022-10-11 04:30:00	QQQ	ETF	264.64	264.64	263.67	263.92	89141.0
2022-10-11 05:00:00	QQQ	ETF	264.0	264.35	263.76	264.22	35915.0
2022-10-11 05:30:00	QQQ	ETF	264.11	264.11	263.51	263.8	41493.0
2022-10-11 06:00:00	QQQ	ETF	263.66	264.46	263.36	263.98	88253.0
2022-10-11 06:30:00	QQQ	ETF	264.02	264.6	263.98	264.6	115920.0
2022-10-11 07:00:00	QQQ	ETF	264.56	265.19	264.5	264.93	209472.0
2022-10-11 07:30:00	QQQ	ETF	264.86	265.15	264.44	265.15	112997.0
2022-10-11 08:00:00	QQQ	ETF	264.74	266.609	263.75	266.1195	423288.0
2022-10-11 08:30:00	QQQ	ETF	266.06	266.42	265.29	265.36	422496.0
2022-10-11 09:00:00	QQQ	ETF	265.2	265.39	264.62	264.71	329038.0
2022-10-11 09:30:00	QQQ	ETF	264.74	265.32	262.32	262.36	6206542.0
2022-10-11 10:00:00	QQQ	ETF	262.37	263.12	261.53	262.52	4836414.0
2022-10-11 10:30:00	QQQ	ETF	262.49	264.27	262.025	262.94	4118550.0
2022-10-11 11:00:00	QQQ	ETF	262.935	264.81	262.865	264.47	3398384.0
2022-10-11 11:30:00	QQQ	ETF	264.5	266.56	264.29	265.71	4037823.0
2022-10-11 12:00:00	QQQ	ETF	265.74	266.51	264.54	265.94	2926677.0
2022-10-11 12:30:00	QQQ	ETF	265.95	267.63	265.83	266.575	3284289.0

> showing 50 of 27,376 rows — these rows as CSV

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