PREVIEW / stock_30min / 2008-01-31

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-01-31.parquet
  size:    1.3 MB
  rows:    71,830
  symbols: 3,271

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-01-31 05:00:00	AAPL	Stock	4.6489	4.6489	4.6489	4.6489	3248.0
2008-01-31 07:00:00	AAPL	Stock	4.6786	4.6786	4.6786	4.6786	8400.0
2008-01-31 07:30:00	AAPL	Stock	4.6857	4.6946	4.6786	4.6904	28000.0
2008-01-31 08:00:00	AAPL	Stock	4.685	4.7143	4.675	4.7	860804.0
2008-01-31 08:30:00	AAPL	Stock	4.6982	4.6982	4.6282	4.6282	3688944.0
2008-01-31 09:00:00	AAPL	Stock	4.6282	4.6396	4.5868	4.6221	9698164.0
2008-01-31 09:30:00	AAPL	Stock	4.6229	4.6875	4.6214	4.6789	160526492.0
2008-01-31 10:00:00	AAPL	Stock	4.6779	4.7107	4.6621	4.6943	115385200.0
2008-01-31 10:30:00	AAPL	Stock	4.695	4.7164	4.6743	4.7043	76539400.0
2008-01-31 11:00:00	AAPL	Stock	4.7046	4.7632	4.6896	4.7561	89043332.0
2008-01-31 11:30:00	AAPL	Stock	4.7557	4.8057	4.7404	4.7943	109199440.0
2008-01-31 12:00:00	AAPL	Stock	4.7946	4.8136	4.7736	4.8125	83725320.0
2008-01-31 12:30:00	AAPL	Stock	4.8125	4.8239	4.7768	4.7868	84606060.0
2008-01-31 13:00:00	AAPL	Stock	4.7864	4.7975	4.7707	4.7782	59704400.0
2008-01-31 13:30:00	AAPL	Stock	4.7775	4.8218	4.7764	4.807	61828452.0
2008-01-31 14:00:00	AAPL	Stock	4.8086	4.8393	4.7889	4.8204	81280780.0
2008-01-31 14:30:00	AAPL	Stock	4.8207	4.8446	4.805	4.8357	84490560.0
2008-01-31 15:00:00	AAPL	Stock	4.8357	4.87	4.8221	4.8611	115617460.0
2008-01-31 15:30:00	AAPL	Stock	4.8607	4.8804	4.7968	4.8211	155710240.0
2008-01-31 16:00:00	AAPL	Stock	4.8211	4.8489	4.6804	4.8343	47792920.0
2008-01-31 16:30:00	AAPL	Stock	4.7571	4.8343	4.7504	4.7786	2816184.0
2008-01-31 17:00:00	AAPL	Stock	4.7804	4.8343	4.7786	4.7821	1362704.0
2008-01-31 17:30:00	AAPL	Stock	4.7821	4.7839	4.7668	4.775	329448.0
2008-01-31 18:00:00	AAPL	Stock	4.7746	4.8343	4.7746	4.7929	775572.0
2008-01-31 18:30:00	AAPL	Stock	4.7875	4.7946	4.7875	4.7946	200592.0
2008-01-31 19:00:00	AAPL	Stock	4.7946	4.8018	4.7896	4.8018	175532.0
2008-01-31 19:30:00	AAPL	Stock	4.8029	4.8036	4.7964	4.8	300496.0
2008-01-31 06:30:00	MSFT	Stock	32.04	32.2	32.04	32.2	800.0
2008-01-31 07:00:00	MSFT	Stock	32.1	32.2	32.1	32.1	1100.0
2008-01-31 07:30:00	MSFT	Stock	32.12	32.3	32.1	32.2	66342.0
2008-01-31 08:00:00	MSFT	Stock	32.15	32.15	32.09	32.1	17301.0
2008-01-31 08:30:00	MSFT	Stock	32.1	32.1	31.85	31.91	58801.0
2008-01-31 09:00:00	MSFT	Stock	31.91	31.98	31.8	31.9	62548.0
2008-01-31 09:30:00	MSFT	Stock	31.9	31.97	31.78	31.94	11345141.0
2008-01-31 10:00:00	MSFT	Stock	31.94	31.99	31.77	31.86	8031926.0
2008-01-31 10:30:00	MSFT	Stock	31.85	31.88	31.72	31.859	6069304.0
2008-01-31 11:00:00	MSFT	Stock	31.86	32.06	31.75	31.99	6093852.0
2008-01-31 11:30:00	MSFT	Stock	31.99	32.42	31.93	32.2	7814657.0
2008-01-31 12:00:00	MSFT	Stock	32.2	32.21	32.01	32.093	3390054.0
2008-01-31 12:30:00	MSFT	Stock	32.1	33.0	32.02	32.118	3442956.0
2008-01-31 13:00:00	MSFT	Stock	32.12	32.16	32.02	32.15	3322601.0
2008-01-31 13:30:00	MSFT	Stock	32.14	32.4	32.14	32.31	6972315.0
2008-01-31 14:00:00	MSFT	Stock	32.3	32.52	32.25	32.37	6503116.0
2008-01-31 14:30:00	MSFT	Stock	32.38	32.63	32.26	32.53	5937615.0
2008-01-31 15:00:00	MSFT	Stock	32.53	32.54	32.39	32.45	6817565.0
2008-01-31 15:30:00	MSFT	Stock	32.45	32.74	32.34	32.54	16538528.0
2008-01-31 16:00:00	MSFT	Stock	32.51	32.6	31.96	32.6	9390704.0
2008-01-31 16:30:00	MSFT	Stock	32.3	32.6	32.2	32.35	1330955.0
2008-01-31 17:00:00	MSFT	Stock	32.4	32.6	32.3	32.33	138270.0
2008-01-31 17:30:00	MSFT	Stock	32.33	32.63	32.33	32.398	18082.0

> showing 50 of 71,830 rows — these rows as CSV

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