PREVIEW / stock_30min / 2008-10-02

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-10-02.parquet
  size:    1.2 MB
  rows:    69,394
  symbols: 3,354

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-10-02 05:30:00	AAPL	Stock	3.9643	3.9643	3.9643	3.9643	2800.0
2008-10-02 06:00:00	AAPL	Stock	3.9643	3.9643	3.9643	3.9643	2800.0
2008-10-02 06:30:00	AAPL	Stock	3.9464	3.9464	3.9464	3.9464	2800.0
2008-10-02 07:00:00	AAPL	Stock	3.9357	3.9443	3.9071	3.9286	125300.0
2008-10-02 07:30:00	AAPL	Stock	3.915	3.915	3.8679	3.875	231028.0
2008-10-02 08:00:00	AAPL	Stock	3.8929	3.8929	3.8614	3.8614	733432.0
2008-10-02 08:30:00	AAPL	Stock	3.8586	3.8586	3.8307	3.8504	1300236.0
2008-10-02 09:00:00	AAPL	Stock	3.8443	3.875	3.8282	3.8579	2851044.0
2008-10-02 09:30:00	AAPL	Stock	3.8575	3.8854	3.8036	3.8136	122796604.0
2008-10-02 10:00:00	AAPL	Stock	3.8125	3.8136	3.6436	3.6804	150868676.0
2008-10-02 10:30:00	AAPL	Stock	3.6807	3.6911	3.6021	3.6529	146760880.0
2008-10-02 11:00:00	AAPL	Stock	3.6534	3.7232	3.6207	3.7118	103044536.0
2008-10-02 11:30:00	AAPL	Stock	3.7114	3.7536	3.6986	3.7496	81031132.0
2008-10-02 12:00:00	AAPL	Stock	3.7496	3.7679	3.7179	3.7204	68289732.0
2008-10-02 12:30:00	AAPL	Stock	3.7193	3.7543	3.7096	3.74	54669636.0
2008-10-02 13:00:00	AAPL	Stock	3.74	3.7407	3.6636	3.6836	77339416.0
2008-10-02 13:30:00	AAPL	Stock	3.6836	3.6964	3.6357	3.6811	128355724.0
2008-10-02 14:00:00	AAPL	Stock	3.6807	3.715	3.6339	3.6396	114523528.0
2008-10-02 14:30:00	AAPL	Stock	3.6407	3.6607	3.6036	3.6396	125864676.0
2008-10-02 15:00:00	AAPL	Stock	3.6386	3.6432	3.5771	3.59	169174796.0
2008-10-02 15:30:00	AAPL	Stock	3.5905	3.6354	3.5714	3.575	222205536.0
2008-10-02 16:00:00	AAPL	Stock	3.575	3.6762	3.5736	3.6054	23934008.0
2008-10-02 16:30:00	AAPL	Stock	3.6064	3.6107	3.575	3.5964	4163824.0
2008-10-02 17:00:00	AAPL	Stock	3.5929	3.6064	3.5911	3.6064	372036.0
2008-10-02 17:30:00	AAPL	Stock	3.6061	3.6781	3.5946	3.5986	293748.0
2008-10-02 18:00:00	AAPL	Stock	3.5986	3.6018	3.5954	3.5982	352268.0
2008-10-02 18:30:00	AAPL	Stock	3.6007	3.6071	3.5968	3.6064	438788.0
2008-10-02 19:00:00	AAPL	Stock	3.6039	3.6346	3.6036	3.6168	411740.0
2008-10-02 19:30:00	AAPL	Stock	3.6136	3.6214	3.6079	3.6143	231280.0
2008-10-02 07:00:00	MSFT	Stock	26.31	26.31	26.31	26.31	500.0
2008-10-02 07:30:00	MSFT	Stock	26.11	26.16	26.11	26.16	1000.0
2008-10-02 08:00:00	MSFT	Stock	26.2	26.48	26.2	26.48	11155.0
2008-10-02 08:30:00	MSFT	Stock	26.32	26.6	26.18	26.18	15901.0
2008-10-02 09:00:00	MSFT	Stock	26.18	26.28	26.15	26.24	28417.0
2008-10-02 09:30:00	MSFT	Stock	26.2	26.27	25.83	25.87	9004963.0
2008-10-02 10:00:00	MSFT	Stock	25.86	25.9	25.7	25.88	7966056.0
2008-10-02 10:30:00	MSFT	Stock	25.88	26.05	25.82	25.91	6702400.0
2008-10-02 11:00:00	MSFT	Stock	25.9	26.1	25.87	26.1	4834751.0
2008-10-02 11:30:00	MSFT	Stock	26.1	26.2	25.97	26.16	3865093.0
2008-10-02 12:00:00	MSFT	Stock	26.15	26.17	25.96	25.983	4289058.0
2008-10-02 12:30:00	MSFT	Stock	25.99	26.07	25.91	26.06	2691176.0
2008-10-02 13:00:00	MSFT	Stock	26.063	26.1	25.89	26.1	3907134.0
2008-10-02 13:30:00	MSFT	Stock	26.1	26.38	26.065	26.3	6073611.0
2008-10-02 14:00:00	MSFT	Stock	26.3	26.49	26.21	26.21	4930087.0
2008-10-02 14:30:00	MSFT	Stock	26.22	26.31	26.14	26.27	5496134.0
2008-10-02 15:00:00	MSFT	Stock	26.27	26.343	26.15	26.28	8465379.0
2008-10-02 15:30:00	MSFT	Stock	26.28	26.53	26.04	26.3	18315758.0
2008-10-02 16:00:00	MSFT	Stock	26.323	26.57	26.05	26.39	3909099.0
2008-10-02 16:30:00	MSFT	Stock	26.25	26.5	26.25	26.38	260008.0
2008-10-02 17:00:00	MSFT	Stock	26.25	26.38	26.24	26.24	707634.0

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

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