PREVIEW / etf_30min / 2007-08-21

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-08-21.parquet
  size:    122 KB
  rows:    4,576

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-21 04:00:00	SPY	ETF	144.01	144.01	144.01	144.01	900.0
2007-08-21 05:30:00	SPY	ETF	144.78	144.78	144.33	144.39	19000.0
2007-08-21 06:00:00	SPY	ETF	144.43	144.43	144.43	144.43	3000.0
2007-08-21 06:30:00	SPY	ETF	144.33	145.01	144.33	145.01	61300.0
2007-08-21 07:00:00	SPY	ETF	145.02	145.26	144.76	144.98	1182400.0
2007-08-21 07:30:00	SPY	ETF	144.95	145.48	144.95	145.45	758000.0
2007-08-21 08:00:00	SPY	ETF	145.41	145.65	144.375	144.85	3988100.0
2007-08-21 08:30:00	SPY	ETF	144.96	145.27	144.66	144.71	1307100.0
2007-08-21 09:00:00	SPY	ETF	144.7	144.85	144.27	144.59	3918178.0
2007-08-21 09:30:00	SPY	ETF	144.6	145.21	144.14	144.98	18936258.0
2007-08-21 10:00:00	SPY	ETF	144.98	145.04	144.2	144.59	11814000.0
2007-08-21 10:30:00	SPY	ETF	144.61	144.96	144.53	144.86	11422500.0
2007-08-21 11:00:00	SPY	ETF	144.86	145.12	144.48	145.05	12617400.0
2007-08-21 11:30:00	SPY	ETF	145.06	145.7	145.04	145.56	15915800.0
2007-08-21 12:00:00	SPY	ETF	145.55	145.97	145.28	145.61	8215800.0
2007-08-21 12:30:00	SPY	ETF	145.61	145.64	144.86	145.22	15369300.0
2007-08-21 13:00:00	SPY	ETF	145.22	145.44	144.94	145.29	5749600.0
2007-08-21 13:30:00	SPY	ETF	145.29	145.48	145.03	145.08	4190700.0
2007-08-21 14:00:00	SPY	ETF	145.08	145.33	144.94	145.1	5642200.0
2007-08-21 14:30:00	SPY	ETF	145.09	145.12	144.52	144.91	12379706.0
2007-08-21 15:00:00	SPY	ETF	144.91	145.08	144.69	145.01	5584200.0
2007-08-21 15:30:00	SPY	ETF	145.0	145.32	144.82	144.94	11262800.0
2007-08-21 16:00:00	SPY	ETF	144.95	145.09	144.8	144.8	1909800.0
2007-08-21 16:30:00	SPY	ETF	144.85	144.925	144.8	144.8	598900.0
2007-08-21 17:00:00	SPY	ETF	144.81	144.84	144.7	144.72	280800.0
2007-08-21 17:30:00	SPY	ETF	144.8	144.85	144.78	144.78	37900.0
2007-08-21 18:00:00	SPY	ETF	144.77	144.95	144.75	144.86	37900.0
2007-08-21 18:30:00	SPY	ETF	144.8	144.84	144.76	144.8	6600.0
2007-08-21 19:00:00	SPY	ETF	144.8	144.84	144.75	144.81	39400.0
2007-08-21 19:30:00	SPY	ETF	144.82	144.9	144.78	144.9	21300.0
2007-08-21 04:00:00	QQQ	ETF	46.38	46.38	46.38	46.38	200.0
2007-08-21 05:00:00	QQQ	ETF	46.37	46.37	46.33	46.33	300.0
2007-08-21 06:00:00	QQQ	ETF	46.36	46.36	46.36	46.36	5000.0
2007-08-21 06:30:00	QQQ	ETF	46.4	46.5	46.4	46.5	7500.0
2007-08-21 07:00:00	QQQ	ETF	46.55	46.62	46.45	46.5	1018280.0
2007-08-21 07:30:00	QQQ	ETF	46.5	46.68	46.5	46.67	200319.0
2007-08-21 08:00:00	QQQ	ETF	46.65	46.75	46.51	46.58	1680029.0
2007-08-21 08:30:00	QQQ	ETF	46.55	46.6	46.44	46.47	839498.0
2007-08-21 09:00:00	QQQ	ETF	46.47	46.55	46.37	46.47	6183008.0
2007-08-21 09:30:00	QQQ	ETF	46.48	46.72	46.39	46.65	10375496.0
2007-08-21 10:00:00	QQQ	ETF	46.642	46.67	46.45	46.56	7607909.0
2007-08-21 10:30:00	QQQ	ETF	46.56	46.71	46.56	46.68	7887709.0
2007-08-21 11:00:00	QQQ	ETF	46.68	46.8	46.6	46.8	8868623.0
2007-08-21 11:30:00	QQQ	ETF	46.8	46.9695	46.8	46.9	10620558.0
2007-08-21 12:00:00	QQQ	ETF	46.91	47.1272	46.55	47.06	9182813.0
2007-08-21 12:30:00	QQQ	ETF	47.052	47.052	46.84	46.97	10007771.0
2007-08-21 13:00:00	QQQ	ETF	46.97	47.04	46.86	47.0	3554811.0
2007-08-21 13:30:00	QQQ	ETF	47.01	47.07	46.5642	46.9785	5639792.0
2007-08-21 14:00:00	QQQ	ETF	46.97	47.05	46.94	46.97	3835037.0
2007-08-21 14:30:00	QQQ	ETF	46.97	46.99	46.8	46.89	5968165.0

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

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