PREVIEW / stock_30min / 2008-06-02

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-06-02.parquet
  size:    1.3 MB
  rows:    70,220
  symbols: 3,325

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-06-02 05:00:00	AAPL	Stock	6.7143	6.7143	6.7143	6.7143	14000.0
2008-06-02 06:00:00	AAPL	Stock	6.7143	6.7143	6.7143	6.7143	10640.0
2008-06-02 07:00:00	AAPL	Stock	6.7025	6.7143	6.7025	6.7143	29400.0
2008-06-02 07:30:00	AAPL	Stock	6.7186	6.7186	6.7054	6.7143	223720.0
2008-06-02 08:00:00	AAPL	Stock	6.7143	6.7411	6.6961	6.7146	1818936.0
2008-06-02 08:30:00	AAPL	Stock	6.7143	6.7321	6.7143	6.725	587328.0
2008-06-02 09:00:00	AAPL	Stock	6.7271	6.7382	6.7236	6.7354	1827224.0
2008-06-02 09:30:00	AAPL	Stock	6.7339	6.7732	6.6982	6.7207	80560088.0
2008-06-02 10:00:00	AAPL	Stock	6.7192	6.7304	6.6614	6.6929	70081704.0
2008-06-02 10:30:00	AAPL	Stock	6.6921	6.7036	6.6657	6.6821	44783340.0
2008-06-02 11:00:00	AAPL	Stock	6.6825	6.6871	6.6482	6.6575	42091252.0
2008-06-02 11:30:00	AAPL	Stock	6.6579	6.6821	6.6486	6.6786	30493344.0
2008-06-02 12:00:00	AAPL	Stock	6.6786	6.6854	6.6643	6.6729	23859220.0
2008-06-02 12:30:00	AAPL	Stock	6.6725	6.6736	6.615	6.6164	51193128.0
2008-06-02 13:00:00	AAPL	Stock	6.6161	6.6221	6.5904	6.6054	52266592.0
2008-06-02 13:30:00	AAPL	Stock	6.6054	6.6171	6.5971	6.6121	31117800.0
2008-06-02 14:00:00	AAPL	Stock	6.6129	6.6161	6.5932	6.605	37251172.0
2008-06-02 14:30:00	AAPL	Stock	6.6057	6.6379	6.6054	6.6136	49539868.0
2008-06-02 15:00:00	AAPL	Stock	6.6129	6.6243	6.5929	6.6161	55247836.0
2008-06-02 15:30:00	AAPL	Stock	6.6161	6.6479	6.6139	6.6471	79460584.0
2008-06-02 16:00:00	AAPL	Stock	6.6471	6.6614	6.63	6.6464	18330144.0
2008-06-02 16:30:00	AAPL	Stock	6.6464	6.7411	6.6014	6.6471	487144.0
2008-06-02 17:00:00	AAPL	Stock	6.6479	6.6632	6.6432	6.6536	1010744.0
2008-06-02 17:30:00	AAPL	Stock	6.7411	6.7411	6.6486	6.6486	348488.0
2008-06-02 18:00:00	AAPL	Stock	6.6496	6.6543	6.6496	6.65	198212.0
2008-06-02 18:30:00	AAPL	Stock	6.6518	6.6543	6.65	6.6543	88564.0
2008-06-02 19:00:00	AAPL	Stock	6.6518	6.655	6.6493	6.65	189756.0
2008-06-02 19:30:00	AAPL	Stock	6.6554	6.6554	6.6493	6.6525	89684.0
2008-06-02 07:00:00	MSFT	Stock	28.23	28.32	28.22	28.22	900.0
2008-06-02 07:30:00	MSFT	Stock	28.22	28.22	28.2	28.2	300.0
2008-06-02 08:00:00	MSFT	Stock	28.22	28.32	28.2	28.26	21671.0
2008-06-02 08:30:00	MSFT	Stock	28.27	28.27	28.25	28.25	1474.0
2008-06-02 09:00:00	MSFT	Stock	28.27	28.35	28.22	28.25	19555.0
2008-06-02 09:30:00	MSFT	Stock	28.26	28.36	28.08	28.1	4003635.0
2008-06-02 10:00:00	MSFT	Stock	28.1	28.11	28.0	28.02	6738534.0
2008-06-02 10:30:00	MSFT	Stock	28.01	28.07	27.95	27.95	5427406.0
2008-06-02 11:00:00	MSFT	Stock	27.95	27.99	27.82	27.862	7527808.0
2008-06-02 11:30:00	MSFT	Stock	27.87	27.91	27.81	27.89	3461265.0
2008-06-02 12:00:00	MSFT	Stock	27.88	27.9	27.82	27.839	3130986.0
2008-06-02 12:30:00	MSFT	Stock	27.84	27.84	27.63	27.63	6902470.0
2008-06-02 13:00:00	MSFT	Stock	27.62	27.71	27.55	27.6	6693250.0
2008-06-02 13:30:00	MSFT	Stock	27.6	27.67	27.553	27.66	4824035.0
2008-06-02 14:00:00	MSFT	Stock	27.67	27.7	27.57	27.66	6298774.0
2008-06-02 14:30:00	MSFT	Stock	27.66	27.73	27.62	27.65	4370579.0
2008-06-02 15:00:00	MSFT	Stock	27.66	27.73	27.6	27.67	5439395.0
2008-06-02 15:30:00	MSFT	Stock	27.66	27.81	27.658	27.802	8290809.0
2008-06-02 16:00:00	MSFT	Stock	27.8	27.85	27.689	27.8	1700142.0
2008-06-02 16:30:00	MSFT	Stock	27.82	28.32	27.8	27.81	96698.0
2008-06-02 17:00:00	MSFT	Stock	27.81	27.84	27.8	27.81	33724.0
2008-06-02 17:30:00	MSFT	Stock	28.335	28.335	27.61	27.81	45771.0

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

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