PREVIEW / etf_30min / 2007-05-23

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-05-23.parquet
  size:    116 KB
  rows:    4,458

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
2007-05-23 06:00:00	SPY	ETF	153.07	153.07	153.07	153.07	10000.0
2007-05-23 06:30:00	SPY	ETF	152.96	153.1	152.96	153.0	18300.0
2007-05-23 07:00:00	SPY	ETF	152.95	153.02	152.94	152.97	23900.0
2007-05-23 07:30:00	SPY	ETF	152.97	152.97	152.87	152.87	42100.0
2007-05-23 08:00:00	SPY	ETF	152.92	153.07	152.87	153.02	984700.0
2007-05-23 08:30:00	SPY	ETF	153.04	153.1	152.86	153.06	1118400.0
2007-05-23 09:00:00	SPY	ETF	153.08	153.1	152.95	152.95	942500.0
2007-05-23 09:30:00	SPY	ETF	152.95	153.28	152.82	153.17	16483310.0
2007-05-23 10:00:00	SPY	ETF	153.18	153.47	153.06	153.31	11345148.0
2007-05-23 10:30:00	SPY	ETF	153.31	153.5	153.25	153.38	7878546.0
2007-05-23 11:00:00	SPY	ETF	153.38	153.43	153.17	153.31	5480411.0
2007-05-23 11:30:00	SPY	ETF	153.32	153.37	153.16	153.19	3163204.0
2007-05-23 12:00:00	SPY	ETF	153.19	153.3	153.15	153.3	4089350.0
2007-05-23 12:30:00	SPY	ETF	153.3	153.31	153.205	153.3	2831235.0
2007-05-23 13:00:00	SPY	ETF	153.3	153.475	153.26	153.39	4825110.0
2007-05-23 13:30:00	SPY	ETF	153.39	153.45	153.09	153.15	3987780.0
2007-05-23 14:00:00	SPY	ETF	153.14	153.22	152.37	152.52	21518253.0
2007-05-23 14:30:00	SPY	ETF	152.52	152.98	152.48	152.87	16554639.0
2007-05-23 15:00:00	SPY	ETF	152.86	152.9	152.62	152.75	9615671.0
2007-05-23 15:30:00	SPY	ETF	152.75	152.81	152.38	152.38	12068765.0
2007-05-23 16:00:00	SPY	ETF	152.39	153.45	152.36	152.5	2566300.0
2007-05-23 16:30:00	SPY	ETF	152.5	152.52	152.39	152.47	656100.0
2007-05-23 17:00:00	SPY	ETF	152.45	152.45	152.38	152.43	16000.0
2007-05-23 17:30:00	SPY	ETF	152.38	152.44	152.38	152.44	1200.0
2007-05-23 18:00:00	SPY	ETF	152.4	152.45	152.4	152.45	163800.0
2007-05-23 18:30:00	SPY	ETF	152.41	152.44	152.41	152.44	1100.0
2007-05-23 19:00:00	SPY	ETF	152.48	152.48	152.48	152.48	3000.0
2007-05-23 19:30:00	SPY	ETF	152.43	152.44	152.4	152.41	7200.0
2007-05-23 05:00:00	QQQ	ETF	47.2	47.2	47.2	47.2	1000.0
2007-05-23 07:00:00	QQQ	ETF	47.24	47.24	47.21	47.23	8500.0
2007-05-23 07:30:00	QQQ	ETF	47.23	47.23	47.18	47.2	109800.0
2007-05-23 08:00:00	QQQ	ETF	47.2	47.24	47.19	47.24	241414.0
2007-05-23 08:30:00	QQQ	ETF	47.24	47.26	47.22	47.23	307797.0
2007-05-23 09:00:00	QQQ	ETF	47.24	47.26	47.2	47.2	621508.0
2007-05-23 09:30:00	QQQ	ETF	47.19	47.3	47.09	47.26	12387476.0
2007-05-23 10:00:00	QQQ	ETF	47.25	47.37	47.21	47.24	11242120.0
2007-05-23 10:30:00	QQQ	ETF	47.24	47.35	47.21	47.2799	5245855.0
2007-05-23 11:00:00	QQQ	ETF	47.28	47.3	47.18	47.29	2930114.0
2007-05-23 11:30:00	QQQ	ETF	47.3	47.32	47.25	47.27	3053027.0
2007-05-23 12:00:00	QQQ	ETF	47.27	47.3	47.23	47.28	3805784.0
2007-05-23 12:30:00	QQQ	ETF	47.28	47.32	47.26	47.31	2748338.0
2007-05-23 13:00:00	QQQ	ETF	47.32	47.36	47.3	47.32	2577231.0
2007-05-23 13:30:00	QQQ	ETF	47.33	47.35	47.14	47.18	6685809.0
2007-05-23 14:00:00	QQQ	ETF	47.18	47.21	46.88	46.91	19959256.0
2007-05-23 14:30:00	QQQ	ETF	46.92	47.06	46.89	47.001	11787092.0
2007-05-23 15:00:00	QQQ	ETF	47.01	47.04	46.92	46.961	4599956.0
2007-05-23 15:30:00	QQQ	ETF	46.96	47.0	46.82	46.8474	13019674.0
2007-05-23 16:00:00	QQQ	ETF	46.85	47.25	46.79	46.82	8664425.0
2007-05-23 16:30:00	QQQ	ETF	46.83	46.83	46.77	46.79	1018046.0
2007-05-23 17:00:00	QQQ	ETF	46.79	46.81	46.78	46.81	105555.0

> showing 50 of 4,458 rows — these rows as CSV

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