PREVIEW / stock_30min / 2008-07-30

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-07-30.parquet
  size:    1.3 MB
  rows:    69,070
  symbols: 3,318

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-07-30 08:00:00	AAPL	Stock	5.6161	5.6589	5.6089	5.6429	1215396.0
2008-07-30 08:30:00	AAPL	Stock	5.6486	5.6532	5.61	5.6486	1569456.0
2008-07-30 09:00:00	AAPL	Stock	5.6496	5.6607	5.6325	5.6325	2118480.0
2008-07-30 09:30:00	AAPL	Stock	5.6339	5.6743	5.5971	5.6521	95217668.0
2008-07-30 10:00:00	AAPL	Stock	5.6518	5.7107	5.6514	5.7004	71970080.0
2008-07-30 10:30:00	AAPL	Stock	5.7	5.7318	5.6886	5.7007	74988760.0
2008-07-30 11:00:00	AAPL	Stock	5.7007	5.7079	5.6875	5.7018	32231024.0
2008-07-30 11:30:00	AAPL	Stock	5.7014	5.7107	5.6754	5.7054	30081520.0
2008-07-30 12:00:00	AAPL	Stock	5.7054	5.7089	5.6768	5.6918	26270524.0
2008-07-30 12:30:00	AAPL	Stock	5.6911	5.6921	5.6211	5.6229	50191596.0
2008-07-30 13:00:00	AAPL	Stock	5.6229	5.6539	5.5743	5.6426	70388668.0
2008-07-30 13:30:00	AAPL	Stock	5.6423	5.65	5.6082	5.6439	39983720.0
2008-07-30 14:00:00	AAPL	Stock	5.6443	5.6532	5.6114	5.6507	39369176.0
2008-07-30 14:30:00	AAPL	Stock	5.6507	5.6671	5.6339	5.6546	36563856.0
2008-07-30 15:00:00	AAPL	Stock	5.6543	5.675	5.6086	5.675	49426944.0
2008-07-30 15:30:00	AAPL	Stock	5.6761	5.715	5.6714	5.7136	86423344.0
2008-07-30 16:00:00	AAPL	Stock	5.7143	5.7143	5.61	5.7046	7593656.0
2008-07-30 16:30:00	AAPL	Stock	5.7061	5.71	5.6674	5.7025	2478056.0
2008-07-30 17:00:00	AAPL	Stock	5.7029	5.7054	5.61	5.7054	490812.0
2008-07-30 17:30:00	AAPL	Stock	5.705	5.7054	5.7021	5.7021	104216.0
2008-07-30 18:00:00	AAPL	Stock	5.7061	5.7214	5.7007	5.7014	649992.0
2008-07-30 18:30:00	AAPL	Stock	5.6986	5.7121	5.6964	5.7025	275044.0
2008-07-30 19:00:00	AAPL	Stock	5.7036	5.7089	5.7036	5.7089	14000.0
2008-07-30 19:30:00	AAPL	Stock	5.7107	5.7107	5.7039	5.7057	40180.0
2008-07-30 08:00:00	MSFT	Stock	26.12	26.12	26.11	26.11	1850.0
2008-07-30 08:30:00	MSFT	Stock	26.12	26.19	26.12	26.19	6666.0
2008-07-30 09:00:00	MSFT	Stock	26.19	26.27	26.11	26.18	9709.0
2008-07-30 09:30:00	MSFT	Stock	26.2	26.49	26.08	26.08	5934319.0
2008-07-30 10:00:00	MSFT	Stock	26.09	26.49	26.08	26.43	4196148.0
2008-07-30 10:30:00	MSFT	Stock	26.43	26.47	26.26	26.3	4000517.0
2008-07-30 11:00:00	MSFT	Stock	26.29	26.34	26.14	26.18	3104085.0
2008-07-30 11:30:00	MSFT	Stock	26.19	26.32	26.19	26.261	2220292.0
2008-07-30 12:00:00	MSFT	Stock	26.27	26.28	26.11	26.14	1834993.0
2008-07-30 12:30:00	MSFT	Stock	26.13	26.14	25.98	26.05	3485786.0
2008-07-30 13:00:00	MSFT	Stock	26.04	26.11	26.0	26.091	3146396.0
2008-07-30 13:30:00	MSFT	Stock	26.09	26.1	25.93	25.98	3381080.0
2008-07-30 14:00:00	MSFT	Stock	25.99	26.03	25.91	26.01	5063885.0
2008-07-30 14:30:00	MSFT	Stock	26.0	26.1	26.0	26.07	3580473.0
2008-07-30 15:00:00	MSFT	Stock	26.07	26.1	25.9	26.06	3231331.0
2008-07-30 15:30:00	MSFT	Stock	26.06	26.29	26.06	26.23	6303912.0
2008-07-30 16:00:00	MSFT	Stock	26.21	26.23	26.05	26.16	1682808.0
2008-07-30 16:30:00	MSFT	Stock	26.23	26.23	26.18	26.18	309313.0
2008-07-30 17:00:00	MSFT	Stock	26.17	26.2	26.17	26.2	900.0
2008-07-30 17:30:00	MSFT	Stock	26.18	26.18	26.18	26.18	100.0
2008-07-30 18:00:00	MSFT	Stock	26.2	26.23	26.2	26.23	10261.0
2008-07-30 18:30:00	MSFT	Stock	26.2	26.2	26.2	26.2	700.0
2008-07-30 19:00:00	MSFT	Stock	26.2	26.2	26.2	26.2	500.0
2008-07-30 19:30:00	MSFT	Stock	26.18	26.18	26.18	26.18	1227.0
2008-07-30 08:00:00	NVDA	Stock	0.2925	0.2925	0.2925	0.2925	92000.0
2008-07-30 08:30:00	NVDA	Stock	0.293	0.2968	0.293	0.2968	116000.0

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

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