PREVIEW / etf_30min / 2007-08-23

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-08-23.parquet
  size:    126 KB
  rows:    4,642

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-08-23 04:00:00	SPY	ETF	147.87	147.87	147.87	147.87	700.0
2007-08-23 04:30:00	SPY	ETF	147.7	147.7	147.7	147.7	1000.0
2007-08-23 05:00:00	SPY	ETF	147.77	147.77	147.77	147.77	1000.0
2007-08-23 05:30:00	SPY	ETF	148.0	148.0	148.0	148.0	1100.0
2007-08-23 06:00:00	SPY	ETF	148.05	148.05	147.99	148.0	25900.0
2007-08-23 06:30:00	SPY	ETF	148.03	148.04	147.85	147.89	10400.0
2007-08-23 07:00:00	SPY	ETF	147.88	148.02	147.8	147.97	543300.0
2007-08-23 07:30:00	SPY	ETF	148.0	148.03	147.59	147.68	423200.0
2007-08-23 08:00:00	SPY	ETF	147.69	148.05	147.46	147.59	2087000.0
2007-08-23 08:30:00	SPY	ETF	147.61	148.13	147.32	147.33	1173900.0
2007-08-23 09:00:00	SPY	ETF	147.35	148.0	147.31	147.33	2455700.0
2007-08-23 09:30:00	SPY	ETF	147.34	147.65	146.55	146.79	32821837.0
2007-08-23 10:00:00	SPY	ETF	146.79	147.04	146.49	146.63	21745208.0
2007-08-23 10:30:00	SPY	ETF	146.64	147.02	146.55	146.9	10641900.0
2007-08-23 11:00:00	SPY	ETF	146.9	146.94	146.33	146.35	11785100.0
2007-08-23 11:30:00	SPY	ETF	146.36	146.5	145.74	145.81	19498100.0
2007-08-23 12:00:00	SPY	ETF	145.81	146.21	145.81	146.06	11380800.0
2007-08-23 12:30:00	SPY	ETF	146.06	146.28	145.61	145.73	10663100.0
2007-08-23 13:00:00	SPY	ETF	145.74	146.03	145.64	145.78	8629900.0
2007-08-23 13:30:00	SPY	ETF	145.79	146.37	145.74	146.34	9985300.0
2007-08-23 14:00:00	SPY	ETF	146.34	146.65	146.21	146.4	10337727.0
2007-08-23 14:30:00	SPY	ETF	146.4	146.56	145.86	146.11	8854100.0
2007-08-23 15:00:00	SPY	ETF	146.11	146.73	145.87	146.48	14962500.0
2007-08-23 15:30:00	SPY	ETF	146.49	146.71	146.06	146.57	16630700.0
2007-08-23 16:00:00	SPY	ETF	146.57	147.9	146.2256	146.5	2672700.0
2007-08-23 16:30:00	SPY	ETF	146.56	146.65	146.42	146.56	2231800.0
2007-08-23 17:00:00	SPY	ETF	146.55	146.58	146.39	146.42	309000.0
2007-08-23 17:30:00	SPY	ETF	146.42	146.42	146.33	146.38	14300.0
2007-08-23 18:00:00	SPY	ETF	146.39	146.39	146.24	146.32	42000.0
2007-08-23 18:30:00	SPY	ETF	146.31	146.33	146.31	146.33	500.0
2007-08-23 19:00:00	SPY	ETF	146.34	146.37	146.3	146.34	37500.0
2007-08-23 19:30:00	SPY	ETF	146.34	146.38	146.31	146.34	23500.0
2007-08-23 04:30:00	QQQ	ETF	47.95	47.95	47.95	47.95	1000.0
2007-08-23 05:00:00	QQQ	ETF	47.95	48.0	47.95	48.0	1200.0
2007-08-23 05:30:00	QQQ	ETF	48.0	48.0	48.0	48.0	300.0
2007-08-23 06:00:00	QQQ	ETF	48.0	48.0	48.0	48.0	1000.0
2007-08-23 06:30:00	QQQ	ETF	47.99	48.01	47.97	47.97	6400.0
2007-08-23 07:00:00	QQQ	ETF	47.98	47.99	47.92	47.96	229448.0
2007-08-23 07:30:00	QQQ	ETF	47.96	48.0	47.87	47.88	418106.0
2007-08-23 08:00:00	QQQ	ETF	47.89	47.91	47.79	47.83	452302.0
2007-08-23 08:30:00	QQQ	ETF	47.83	48.04	47.73	47.73	868110.0
2007-08-23 09:00:00	QQQ	ETF	47.72	47.87	47.71	47.77	1705366.0
2007-08-23 09:30:00	QQQ	ETF	47.76	47.85	47.58	47.66	15528366.0
2007-08-23 10:00:00	QQQ	ETF	47.66	47.7	47.42	47.48	14774952.0
2007-08-23 10:30:00	QQQ	ETF	47.4772	47.619	47.4	47.56	6276132.0
2007-08-23 11:00:00	QQQ	ETF	47.57	47.57	47.39	47.43	6190156.0
2007-08-23 11:30:00	QQQ	ETF	47.43	47.45	47.23	47.2485	7849695.0
2007-08-23 12:00:00	QQQ	ETF	47.25	47.4394	47.25	47.4	7154598.0
2007-08-23 12:30:00	QQQ	ETF	47.3985	47.4905	47.26	47.3	5223637.0
2007-08-23 13:00:00	QQQ	ETF	47.3	47.39	47.27	47.29	4173630.0

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

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