PREVIEW / etf_30min / 2008-06-24

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-06-24.parquet
  size:    169 KB
  rows:    5,850

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
2008-06-24 04:30:00	SPY	ETF	131.58	131.58	131.53	131.53	3000.0
2008-06-24 05:00:00	SPY	ETF	131.1	131.1	131.05	131.05	1200.0
2008-06-24 05:30:00	SPY	ETF	131.0	131.0	130.45	130.86	43800.0
2008-06-24 06:00:00	SPY	ETF	130.81	130.81	130.69	130.81	9500.0
2008-06-24 06:30:00	SPY	ETF	130.81	130.89	130.77	130.82	31200.0
2008-06-24 07:00:00	SPY	ETF	130.8	130.82	130.52	130.52	1078748.0
2008-06-24 07:30:00	SPY	ETF	130.54	130.81	130.54	130.74	436990.0
2008-06-24 08:00:00	SPY	ETF	130.72	131.48	130.61	130.7	2716799.0
2008-06-24 08:30:00	SPY	ETF	130.69	130.9	130.68	130.82	1315752.0
2008-06-24 09:00:00	SPY	ETF	130.87	131.1	130.87	131.03	2945827.0
2008-06-24 09:30:00	SPY	ETF	131.05	131.34	130.5	130.61	26546865.0
2008-06-24 10:00:00	SPY	ETF	130.62	130.74	130.19	130.59	29129715.0
2008-06-24 10:30:00	SPY	ETF	130.6	131.3	130.34	131.27	24166552.0
2008-06-24 11:00:00	SPY	ETF	131.27	131.83	131.22	131.58	26951709.0
2008-06-24 11:30:00	SPY	ETF	131.59	132.07	131.43	131.92	21825996.0
2008-06-24 12:00:00	SPY	ETF	131.92	132.35	131.8	132.28	16044607.0
2008-06-24 12:30:00	SPY	ETF	132.27	132.38	131.93	131.978	11142467.0
2008-06-24 13:00:00	SPY	ETF	131.97	132.23	131.9	132.0	10401245.0
2008-06-24 13:30:00	SPY	ETF	132.0	132.14	131.76	132.09	11636787.0
2008-06-24 14:00:00	SPY	ETF	132.09	132.44	131.98	132.06	11388900.0
2008-06-24 14:30:00	SPY	ETF	132.06	132.12	131.47	131.665	13260179.0
2008-06-24 15:00:00	SPY	ETF	131.67	131.79	131.16	131.29	20937268.0
2008-06-24 15:30:00	SPY	ETF	131.29	131.6042	130.97	131.24	25778027.0
2008-06-24 16:00:00	SPY	ETF	131.1999	131.5	130.25	131.22	6547496.0
2008-06-24 16:30:00	SPY	ETF	131.23	131.6398	131.1	131.2	554367.0
2008-06-24 17:00:00	SPY	ETF	131.25	131.27	131.17	131.27	48752.0
2008-06-24 17:30:00	SPY	ETF	131.29	131.29	131.21	131.21	4100.0
2008-06-24 18:00:00	SPY	ETF	131.22	131.29	131.22	131.29	25360.0
2008-06-24 18:30:00	SPY	ETF	131.28	131.28	131.22	131.22	2700.0
2008-06-24 19:00:00	SPY	ETF	131.27	131.27	131.24	131.24	8000.0
2008-06-24 19:30:00	SPY	ETF	131.24	131.24	131.24	131.24	4000.0
2008-06-24 05:00:00	QQQ	ETF	46.8	46.8	46.72	46.72	14600.0
2008-06-24 05:30:00	QQQ	ETF	46.71	46.71	46.5	46.59	124400.0
2008-06-24 06:00:00	QQQ	ETF	46.6	46.66	46.6	46.6	42900.0
2008-06-24 06:30:00	QQQ	ETF	46.65	46.69	46.62	46.64	278800.0
2008-06-24 07:00:00	QQQ	ETF	46.64	46.64	46.56	46.56	231468.0
2008-06-24 07:30:00	QQQ	ETF	46.56	46.64	46.52	46.6	294691.0
2008-06-24 08:00:00	QQQ	ETF	46.6	46.64	46.56	46.64	1741990.0
2008-06-24 08:30:00	QQQ	ETF	46.64	46.67	46.59	46.67	1195542.0
2008-06-24 09:00:00	QQQ	ETF	46.68	46.84	46.66	46.83	2006168.0
2008-06-24 09:30:00	QQQ	ETF	46.83	46.995	46.68	46.7	17728950.0
2008-06-24 10:00:00	QQQ	ETF	46.66	46.74	46.52	46.61	16414979.0
2008-06-24 10:30:00	QQQ	ETF	46.62	46.89	46.41	46.84	18115678.0
2008-06-24 11:00:00	QQQ	ETF	46.84	47.1	46.74	46.918	18929359.0
2008-06-24 11:30:00	QQQ	ETF	46.92	47.26	46.8	47.17	15630591.0
2008-06-24 12:00:00	QQQ	ETF	47.17	47.21	47.06	47.19	7200031.0
2008-06-24 12:30:00	QQQ	ETF	47.19	47.23	47.03	47.09	5050490.0
2008-06-24 13:00:00	QQQ	ETF	47.09	47.29	47.08	47.139	6351499.0
2008-06-24 13:30:00	QQQ	ETF	47.13	47.262	47.06	47.25	5417473.0
2008-06-24 14:00:00	QQQ	ETF	47.25	47.37	47.225	47.255	7776411.0

> showing 50 of 5,850 rows — these rows as CSV

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