PREVIEW / etf_30min / 2007-08-24

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-08-24.parquet
  size:    125 KB
  rows:    4,579

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-24 05:00:00	SPY	ETF	146.11	146.11	146.11	146.11	100.0
2007-08-24 06:00:00	SPY	ETF	146.26	146.26	146.26	146.26	7000.0
2007-08-24 06:30:00	SPY	ETF	146.14	146.28	146.14	146.28	7000.0
2007-08-24 07:00:00	SPY	ETF	146.25	146.5	146.25	146.45	178300.0
2007-08-24 07:30:00	SPY	ETF	146.44	146.44	146.3	146.32	152100.0
2007-08-24 08:00:00	SPY	ETF	146.32	146.54	146.3	146.37	758200.0
2007-08-24 08:30:00	SPY	ETF	146.39	146.74	146.39	146.55	2003000.0
2007-08-24 09:00:00	SPY	ETF	146.55	146.71	145.95	146.47	1472917.0
2007-08-24 09:30:00	SPY	ETF	146.48	146.76	146.28	146.53	12947329.0
2007-08-24 10:00:00	SPY	ETF	146.53	147.19	146.52	146.75	16947300.0
2007-08-24 10:30:00	SPY	ETF	146.75	146.89	146.44	146.62	7058800.0
2007-08-24 11:00:00	SPY	ETF	146.61	146.88	146.57	146.739	5157100.0
2007-08-24 11:30:00	SPY	ETF	146.74	146.98	146.58	146.98	5767700.0
2007-08-24 12:00:00	SPY	ETF	146.98	147.46	146.79	147.28	10571900.0
2007-08-24 12:30:00	SPY	ETF	147.28	147.38	147.19	147.27	4657500.0
2007-08-24 13:00:00	SPY	ETF	147.27	147.53	147.22	147.43	7453800.0
2007-08-24 13:30:00	SPY	ETF	147.43	147.49	147.24	147.43	7402900.0
2007-08-24 14:00:00	SPY	ETF	147.43	147.67	147.38	147.481	6634800.0
2007-08-24 14:30:00	SPY	ETF	147.48	147.95	147.4	147.95	6808500.0
2007-08-24 15:00:00	SPY	ETF	147.94	147.95	147.54	147.77	7791900.0
2007-08-24 15:30:00	SPY	ETF	147.78	148.25	147.77	148.16	15414800.0
2007-08-24 16:00:00	SPY	ETF	148.17	148.35	148.16	148.34	3017600.0
2007-08-24 16:30:00	SPY	ETF	148.28	148.39	148.2409	148.39	2159000.0
2007-08-24 17:00:00	SPY	ETF	148.37	148.38	148.35	148.35	10800.0
2007-08-24 17:30:00	SPY	ETF	148.35	148.42	148.35	148.4	29700.0
2007-08-24 18:00:00	SPY	ETF	148.37	148.39	148.31	148.31	12600.0
2007-08-24 18:30:00	SPY	ETF	148.31	148.31	148.29	148.29	6100.0
2007-08-24 19:00:00	SPY	ETF	148.3	148.38	148.28	148.38	7200.0
2007-08-24 19:30:00	SPY	ETF	148.3	148.39	148.28	148.3	4300.0
2007-08-24 06:00:00	QQQ	ETF	47.39	47.41	47.39	47.41	2200.0
2007-08-24 07:00:00	QQQ	ETF	47.38	47.44	47.38	47.44	65122.0
2007-08-24 07:30:00	QQQ	ETF	47.43	47.44	47.39	47.4	35500.0
2007-08-24 08:00:00	QQQ	ETF	47.41	47.46	47.39	47.44	124389.0
2007-08-24 08:30:00	QQQ	ETF	47.44	47.53	47.39	47.42	1045930.0
2007-08-24 09:00:00	QQQ	ETF	47.42	47.44	47.25	47.39	603374.0
2007-08-24 09:30:00	QQQ	ETF	47.38	47.52	47.32	47.44	8100471.0
2007-08-24 10:00:00	QQQ	ETF	47.44	47.65	47.44	47.56	10683867.0
2007-08-24 10:30:00	QQQ	ETF	47.56	47.62	47.5	47.56	3273813.0
2007-08-24 11:00:00	QQQ	ETF	47.57	47.66	47.55	47.6385	3675637.0
2007-08-24 11:30:00	QQQ	ETF	47.63	47.73	47.58	47.72	4369607.0
2007-08-24 12:00:00	QQQ	ETF	47.72	47.96	47.67	47.88	13003854.0
2007-08-24 12:30:00	QQQ	ETF	47.88	47.89	47.81	47.8601	3320875.0
2007-08-24 13:00:00	QQQ	ETF	47.87	47.94	47.85	47.92	3005773.0
2007-08-24 13:30:00	QQQ	ETF	47.92	47.95	47.872	47.9	3571924.0
2007-08-24 14:00:00	QQQ	ETF	47.9	48.02	47.87	47.988	5630311.0
2007-08-24 14:30:00	QQQ	ETF	47.99	48.14	47.95	48.14	4626976.0
2007-08-24 15:00:00	QQQ	ETF	48.132	48.14	48.01	48.0715	3691958.0
2007-08-24 15:30:00	QQQ	ETF	48.08	48.23	48.08	48.21	8569906.0
2007-08-24 16:00:00	QQQ	ETF	48.22	48.31	48.2	48.29	2419507.0
2007-08-24 16:30:00	QQQ	ETF	48.29	48.31	48.21	48.26	474546.0

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

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