PREVIEW / stock_30min / 2008-06-26

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-06-26.parquet
  size:    1.3 MB
  rows:    69,597
  symbols: 3,342

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-26 07:00:00	AAPL	Stock	6.25	6.275	6.25	6.275	8400.0
2008-06-26 07:30:00	AAPL	Stock	6.275	6.275	6.2268	6.2582	297080.0
2008-06-26 08:00:00	AAPL	Stock	6.25	6.2654	6.2225	6.2225	1725948.0
2008-06-26 08:30:00	AAPL	Stock	6.2193	6.2271	6.2079	6.2193	1763636.0
2008-06-26 09:00:00	AAPL	Stock	6.2193	6.2211	6.1989	6.2146	1030372.0
2008-06-26 09:30:00	AAPL	Stock	6.2164	6.2444	6.1346	6.155	111473348.0
2008-06-26 10:00:00	AAPL	Stock	6.1586	6.1886	6.1393	6.1714	69851264.0
2008-06-26 10:30:00	AAPL	Stock	6.1714	6.1736	6.0857	6.0921	72006200.0
2008-06-26 11:00:00	AAPL	Stock	6.0921	6.1143	6.0775	6.0971	61357016.0
2008-06-26 11:30:00	AAPL	Stock	6.0982	6.12	6.0879	6.0917	40651912.0
2008-06-26 12:00:00	AAPL	Stock	6.0914	6.0989	6.0418	6.0504	66402224.0
2008-06-26 12:30:00	AAPL	Stock	6.0504	6.0832	6.0314	6.0711	50899128.0
2008-06-26 13:00:00	AAPL	Stock	6.0704	6.0846	6.0318	6.0332	35241360.0
2008-06-26 13:30:00	AAPL	Stock	6.0339	6.0596	6.0271	6.0548	44975476.0
2008-06-26 14:00:00	AAPL	Stock	6.0546	6.0671	6.0143	6.0314	53706744.0
2008-06-26 14:30:00	AAPL	Stock	6.0314	6.0432	6.0004	6.025	55295884.0
2008-06-26 15:00:00	AAPL	Stock	6.0243	6.0646	6.0229	6.0536	58961980.0
2008-06-26 15:30:00	AAPL	Stock	6.0536	6.0743	6.0061	6.0079	85224384.0
2008-06-26 16:00:00	AAPL	Stock	6.0079	6.0885	6.0	6.0014	19294156.0
2008-06-26 16:30:00	AAPL	Stock	6.0018	6.0882	6.0018	6.0036	5058676.0
2008-06-26 17:00:00	AAPL	Stock	6.0036	6.3354	6.0	6.0061	1258852.0
2008-06-26 17:30:00	AAPL	Stock	6.0054	6.0068	6.0004	6.0004	334124.0
2008-06-26 18:00:00	AAPL	Stock	6.0004	6.0018	5.9918	5.995	578116.0
2008-06-26 18:30:00	AAPL	Stock	5.9961	6.0	5.99	5.9904	191772.0
2008-06-26 19:00:00	AAPL	Stock	5.9925	5.9957	5.9857	5.9929	139608.0
2008-06-26 19:30:00	AAPL	Stock	5.9893	5.9929	5.9875	5.9893	90636.0
2008-06-26 07:00:00	MSFT	Stock	28.24	28.24	28.16	28.16	600.0
2008-06-26 07:30:00	MSFT	Stock	28.16	28.16	28.16	28.16	100.0
2008-06-26 08:00:00	MSFT	Stock	28.1	28.15	27.99	28.0	8056.0
2008-06-26 08:30:00	MSFT	Stock	28.01	28.02	27.93	27.98	9181.0
2008-06-26 09:00:00	MSFT	Stock	27.96	28.05	27.92	28.0	80230.0
2008-06-26 09:30:00	MSFT	Stock	28.03	28.19	27.91	28.09	6887796.0
2008-06-26 10:00:00	MSFT	Stock	28.1	28.2	28.0	28.13	6077568.0
2008-06-26 10:30:00	MSFT	Stock	28.12	28.13	27.95	28.02	4221229.0
2008-06-26 11:00:00	MSFT	Stock	28.02	28.06	27.9	28.0	4754784.0
2008-06-26 11:30:00	MSFT	Stock	28.01	28.08	28.0	28.042	3255620.0
2008-06-26 12:00:00	MSFT	Stock	28.04	28.13	27.96	28.05	3625119.0
2008-06-26 12:30:00	MSFT	Stock	28.05	28.07	27.97	27.98	2698802.0
2008-06-26 13:00:00	MSFT	Stock	27.97	28.05	27.95	27.98	2227782.0
2008-06-26 13:30:00	MSFT	Stock	27.98	28.04	27.95	27.99	2451167.0
2008-06-26 14:00:00	MSFT	Stock	27.982	28.05	27.9	27.98	3683601.0
2008-06-26 14:30:00	MSFT	Stock	27.98	28.0	27.84	27.9	3483429.0
2008-06-26 15:00:00	MSFT	Stock	27.9	27.97	27.87	27.92	4034169.0
2008-06-26 15:30:00	MSFT	Stock	27.92	28.05	27.76	27.76	10081126.0
2008-06-26 16:00:00	MSFT	Stock	27.76	27.988	27.739	27.77	6676664.0
2008-06-26 16:30:00	MSFT	Stock	27.75	27.966	27.75	27.76	478858.0
2008-06-26 17:00:00	MSFT	Stock	28.35	28.35	27.75	27.75	222010.0
2008-06-26 17:30:00	MSFT	Stock	27.75	27.77	27.73	27.73	1590.0
2008-06-26 18:00:00	MSFT	Stock	27.71	27.71	27.7	27.7	2900.0
2008-06-26 18:30:00	MSFT	Stock	27.7	27.74	27.7	27.74	4710.0

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

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