PREVIEW / stock_30min / 2008-09-18

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-09-18.parquet
  size:    1.4 MB
  rows:    74,906
  symbols: 3,359

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-09-18 05:00:00	AAPL	Stock	4.6957	4.7786	4.6071	4.6429	54320.0
2008-09-18 06:30:00	AAPL	Stock	4.6896	4.6904	4.6782	4.6786	140000.0
2008-09-18 07:00:00	AAPL	Stock	4.675	4.6964	4.675	4.6875	162960.0
2008-09-18 07:30:00	AAPL	Stock	4.6875	4.6939	4.67	4.675	899192.0
2008-09-18 08:00:00	AAPL	Stock	4.6707	4.6786	4.5893	4.6243	2239608.0
2008-09-18 08:30:00	AAPL	Stock	4.6218	4.6407	4.6071	4.6382	1424976.0
2008-09-18 09:00:00	AAPL	Stock	4.6386	4.6764	4.5693	4.6636	4580660.0
2008-09-18 09:30:00	AAPL	Stock	4.6632	4.6939	4.6129	4.6782	137864048.0
2008-09-18 10:00:00	AAPL	Stock	4.6775	4.7375	4.6607	4.6786	103900412.0
2008-09-18 10:30:00	AAPL	Stock	4.6786	4.6789	4.42	4.4282	139403656.0
2008-09-18 11:00:00	AAPL	Stock	4.4286	4.4971	4.4182	4.4725	134722504.0
2008-09-18 11:30:00	AAPL	Stock	4.4729	4.5032	4.3893	4.4175	109396560.0
2008-09-18 12:00:00	AAPL	Stock	4.4186	4.4589	4.3725	4.41	97243048.0
2008-09-18 12:30:00	AAPL	Stock	4.4104	4.4107	4.31	4.3486	112609392.0
2008-09-18 13:00:00	AAPL	Stock	4.3482	4.4618	4.3257	4.4161	120695008.0
2008-09-18 13:30:00	AAPL	Stock	4.4168	4.5364	4.4118	4.4711	117358024.0
2008-09-18 14:00:00	AAPL	Stock	4.4707	4.4929	4.3964	4.4732	74888296.0
2008-09-18 14:30:00	AAPL	Stock	4.4718	4.5029	4.3618	4.4107	82884144.0
2008-09-18 15:00:00	AAPL	Stock	4.4107	4.6532	4.4004	4.6161	178024476.0
2008-09-18 15:30:00	AAPL	Stock	4.6154	4.8368	4.6021	4.7786	203971600.0
2008-09-18 16:00:00	AAPL	Stock	4.7786	4.8151	4.5174	4.8021	21670600.0
2008-09-18 16:30:00	AAPL	Stock	4.7893	4.8036	4.7255	4.8007	7805448.0
2008-09-18 17:00:00	AAPL	Stock	4.7896	4.7982	4.7889	4.7929	801248.0
2008-09-18 17:30:00	AAPL	Stock	4.7911	4.7979	4.7911	4.7964	75320.0
2008-09-18 18:00:00	AAPL	Stock	4.7964	4.8014	4.7825	4.8014	222376.0
2008-09-18 18:30:00	AAPL	Stock	4.8011	4.8193	4.8011	4.8171	263844.0
2008-09-18 19:00:00	AAPL	Stock	4.805	4.8368	4.805	4.8368	196280.0
2008-09-18 19:30:00	AAPL	Stock	4.8368	4.8893	4.8368	4.8821	783104.0
2008-09-18 07:00:00	MSFT	Stock	25.09	25.35	25.09	25.16	4600.0
2008-09-18 08:00:00	MSFT	Stock	24.84	24.99	24.65	24.66	44063.0
2008-09-18 08:30:00	MSFT	Stock	24.66	24.73	24.57	24.67	40114.0
2008-09-18 09:00:00	MSFT	Stock	24.67	24.85	24.57	24.81	204687.0
2008-09-18 09:30:00	MSFT	Stock	24.8	24.99	24.52	24.8	12578364.0
2008-09-18 10:00:00	MSFT	Stock	24.8	24.92	24.56	24.638	7334057.0
2008-09-18 10:30:00	MSFT	Stock	24.63	24.68	24.51	24.54	6768704.0
2008-09-18 11:00:00	MSFT	Stock	24.53	24.56	24.19	24.35	10115062.0
2008-09-18 11:30:00	MSFT	Stock	24.35	24.48	24.21	24.47	5693093.0
2008-09-18 12:00:00	MSFT	Stock	24.46	24.54	24.26	24.45	6707494.0
2008-09-18 12:30:00	MSFT	Stock	24.45	24.49	24.2	24.22	7762565.0
2008-09-18 13:00:00	MSFT	Stock	24.21	24.75	24.2	24.35	7448139.0
2008-09-18 13:30:00	MSFT	Stock	24.36	24.48	24.01	24.11	9767025.0
2008-09-18 14:00:00	MSFT	Stock	24.11	24.17	24.01	24.1	8348483.0
2008-09-18 14:30:00	MSFT	Stock	24.1	24.36	24.08	24.26	7899057.0
2008-09-18 15:00:00	MSFT	Stock	24.262	25.05	24.24	24.86	13021320.0
2008-09-18 15:30:00	MSFT	Stock	24.87	25.35	24.79	25.08	17449995.0
2008-09-18 16:00:00	MSFT	Stock	25.09	25.35	24.409	24.409	5938502.0
2008-09-18 16:30:00	MSFT	Stock	24.586	25.26	24.452	25.23	1271770.0
2008-09-18 17:00:00	MSFT	Stock	25.24	25.29	25.23	25.24	212084.0
2008-09-18 17:30:00	MSFT	Stock	25.26	25.3	25.25	25.25	4350.0
2008-09-18 18:00:00	MSFT	Stock	25.25	25.32	24.57	25.32	3300.0

> showing 50 of 74,906 rows — these rows as CSV

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