PREVIEW / etf_30min / 2007-09-19

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-09-19.parquet
  size:    134 KB
  rows:    5,020

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-19 04:00:00	SPY	ETF	152.88	153.1	152.88	153.1	6000.0
2007-09-19 04:30:00	SPY	ETF	153.13	153.13	152.99	152.99	4500.0
2007-09-19 05:00:00	SPY	ETF	152.92	152.92	152.8	152.92	5500.0
2007-09-19 05:30:00	SPY	ETF	152.87	152.99	152.87	152.99	1700.0
2007-09-19 06:00:00	SPY	ETF	152.95	153.06	152.94	153.0	39800.0
2007-09-19 06:30:00	SPY	ETF	153.05	153.09	152.99	153.02	267400.0
2007-09-19 07:00:00	SPY	ETF	153.05	153.29	152.92	153.26	427300.0
2007-09-19 07:30:00	SPY	ETF	153.23	153.23	152.85	153.05	920300.0
2007-09-19 08:00:00	SPY	ETF	153.01	153.23	152.97	153.04	597700.0
2007-09-19 08:30:00	SPY	ETF	153.03	153.5	152.93	153.4	2727200.0
2007-09-19 09:00:00	SPY	ETF	153.4	153.55	153.37	153.41	1287041.0
2007-09-19 09:30:00	SPY	ETF	153.41	153.88	153.41	153.73	25796307.0
2007-09-19 10:00:00	SPY	ETF	153.73	153.88	153.58	153.81	14169000.0
2007-09-19 10:30:00	SPY	ETF	153.81	154.05	153.61	154.01	17039300.0
2007-09-19 11:00:00	SPY	ETF	154.02	154.39	153.99	154.09	16481500.0
2007-09-19 11:30:00	SPY	ETF	154.09	154.12	153.61	153.82	14966800.0
2007-09-19 12:00:00	SPY	ETF	153.83	153.88	153.6	153.7	6079500.0
2007-09-19 12:30:00	SPY	ETF	153.7	153.82	153.48	153.72	6210300.0
2007-09-19 13:00:00	SPY	ETF	153.72	153.72	153.25	153.35	9710100.0
2007-09-19 13:30:00	SPY	ETF	153.36	153.63	153.22	153.425	9229100.0
2007-09-19 14:00:00	SPY	ETF	153.42	153.49	152.71	153.0	15056900.0
2007-09-19 14:30:00	SPY	ETF	153.0	153.46	152.94	153.34	11085500.0
2007-09-19 15:00:00	SPY	ETF	153.34	153.77	153.24	153.53	13140600.0
2007-09-19 15:30:00	SPY	ETF	153.53	153.7	153.0	153.36	17126900.0
2007-09-19 16:00:00	SPY	ETF	153.36	153.4756	152.4409	153.3	3430100.0
2007-09-19 16:30:00	SPY	ETF	153.24	153.26	153.06	153.09	2546900.0
2007-09-19 17:00:00	SPY	ETF	153.09	153.56	152.94	153.01	2468500.0
2007-09-19 17:30:00	SPY	ETF	153.05	153.1	153.03	153.07	89000.0
2007-09-19 18:00:00	SPY	ETF	153.07	153.07	153.0	153.0	35100.0
2007-09-19 18:30:00	SPY	ETF	153.04	153.1	153.04	153.09	1000.0
2007-09-19 19:00:00	SPY	ETF	153.1	153.11	153.07	153.07	10800.0
2007-09-19 19:30:00	SPY	ETF	153.09	153.09	153.0	153.04	1400.0
2007-09-19 04:00:00	QQQ	ETF	50.2	50.2	50.2	50.2	200.0
2007-09-19 05:30:00	QQQ	ETF	50.12	50.12	50.12	50.12	300.0
2007-09-19 06:30:00	QQQ	ETF	50.15	50.16	50.15	50.16	500.0
2007-09-19 07:00:00	QQQ	ETF	50.16	50.22	50.15	50.22	185190.0
2007-09-19 07:30:00	QQQ	ETF	50.23	50.23	50.1	50.15	162783.0
2007-09-19 08:00:00	QQQ	ETF	50.15	50.21	50.14	50.18	185512.0
2007-09-19 08:30:00	QQQ	ETF	50.18	50.33	50.14	50.29	1235358.0
2007-09-19 09:00:00	QQQ	ETF	50.29	50.35	50.28	50.29	683701.0
2007-09-19 09:30:00	QQQ	ETF	50.29	50.42	50.27	50.3594	13444113.0
2007-09-19 10:00:00	QQQ	ETF	50.35	50.5	50.29	50.409	8451269.0
2007-09-19 10:30:00	QQQ	ETF	50.4	50.51	50.09	50.47	7602577.0
2007-09-19 11:00:00	QQQ	ETF	50.4715	50.59	50.44	50.46	6859907.0
2007-09-19 11:30:00	QQQ	ETF	50.45	50.53	50.35	50.38	8536901.0
2007-09-19 12:00:00	QQQ	ETF	50.37	50.45	50.35	50.4301	2247101.0
2007-09-19 12:30:00	QQQ	ETF	50.43	50.44	50.33	50.39	3872719.0
2007-09-19 13:00:00	QQQ	ETF	50.39	50.4	50.2	50.21	7636125.0
2007-09-19 13:30:00	QQQ	ETF	50.21	50.3	50.15	50.24	7744626.0
2007-09-19 14:00:00	QQQ	ETF	50.24	50.27	49.98	50.02	12862261.0

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

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