PREVIEW / etf_30min / 2007-09-05

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-09-05.parquet
  size:    124 KB
  rows:    4,675

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-09-05 04:00:00	SPY	ETF	148.42	148.5	148.42	148.5	7000.0
2007-09-05 06:00:00	SPY	ETF	148.21	148.48	148.21	148.43	20400.0
2007-09-05 06:30:00	SPY	ETF	148.33	148.33	147.97	148.07	60500.0
2007-09-05 07:00:00	SPY	ETF	148.09	148.14	147.9	147.95	599500.0
2007-09-05 07:30:00	SPY	ETF	148.02	148.1	147.85	148.07	432000.0
2007-09-05 08:00:00	SPY	ETF	148.07	148.2	147.86	148.0	1655400.0
2007-09-05 08:30:00	SPY	ETF	147.99	149.08	147.82	148.07	1389200.0
2007-09-05 09:00:00	SPY	ETF	148.02	149.08	147.87	148.17	1465500.0
2007-09-05 09:30:00	SPY	ETF	148.2	148.36	147.92	147.98	14098108.0
2007-09-05 10:00:00	SPY	ETF	147.98	147.98	147.26	147.61	21916900.0
2007-09-05 10:30:00	SPY	ETF	147.6	147.89	147.47	147.69	9827600.0
2007-09-05 11:00:00	SPY	ETF	147.69	147.7	147.34	147.44	10060300.0
2007-09-05 11:30:00	SPY	ETF	147.44	147.53	147.14	147.51	9983100.0
2007-09-05 12:00:00	SPY	ETF	147.52	147.88	147.43	147.81	5058600.0
2007-09-05 12:30:00	SPY	ETF	147.81	147.83	147.56	147.82	4507200.0
2007-09-05 13:00:00	SPY	ETF	147.82	148.01	147.63	147.63	9419000.0
2007-09-05 13:30:00	SPY	ETF	147.63	147.7	147.42	147.5899	6370700.0
2007-09-05 14:00:00	SPY	ETF	147.58	147.967	147.01	147.12	17234200.0
2007-09-05 14:30:00	SPY	ETF	147.13	147.53	147.0	147.45	9593700.0
2007-09-05 15:00:00	SPY	ETF	147.45	147.76	147.33	147.54	10096500.0
2007-09-05 15:30:00	SPY	ETF	147.54	147.95	147.27	147.56	14967400.0
2007-09-05 16:00:00	SPY	ETF	147.58	148.45	147.43	147.75	6345900.0
2007-09-05 16:30:00	SPY	ETF	147.75	147.79	147.64	147.67	7088400.0
2007-09-05 17:00:00	SPY	ETF	147.65	147.66	147.59	147.65	31200.0
2007-09-05 17:30:00	SPY	ETF	147.65	147.65	147.65	147.65	4900.0
2007-09-05 18:00:00	SPY	ETF	147.64	147.64	147.61	147.62	11200.0
2007-09-05 18:30:00	SPY	ETF	147.64	147.66	147.61	147.61	8100.0
2007-09-05 19:00:00	SPY	ETF	147.62	147.66	147.6	147.6	2700.0
2007-09-05 19:30:00	SPY	ETF	147.62	147.68	147.6	147.68	1700.0
2007-09-05 04:00:00	QQQ	ETF	49.57	49.57	49.57	49.57	100.0
2007-09-05 05:00:00	QQQ	ETF	49.58	49.58	49.58	49.58	100.0
2007-09-05 06:00:00	QQQ	ETF	49.55	49.55	49.55	49.55	300.0
2007-09-05 06:30:00	QQQ	ETF	49.48	49.5	49.48	49.5	5000.0
2007-09-05 07:00:00	QQQ	ETF	49.51	49.58	49.49	49.54	562081.0
2007-09-05 07:30:00	QQQ	ETF	49.52	49.53	49.46	49.5	126699.0
2007-09-05 08:00:00	QQQ	ETF	49.51	49.55	49.44	49.47	294995.0
2007-09-05 08:30:00	QQQ	ETF	49.46	49.52	49.39	49.49	529322.0
2007-09-05 09:00:00	QQQ	ETF	49.48	49.56	49.47	49.55	1187654.0
2007-09-05 09:30:00	QQQ	ETF	49.56	49.65	49.46	49.46	7411556.0
2007-09-05 10:00:00	QQQ	ETF	49.46	49.46	49.31	49.42	10319080.0
2007-09-05 10:30:00	QQQ	ETF	49.42	49.52	49.37	49.45	5002980.0
2007-09-05 11:00:00	QQQ	ETF	49.45	49.45	49.3	49.36	6734811.0
2007-09-05 11:30:00	QQQ	ETF	49.35	49.39	49.26	49.39	6722279.0
2007-09-05 12:00:00	QQQ	ETF	49.38	49.49	49.34	49.44	5251311.0
2007-09-05 12:30:00	QQQ	ETF	49.45	49.46	49.35	49.45	2832586.0
2007-09-05 13:00:00	QQQ	ETF	49.45	49.51	49.26	49.2714	5624158.0
2007-09-05 13:30:00	QQQ	ETF	49.27	49.35	49.23	49.26	5504615.0
2007-09-05 14:00:00	QQQ	ETF	49.2526	49.32	48.93	48.98	10952992.0
2007-09-05 14:30:00	QQQ	ETF	48.99	49.08	48.87	49.0599	9029217.0
2007-09-05 15:00:00	QQQ	ETF	49.05	49.22	49.03	49.11	7222162.0

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

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