PREVIEW / stock_30min / 2008-01-30

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-01-30.parquet
  size:    1.2 MB
  rows:    70,754
  symbols: 3,269

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-30 04:30:00	AAPL	Stock	4.6786	4.6786	4.6786	4.6786	4200.0
2008-01-30 05:00:00	AAPL	Stock	4.6761	4.6761	4.6761	4.6761	5600.0
2008-01-30 06:30:00	AAPL	Stock	4.6886	4.6964	4.6786	4.6786	43400.0
2008-01-30 07:00:00	AAPL	Stock	4.6821	4.6821	4.6696	4.6696	28000.0
2008-01-30 07:30:00	AAPL	Stock	4.6696	4.6893	4.6696	4.6786	94668.0
2008-01-30 08:00:00	AAPL	Stock	4.6786	4.7014	4.675	4.6982	1327732.0
2008-01-30 08:30:00	AAPL	Stock	4.6964	4.6986	4.6821	4.6821	1134504.0
2008-01-30 09:00:00	AAPL	Stock	4.6839	4.7007	4.6839	4.6929	1204924.0
2008-01-30 09:30:00	AAPL	Stock	4.6929	4.7232	4.6518	4.6754	119788788.0
2008-01-30 10:00:00	AAPL	Stock	4.675	4.6868	4.6461	4.6785	94038000.0
2008-01-30 10:30:00	AAPL	Stock	4.6782	4.7196	4.6429	4.7118	80206588.0
2008-01-30 11:00:00	AAPL	Stock	4.7121	4.7321	4.6786	4.7057	55603660.0
2008-01-30 11:30:00	AAPL	Stock	4.7059	4.7171	4.6979	4.7111	40470360.0
2008-01-30 12:00:00	AAPL	Stock	4.7111	4.7275	4.7021	4.7221	34381760.0
2008-01-30 12:30:00	AAPL	Stock	4.7221	4.7261	4.7018	4.7132	28754376.0
2008-01-30 13:00:00	AAPL	Stock	4.7132	4.7343	4.7061	4.7075	46078984.0
2008-01-30 13:30:00	AAPL	Stock	4.7082	4.7196	4.6982	4.7146	28688912.0
2008-01-30 14:00:00	AAPL	Stock	4.7143	4.8289	4.7057	4.79	160322344.0
2008-01-30 14:30:00	AAPL	Stock	4.7894	4.82	4.7143	4.8171	197180704.0
2008-01-30 15:00:00	AAPL	Stock	4.8171	4.8375	4.7711	4.7989	168165396.0
2008-01-30 15:30:00	AAPL	Stock	4.7964	4.8107	4.7018	4.7211	162191624.0
2008-01-30 16:00:00	AAPL	Stock	4.7179	4.7403	4.6939	4.7071	17324160.0
2008-01-30 16:30:00	AAPL	Stock	4.7079	4.7403	4.6929	4.6929	1621312.0
2008-01-30 17:00:00	AAPL	Stock	4.6929	4.7566	4.6714	4.6761	900452.0
2008-01-30 17:30:00	AAPL	Stock	4.6761	4.6793	4.6486	4.6532	2290344.0
2008-01-30 18:00:00	AAPL	Stock	4.65	4.6675	4.65	4.6643	656180.0
2008-01-30 18:30:00	AAPL	Stock	4.6657	4.6664	4.6589	4.6596	281708.0
2008-01-30 19:00:00	AAPL	Stock	4.6596	4.6693	4.6539	4.6625	164780.0
2008-01-30 19:30:00	AAPL	Stock	4.6693	4.6779	4.6607	4.675	196336.0
2008-01-30 08:00:00	MSFT	Stock	32.55	32.6	32.35	32.55	23666.0
2008-01-30 08:30:00	MSFT	Stock	32.55	32.68	32.55	32.56	23051.0
2008-01-30 09:00:00	MSFT	Stock	32.56	32.59	32.55	32.57	28500.0
2008-01-30 09:30:00	MSFT	Stock	32.59	32.6	32.4	32.45	7572380.0
2008-01-30 10:00:00	MSFT	Stock	32.44	32.47	32.34	32.43	7422949.0
2008-01-30 10:30:00	MSFT	Stock	32.43	32.46	32.29	32.33	4746051.0
2008-01-30 11:00:00	MSFT	Stock	32.33	32.35	32.2	32.23	3454511.0
2008-01-30 11:30:00	MSFT	Stock	32.23	32.26	32.15	32.2	3568872.0
2008-01-30 12:00:00	MSFT	Stock	32.192	32.26	32.16	32.24	5807042.0
2008-01-30 12:30:00	MSFT	Stock	32.248	32.28	32.21	32.25	3055159.0
2008-01-30 13:00:00	MSFT	Stock	32.25	32.26	32.1	32.15	2649989.0
2008-01-30 13:30:00	MSFT	Stock	32.145	32.22	32.06	32.17	4009980.0
2008-01-30 14:00:00	MSFT	Stock	32.17	32.52	32.15	32.48	16561975.0
2008-01-30 14:30:00	MSFT	Stock	32.47	32.67	32.29	32.67	14743981.0
2008-01-30 15:00:00	MSFT	Stock	32.661	32.8	32.39	32.48	12353224.0
2008-01-30 15:30:00	MSFT	Stock	32.47	32.51	32.05	32.2	17205754.0
2008-01-30 16:00:00	MSFT	Stock	32.2	32.402	32.11	32.12	2729229.0
2008-01-30 16:30:00	MSFT	Stock	32.2	32.287	32.1	32.1	111087.0
2008-01-30 17:00:00	MSFT	Stock	32.1	32.364	32.01	32.03	63288.0
2008-01-30 17:30:00	MSFT	Stock	32.04	32.2	31.96	31.98	250665.0
2008-01-30 18:00:00	MSFT	Stock	31.99	32.0	31.9	32.0	55951.0

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

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