PREVIEW / stock_30min / 2010-07-01

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-07-01.parquet
  size:    1.4 MB
  rows:    74,679
  symbols: 3,459

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
2010-07-01 04:00:00	AAPL	Stock	9.0	9.0	9.0	9.0	5600.0
2010-07-01 04:30:00	AAPL	Stock	9.0357	9.05	9.0357	9.05	30800.0
2010-07-01 05:00:00	AAPL	Stock	9.0532	9.0532	9.0321	9.0321	12208.0
2010-07-01 06:00:00	AAPL	Stock	9.0686	9.0686	9.0686	9.0686	14000.0
2010-07-01 06:30:00	AAPL	Stock	9.0686	9.1079	9.0614	9.1079	55160.0
2010-07-01 07:00:00	AAPL	Stock	9.1	9.1	9.0396	9.0636	349104.0
2010-07-01 07:30:00	AAPL	Stock	9.05	9.0536	8.9911	9.0336	691768.0
2010-07-01 08:00:00	AAPL	Stock	9.0286	9.0357	8.9832	9.0239	2137184.0
2010-07-01 08:30:00	AAPL	Stock	9.02	9.0686	8.9832	9.0679	7180796.0
2010-07-01 09:00:00	AAPL	Stock	9.0686	9.1214	9.0643	9.0811	6718292.0
2010-07-01 09:30:00	AAPL	Stock	9.0821	9.1	8.9329	8.9532	145898032.0
2010-07-01 10:00:00	AAPL	Stock	8.9532	8.9561	8.7896	8.8065	154952112.0
2010-07-01 10:30:00	AAPL	Stock	8.8093	8.8189	8.6864	8.7711	125287484.0
2010-07-01 11:00:00	AAPL	Stock	8.7704	8.8771	8.7393	8.8771	83870472.0
2010-07-01 11:30:00	AAPL	Stock	8.8771	8.8993	8.8327	8.87	68738516.0
2010-07-01 12:00:00	AAPL	Stock	8.8696	8.8714	8.8232	8.8425	33889884.0
2010-07-01 12:30:00	AAPL	Stock	8.8424	8.9454	8.819	8.8846	62600440.0
2010-07-01 13:00:00	AAPL	Stock	8.8791	8.9086	8.8482	8.85	35524076.0
2010-07-01 13:30:00	AAPL	Stock	8.8493	8.9089	8.8479	8.8968	42785932.0
2010-07-01 14:00:00	AAPL	Stock	8.895	8.9375	8.8718	8.8843	44495528.0
2010-07-01 14:30:00	AAPL	Stock	8.8843	8.8921	8.7946	8.856	54500964.0
2010-07-01 15:00:00	AAPL	Stock	8.8564	8.8929	8.815	8.8729	48071996.0
2010-07-01 15:30:00	AAPL	Stock	8.8736	8.9054	8.8232	8.8739	80268356.0
2010-07-01 16:00:00	AAPL	Stock	8.8739	9.0814	8.8464	8.9832	15690640.0
2010-07-01 16:30:00	AAPL	Stock	8.8718	8.8718	8.85	8.8575	510132.0
2010-07-01 17:00:00	AAPL	Stock	8.9832	8.9832	8.8589	8.875	328804.0
2010-07-01 17:30:00	AAPL	Stock	8.87	8.8804	8.87	8.8768	117068.0
2010-07-01 18:00:00	AAPL	Stock	8.8732	8.8789	8.8725	8.8725	262892.0
2010-07-01 18:30:00	AAPL	Stock	8.875	8.8857	8.875	8.8857	30800.0
2010-07-01 19:00:00	AAPL	Stock	8.8857	8.8882	8.8804	8.8864	132552.0
2010-07-01 19:30:00	AAPL	Stock	8.8857	8.9	8.8807	8.8829	289492.0
2010-07-01 06:00:00	MSFT	Stock	22.97	22.97	22.97	22.97	1500.0
2010-07-01 07:00:00	MSFT	Stock	23.05	23.06	23.05	23.06	61000.0
2010-07-01 07:30:00	MSFT	Stock	23.05	23.1	23.05	23.1	30584.0
2010-07-01 08:00:00	MSFT	Stock	23.1	23.1	23.01	23.05	105488.0
2010-07-01 08:30:00	MSFT	Stock	23.04	23.12	22.94	23.12	97905.0
2010-07-01 09:00:00	MSFT	Stock	23.11	23.2	23.05	23.1	183165.0
2010-07-01 09:30:00	MSFT	Stock	23.1	23.25	23.05	23.19	7125902.0
2010-07-01 10:00:00	MSFT	Stock	23.19	23.2	22.9	22.92	10176104.0
2010-07-01 10:30:00	MSFT	Stock	22.92	22.95	22.73	22.87	7230018.0
2010-07-01 11:00:00	MSFT	Stock	22.87	23.12	22.85	23.1	7807496.0
2010-07-01 11:30:00	MSFT	Stock	23.1	23.11	22.94	23.016	6341546.0
2010-07-01 12:00:00	MSFT	Stock	23.015	23.025	22.91	22.99	3885403.0
2010-07-01 12:30:00	MSFT	Stock	22.985	23.19	22.96	23.14	4611449.0
2010-07-01 13:00:00	MSFT	Stock	23.14	23.24	23.11	23.14	3543025.0
2010-07-01 13:30:00	MSFT	Stock	23.14	23.32	23.131	23.23	5591039.0
2010-07-01 14:00:00	MSFT	Stock	23.24	23.265	23.07	23.1	5840302.0
2010-07-01 14:30:00	MSFT	Stock	23.095	23.125	23.0	23.095	5354373.0
2010-07-01 15:00:00	MSFT	Stock	23.09	23.22	23.05	23.21	5561026.0
2010-07-01 15:30:00	MSFT	Stock	23.215	23.31	23.08	23.18	11162638.0

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

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