PREVIEW / stock_30min / 2008-12-15

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-12-15.parquet
  size:    1.2 MB
  rows:    69,409
  symbols: 3,337

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-12-15 04:00:00	AAPL	Stock	3.5096	3.5096	3.45	3.45	42000.0
2008-12-15 06:30:00	AAPL	Stock	3.4325	3.4325	3.4311	3.4311	5600.0
2008-12-15 07:00:00	AAPL	Stock	3.4075	3.4311	3.3679	3.3946	306040.0
2008-12-15 07:30:00	AAPL	Stock	3.3946	3.4286	3.3946	3.4243	867104.0
2008-12-15 08:00:00	AAPL	Stock	3.4275	3.4325	3.4143	3.43	2671536.0
2008-12-15 08:30:00	AAPL	Stock	3.4361	3.455	3.4286	3.4429	1482936.0
2008-12-15 09:00:00	AAPL	Stock	3.4414	3.4496	3.4225	3.4293	2565780.0
2008-12-15 09:30:00	AAPL	Stock	3.4289	3.4361	3.3796	3.3807	123178776.0
2008-12-15 10:00:00	AAPL	Stock	3.3804	3.3821	3.3268	3.3418	86874704.0
2008-12-15 10:30:00	AAPL	Stock	3.3414	3.3704	3.3357	3.3409	61942216.0
2008-12-15 11:00:00	AAPL	Stock	3.34	3.3839	3.3346	3.3794	64959608.0
2008-12-15 11:30:00	AAPL	Stock	3.3796	3.3825	3.3636	3.3693	46119808.0
2008-12-15 12:00:00	AAPL	Stock	3.3682	3.3782	3.3596	3.3686	35665588.0
2008-12-15 12:30:00	AAPL	Stock	3.3679	3.3721	3.3332	3.3518	48605648.0
2008-12-15 13:00:00	AAPL	Stock	3.3518	3.3518	3.3214	3.3435	51727032.0
2008-12-15 13:30:00	AAPL	Stock	3.3436	3.3486	3.3304	3.34	43126076.0
2008-12-15 14:00:00	AAPL	Stock	3.3396	3.3621	3.3368	3.3404	47182212.0
2008-12-15 14:30:00	AAPL	Stock	3.3407	3.3579	3.3364	3.3414	43443316.0
2008-12-15 15:00:00	AAPL	Stock	3.3407	3.3607	3.325	3.3378	68243560.0
2008-12-15 15:30:00	AAPL	Stock	3.3379	3.3864	3.3318	3.3839	138660648.0
2008-12-15 16:00:00	AAPL	Stock	3.3857	3.3929	3.3464	3.3882	19874148.0
2008-12-15 16:30:00	AAPL	Stock	3.3875	3.3918	3.3555	3.3879	1417388.0
2008-12-15 17:00:00	AAPL	Stock	3.3893	3.3911	3.3485	3.3485	139216.0
2008-12-15 17:30:00	AAPL	Stock	3.3864	3.3886	3.3857	3.3857	105616.0
2008-12-15 18:00:00	AAPL	Stock	3.3857	3.3857	3.3839	3.385	1343524.0
2008-12-15 18:30:00	AAPL	Stock	3.3868	3.3868	3.3821	3.3821	66108.0
2008-12-15 19:00:00	AAPL	Stock	3.3832	3.3843	3.3829	3.3836	87388.0
2008-12-15 19:30:00	AAPL	Stock	3.3854	3.3871	3.3821	3.3821	136976.0
2008-12-15 05:30:00	MSFT	Stock	19.59	19.59	19.59	19.59	200.0
2008-12-15 06:30:00	MSFT	Stock	19.6	19.6	19.6	19.6	900.0
2008-12-15 07:00:00	MSFT	Stock	19.58	19.58	19.58	19.58	300.0
2008-12-15 07:30:00	MSFT	Stock	19.5	19.5	19.5	19.5	800.0
2008-12-15 08:00:00	MSFT	Stock	19.5	19.5	19.39	19.39	10054.0
2008-12-15 08:30:00	MSFT	Stock	19.44	19.44	19.36	19.4	1650.0
2008-12-15 09:00:00	MSFT	Stock	19.43	19.49	19.35	19.37	46934.0
2008-12-15 09:30:00	MSFT	Stock	19.34	19.44	19.01	19.052	4983848.0
2008-12-15 10:00:00	MSFT	Stock	19.05	19.18	19.03	19.08	4343663.0
2008-12-15 10:30:00	MSFT	Stock	19.09	19.16	18.91	18.952	3771317.0
2008-12-15 11:00:00	MSFT	Stock	18.95	19.09	18.92	19.01	2948310.0
2008-12-15 11:30:00	MSFT	Stock	19.012	19.05	18.94	18.952	4519875.0
2008-12-15 12:00:00	MSFT	Stock	18.952	19.08	18.925	19.02	2583375.0
2008-12-15 12:30:00	MSFT	Stock	19.022	19.04	18.94	18.95	1909115.0
2008-12-15 13:00:00	MSFT	Stock	18.94	19.02	18.9	18.99	2462196.0
2008-12-15 13:30:00	MSFT	Stock	18.982	19.05	18.97	19.02	2505165.0
2008-12-15 14:00:00	MSFT	Stock	19.013	19.14	19.01	19.031	3097725.0
2008-12-15 14:30:00	MSFT	Stock	19.04	19.13	18.97	18.99	3305101.0
2008-12-15 15:00:00	MSFT	Stock	18.99	19.05	18.89	18.978	4292202.0
2008-12-15 15:30:00	MSFT	Stock	18.98	19.3	18.915	19.04	12396351.0
2008-12-15 16:00:00	MSFT	Stock	19.04	19.417	18.982	19.04	5795169.0
2008-12-15 16:30:00	MSFT	Stock	19.13	19.15	19.038	19.07	214151.0

> showing 50 of 69,409 rows — these rows as CSV

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