PREVIEW / stock_30min / 2008-04-03

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-04-03.parquet
  size:    1.2 MB
  rows:    68,576
  symbols: 3,250

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-04-03 06:00:00	AAPL	Stock	5.3071	5.3071	5.3071	5.3071	28000.0
2008-04-03 06:30:00	AAPL	Stock	5.2996	5.2996	5.2996	5.2996	2800.0
2008-04-03 07:00:00	AAPL	Stock	5.3	5.3114	5.2857	5.3114	78400.0
2008-04-03 07:30:00	AAPL	Stock	5.29	5.3175	5.2893	5.3125	127092.0
2008-04-03 08:00:00	AAPL	Stock	5.3093	5.3125	5.2821	5.2925	1422400.0
2008-04-03 08:30:00	AAPL	Stock	5.2882	5.2886	5.235	5.2496	2830800.0
2008-04-03 09:00:00	AAPL	Stock	5.2493	5.2586	5.2232	5.2554	2745848.0
2008-04-03 09:30:00	AAPL	Stock	5.2518	5.3332	5.25	5.3311	167341244.0
2008-04-03 10:00:00	AAPL	Stock	5.3307	5.3629	5.3164	5.3429	108572688.0
2008-04-03 10:30:00	AAPL	Stock	5.3432	5.3611	5.3229	5.3282	65538928.0
2008-04-03 11:00:00	AAPL	Stock	5.3275	5.3657	5.3221	5.3325	61691868.0
2008-04-03 11:30:00	AAPL	Stock	5.3325	5.3821	5.3289	5.3813	56006132.0
2008-04-03 12:00:00	AAPL	Stock	5.3796	5.3921	5.3682	5.3804	43112804.0
2008-04-03 12:30:00	AAPL	Stock	5.38	5.4561	5.3757	5.448	86026444.0
2008-04-03 13:00:00	AAPL	Stock	5.4468	5.4868	5.4411	5.4696	80868732.0
2008-04-03 13:30:00	AAPL	Stock	5.4707	5.4839	5.4211	5.4289	74980696.0
2008-04-03 14:00:00	AAPL	Stock	5.4289	5.4436	5.3964	5.4203	52602368.0
2008-04-03 14:30:00	AAPL	Stock	5.4198	5.465	5.4198	5.4639	59368596.0
2008-04-03 15:00:00	AAPL	Stock	5.4639	5.4739	5.4361	5.4389	59583720.0
2008-04-03 15:30:00	AAPL	Stock	5.4382	5.4436	5.3843	5.4143	103597536.0
2008-04-03 16:00:00	AAPL	Stock	5.4143	5.4175	5.3836	5.4104	9535064.0
2008-04-03 16:30:00	AAPL	Stock	5.4057	5.4201	5.4057	5.4201	732312.0
2008-04-03 17:00:00	AAPL	Stock	5.4114	5.42	5.4107	5.4186	193620.0
2008-04-03 17:30:00	AAPL	Stock	5.4211	5.4239	5.4196	5.4196	229404.0
2008-04-03 18:00:00	AAPL	Stock	5.4214	5.425	5.4214	5.4218	181132.0
2008-04-03 18:30:00	AAPL	Stock	5.4232	5.4232	5.4214	5.4214	31500.0
2008-04-03 19:00:00	AAPL	Stock	5.4229	5.4229	5.4207	5.4229	74172.0
2008-04-03 19:30:00	AAPL	Stock	5.4239	5.4239	5.4196	5.4214	69720.0
2008-04-03 07:00:00	MSFT	Stock	29.16	29.16	29.1	29.1	200.0
2008-04-03 08:00:00	MSFT	Stock	29.16	29.29	29.05	29.06	329269.0
2008-04-03 08:30:00	MSFT	Stock	29.06	29.06	28.96	28.99	16091.0
2008-04-03 09:00:00	MSFT	Stock	29.0	29.09	28.98	29.06	22155.0
2008-04-03 09:30:00	MSFT	Stock	29.05	29.15	28.88	28.99	3200537.0
2008-04-03 10:00:00	MSFT	Stock	28.99	29.1	28.84	28.93	4176437.0
2008-04-03 10:30:00	MSFT	Stock	28.93	28.95	28.8	28.86	2112099.0
2008-04-03 11:00:00	MSFT	Stock	28.852	29.0	28.85	29.0	2624726.0
2008-04-03 11:30:00	MSFT	Stock	28.99	29.1	28.98	29.06	2164159.0
2008-04-03 12:00:00	MSFT	Stock	29.06	29.19	29.06	29.15	1735760.0
2008-04-03 12:30:00	MSFT	Stock	29.142	29.27	29.12	29.24	2798909.0
2008-04-03 13:00:00	MSFT	Stock	29.23	29.32	29.22	29.23	1946016.0
2008-04-03 13:30:00	MSFT	Stock	29.23	29.24	29.04	29.04	2275565.0
2008-04-03 14:00:00	MSFT	Stock	29.042	29.18	29.04	29.12	1834127.0
2008-04-03 14:30:00	MSFT	Stock	29.13	29.25	29.03	29.24	1855712.0
2008-04-03 15:00:00	MSFT	Stock	29.23	29.25	29.08	29.09	2649250.0
2008-04-03 15:30:00	MSFT	Stock	29.08	29.1	28.94	29.0	6911341.0
2008-04-03 16:00:00	MSFT	Stock	28.98	29.14	28.98	29.058	1759793.0
2008-04-03 16:30:00	MSFT	Stock	29.06	29.06	29.0	29.0	2800.0
2008-04-03 17:30:00	MSFT	Stock	29.04	29.09	29.04	29.08	13785.0
2008-04-03 18:00:00	MSFT	Stock	29.07	29.09	29.07	29.08	43936.0
2008-04-03 18:30:00	MSFT	Stock	29.07	29.07	29.07	29.07	400.0

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

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