PREVIEW / stock_30min / 2010-04-29

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-04-29.parquet
  size:    1.4 MB
  rows:    75,631
  symbols: 3,498

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-04-29 04:00:00	AAPL	Stock	9.3679	9.3679	9.3679	9.3679	5600.0
2010-04-29 04:30:00	AAPL	Stock	9.3714	9.3714	9.3714	9.3714	3220.0
2010-04-29 05:30:00	AAPL	Stock	9.3746	9.4	9.3507	9.4	53424.0
2010-04-29 06:00:00	AAPL	Stock	9.4	9.4107	9.4	9.4036	47208.0
2010-04-29 06:30:00	AAPL	Stock	9.4029	9.4036	9.3936	9.4029	64400.0
2010-04-29 07:00:00	AAPL	Stock	9.4036	9.4214	9.4036	9.4179	207060.0
2010-04-29 07:30:00	AAPL	Stock	9.4079	9.4121	9.4029	9.4107	206780.0
2010-04-29 08:00:00	AAPL	Stock	9.4032	9.4129	9.375	9.4086	1629432.0
2010-04-29 08:30:00	AAPL	Stock	9.4075	9.4096	9.3839	9.3886	883708.0
2010-04-29 09:00:00	AAPL	Stock	9.3857	9.3982	9.3857	9.3946	1195572.0
2010-04-29 09:30:00	AAPL	Stock	9.3946	9.4961	9.3575	9.4961	94089688.0
2010-04-29 10:00:00	AAPL	Stock	9.496	9.5429	9.4707	9.5397	61682012.0
2010-04-29 10:30:00	AAPL	Stock	9.5386	9.5518	9.5264	9.548	40677644.0
2010-04-29 11:00:00	AAPL	Stock	9.5471	9.5761	9.5375	9.575	43003100.0
2010-04-29 11:30:00	AAPL	Stock	9.5736	9.5889	9.5646	9.5736	31587192.0
2010-04-29 12:00:00	AAPL	Stock	9.5736	9.6	9.5679	9.5942	25660488.0
2010-04-29 12:30:00	AAPL	Stock	9.5929	9.6232	9.5893	9.6189	29727404.0
2010-04-29 13:00:00	AAPL	Stock	9.6189	9.6386	9.6121	9.6146	29672636.0
2010-04-29 13:30:00	AAPL	Stock	9.6162	9.6339	9.5964	9.6329	26694528.0
2010-04-29 14:00:00	AAPL	Stock	9.6337	9.6429	9.6071	9.6114	40653760.0
2010-04-29 14:30:00	AAPL	Stock	9.6114	9.63	9.5725	9.5893	38660720.0
2010-04-29 15:00:00	AAPL	Stock	9.5879	9.6196	9.5782	9.6166	30054332.0
2010-04-29 15:30:00	AAPL	Stock	9.6171	9.6221	9.5914	9.5929	45315228.0
2010-04-29 16:00:00	AAPL	Stock	9.5929	9.6131	9.5533	9.6021	10026968.0
2010-04-29 16:30:00	AAPL	Stock	9.6156	9.6156	9.6021	9.6025	961800.0
2010-04-29 17:00:00	AAPL	Stock	9.6025	9.6032	9.6	9.6014	132216.0
2010-04-29 17:30:00	AAPL	Stock	9.6011	9.6014	9.5968	9.6014	98084.0
2010-04-29 18:00:00	AAPL	Stock	9.6011	9.6118	9.5943	9.6043	239456.0
2010-04-29 18:30:00	AAPL	Stock	9.6071	9.6071	9.6036	9.6068	37604.0
2010-04-29 19:00:00	AAPL	Stock	9.6068	9.6071	9.5982	9.5982	73976.0
2010-04-29 19:30:00	AAPL	Stock	9.5982	9.5986	9.575	9.575	270480.0
2010-04-29 06:00:00	MSFT	Stock	30.94	30.94	30.79	30.8	3300.0
2010-04-29 07:00:00	MSFT	Stock	30.8	30.84	30.8	30.84	2250.0
2010-04-29 07:30:00	MSFT	Stock	30.84	30.91	30.84	30.9	9849.0
2010-04-29 08:00:00	MSFT	Stock	30.9	30.92	30.86	30.92	17385.0
2010-04-29 08:30:00	MSFT	Stock	30.9	30.95	30.87	30.95	17039.0
2010-04-29 09:00:00	MSFT	Stock	30.97	31.02	30.91	30.96	65810.0
2010-04-29 09:30:00	MSFT	Stock	30.96	30.97	30.67	30.85	5885527.0
2010-04-29 10:00:00	MSFT	Stock	30.85	30.89	30.83	30.87	4092746.0
2010-04-29 10:30:00	MSFT	Stock	30.88	30.926	30.85	30.878	4618635.0
2010-04-29 11:00:00	MSFT	Stock	30.88	30.9	30.84	30.89	4100565.0
2010-04-29 11:30:00	MSFT	Stock	30.895	30.9	30.86	30.89	3521956.0
2010-04-29 12:00:00	MSFT	Stock	30.885	31.0	30.88	30.99	3012901.0
2010-04-29 12:30:00	MSFT	Stock	30.98	31.13	30.97	31.105	3858020.0
2010-04-29 13:00:00	MSFT	Stock	31.105	31.14	31.0	31.0	3103512.0
2010-04-29 13:30:00	MSFT	Stock	31.01	31.12	31.0	31.113	2568011.0
2010-04-29 14:00:00	MSFT	Stock	31.12	31.433	31.04	31.073	2368402.0
2010-04-29 14:30:00	MSFT	Stock	31.08	31.125	31.05	31.1	3187145.0
2010-04-29 15:00:00	MSFT	Stock	31.09	31.11	31.055	31.105	2878311.0
2010-04-29 15:30:00	MSFT	Stock	31.11	31.13	30.99	31.04	6242338.0

> showing 50 of 75,631 rows — these rows as CSV

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