PREVIEW / stock_30min / 2008-11-13

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-11-13.parquet
  size:    1.2 MB
  rows:    70,587
  symbols: 3,327

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-11-13 05:00:00	AAPL	Stock	3.1746	3.1814	3.1746	3.1814	14000.0
2008-11-13 05:30:00	AAPL	Stock	3.1629	3.1629	3.1429	3.1429	36512.0
2008-11-13 06:00:00	AAPL	Stock	3.1429	3.1607	3.1429	3.1607	6888.0
2008-11-13 06:30:00	AAPL	Stock	3.16	3.1607	3.16	3.1607	39200.0
2008-11-13 07:00:00	AAPL	Stock	3.1807	3.2143	3.1807	3.2	93772.0
2008-11-13 07:30:00	AAPL	Stock	3.2143	3.2679	3.1968	3.2	534268.0
2008-11-13 08:00:00	AAPL	Stock	3.2	3.2064	3.1786	3.1857	1210216.0
2008-11-13 08:30:00	AAPL	Stock	3.1857	3.1964	3.1596	3.1611	2496844.0
2008-11-13 09:00:00	AAPL	Stock	3.1621	3.2143	3.1621	3.2071	4216940.0
2008-11-13 09:30:00	AAPL	Stock	3.2075	3.2732	3.1721	3.1782	194023396.0
2008-11-13 10:00:00	AAPL	Stock	3.1775	3.2589	3.1436	3.2468	186080636.0
2008-11-13 10:30:00	AAPL	Stock	3.2475	3.2539	3.2018	3.2075	146710144.0
2008-11-13 11:00:00	AAPL	Stock	3.2082	3.2221	3.1686	3.1964	90776168.0
2008-11-13 11:30:00	AAPL	Stock	3.1968	3.2096	3.1625	3.1818	66828524.0
2008-11-13 12:00:00	AAPL	Stock	3.1819	3.1896	3.1446	3.1482	60318692.0
2008-11-13 12:30:00	AAPL	Stock	3.1479	3.1675	3.0739	3.0739	106042748.0
2008-11-13 13:00:00	AAPL	Stock	3.0754	3.1604	3.0721	3.1604	109849124.0
2008-11-13 13:30:00	AAPL	Stock	3.1604	3.25	3.1482	3.1934	161430920.0
2008-11-13 14:00:00	AAPL	Stock	3.1936	3.3393	3.1829	3.3311	158911872.0
2008-11-13 14:30:00	AAPL	Stock	3.3264	3.3768	3.2936	3.3304	189830032.0
2008-11-13 15:00:00	AAPL	Stock	3.3318	3.3636	3.2857	3.3632	132556116.0
2008-11-13 15:30:00	AAPL	Stock	3.3632	3.4429	3.3464	3.4404	178040072.0
2008-11-13 16:00:00	AAPL	Stock	3.4404	3.4821	3.2106	3.4425	24937528.0
2008-11-13 16:30:00	AAPL	Stock	3.4425	3.4443	3.435	3.4375	12226032.0
2008-11-13 17:00:00	AAPL	Stock	3.4357	3.4429	3.4346	3.4382	570976.0
2008-11-13 17:30:00	AAPL	Stock	3.4379	3.44	3.4354	3.4354	223720.0
2008-11-13 18:00:00	AAPL	Stock	3.4354	3.4393	3.4332	3.4357	244580.0
2008-11-13 18:30:00	AAPL	Stock	3.4339	3.4393	3.4325	3.4339	269220.0
2008-11-13 19:00:00	AAPL	Stock	3.4339	3.4357	3.4304	3.4304	151284.0
2008-11-13 19:30:00	AAPL	Stock	3.4293	3.4293	3.4239	3.4268	661472.0
2008-11-13 04:00:00	MSFT	Stock	20.0	20.2	20.0	20.2	700.0
2008-11-13 04:30:00	MSFT	Stock	20.2	20.2	20.2	20.2	100.0
2008-11-13 06:00:00	MSFT	Stock	20.01	20.01	20.01	20.01	500.0
2008-11-13 06:30:00	MSFT	Stock	20.19	20.19	20.19	20.19	1000.0
2008-11-13 07:00:00	MSFT	Stock	20.07	20.1	20.06	20.1	5878.0
2008-11-13 07:30:00	MSFT	Stock	20.15	20.15	20.13	20.13	21600.0
2008-11-13 08:00:00	MSFT	Stock	20.13	20.14	20.05	20.1	21231.0
2008-11-13 08:30:00	MSFT	Stock	20.06	20.15	20.0	20.15	24406.0
2008-11-13 09:00:00	MSFT	Stock	20.15	20.28	20.11	20.15	117938.0
2008-11-13 09:30:00	MSFT	Stock	20.14	20.3	19.6	19.72	12630455.0
2008-11-13 10:00:00	MSFT	Stock	19.71	20.0	19.6	19.87	11330150.0
2008-11-13 10:30:00	MSFT	Stock	19.87	19.93	19.51	19.62	7283433.0
2008-11-13 11:00:00	MSFT	Stock	19.61	19.68	19.27	19.45	7841583.0
2008-11-13 11:30:00	MSFT	Stock	19.44	19.49	19.29	19.35	4511064.0
2008-11-13 12:00:00	MSFT	Stock	19.34	19.39	19.1	19.12	6446772.0
2008-11-13 12:30:00	MSFT	Stock	19.12	19.29	18.75	18.75	11045027.0
2008-11-13 13:00:00	MSFT	Stock	18.75	19.12	18.74	19.12	9036254.0
2008-11-13 13:30:00	MSFT	Stock	19.12	19.83	18.94	19.48	11790184.0
2008-11-13 14:00:00	MSFT	Stock	19.48	19.99	19.34	19.935	9960907.0
2008-11-13 14:30:00	MSFT	Stock	19.94	20.4	19.86	20.09	12831584.0

> showing 50 of 70,587 rows — these rows as CSV

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