PREVIEW / stock_30min / 2007-12-12

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-12-12.parquet
  size:    1.2 MB
  rows:    70,298
  symbols: 3,245

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
2007-12-12 04:00:00	AAPL	Stock	6.7568	6.7675	6.7568	6.7675	14000.0
2007-12-12 04:30:00	AAPL	Stock	6.7704	6.7704	6.7704	6.7704	8400.0
2007-12-12 05:00:00	AAPL	Stock	6.7725	6.7854	6.7725	6.7786	56000.0
2007-12-12 05:30:00	AAPL	Stock	6.8	6.8	6.7929	6.7929	28000.0
2007-12-12 06:00:00	AAPL	Stock	6.7929	6.8	6.7929	6.8	11200.0
2007-12-12 06:30:00	AAPL	Stock	6.8121	6.8161	6.8121	6.8161	56000.0
2007-12-12 07:00:00	AAPL	Stock	6.8204	6.8557	6.7789	6.8064	455476.0
2007-12-12 07:30:00	AAPL	Stock	6.8064	6.8454	6.7968	6.8339	1075284.0
2007-12-12 08:00:00	AAPL	Stock	6.8321	6.8411	6.8071	6.8179	7271068.0
2007-12-12 08:30:00	AAPL	Stock	6.8179	6.8243	6.8071	6.8179	2763712.0
2007-12-12 09:00:00	AAPL	Stock	6.8193	6.9232	6.8193	6.9093	22997100.0
2007-12-12 09:30:00	AAPL	Stock	6.9086	6.9457	6.8875	6.9346	174447252.0
2007-12-12 10:00:00	AAPL	Stock	6.9343	6.9441	6.9	6.9318	85002540.0
2007-12-12 10:30:00	AAPL	Stock	6.9318	6.9329	6.8875	6.8875	72313528.0
2007-12-12 11:00:00	AAPL	Stock	6.8882	6.9207	6.875	6.8832	71942332.0
2007-12-12 11:30:00	AAPL	Stock	6.8829	6.9071	6.8797	6.8927	45698212.0
2007-12-12 12:00:00	AAPL	Stock	6.8936	6.8986	6.8439	6.8504	61494804.0
2007-12-12 12:30:00	AAPL	Stock	6.85	6.8504	6.7339	6.7921	105187936.0
2007-12-12 13:00:00	AAPL	Stock	6.7921	6.8421	6.7657	6.8186	69693820.0
2007-12-12 13:30:00	AAPL	Stock	6.8189	6.8525	6.8171	6.8318	50520960.0
2007-12-12 14:00:00	AAPL	Stock	6.8318	6.8379	6.7807	6.7886	55504960.0
2007-12-12 14:30:00	AAPL	Stock	6.7879	6.8018	6.7639	6.78	65788240.0
2007-12-12 15:00:00	AAPL	Stock	6.7804	6.8236	6.6343	6.7232	170737112.0
2007-12-12 15:30:00	AAPL	Stock	6.7232	6.9139	6.675	6.8271	142234092.0
2007-12-12 16:00:00	AAPL	Stock	6.8239	6.8518	6.7218	6.8386	15176868.0
2007-12-12 16:30:00	AAPL	Stock	6.8393	6.8446	6.7883	6.8304	2290848.0
2007-12-12 17:00:00	AAPL	Stock	6.8321	6.8357	6.8268	6.8268	338548.0
2007-12-12 17:30:00	AAPL	Stock	6.8286	6.8354	6.7429	6.8354	445984.0
2007-12-12 18:00:00	AAPL	Stock	6.8321	6.8329	6.8286	6.8296	392420.0
2007-12-12 18:30:00	AAPL	Stock	6.8293	6.8354	6.8286	6.8329	65100.0
2007-12-12 19:00:00	AAPL	Stock	6.8304	6.8304	6.8071	6.8229	968352.0
2007-12-12 19:30:00	AAPL	Stock	6.8189	6.8304	6.8107	6.8179	693588.0
2007-12-12 07:00:00	MSFT	Stock	34.28	34.32	34.28	34.28	4100.0
2007-12-12 08:00:00	MSFT	Stock	34.2	34.34	34.2	34.29	14808.0
2007-12-12 08:30:00	MSFT	Stock	34.34	34.34	34.29	34.29	105600.0
2007-12-12 09:00:00	MSFT	Stock	34.3	34.8	34.1	34.68	167785.0
2007-12-12 09:30:00	MSFT	Stock	34.68	34.9	34.57	34.845	7502056.0
2007-12-12 10:00:00	MSFT	Stock	34.845	36.39	34.68	35.04	5565370.0
2007-12-12 10:30:00	MSFT	Stock	35.04	35.09	34.77	34.81	4538420.0
2007-12-12 11:00:00	MSFT	Stock	34.81	35.0	34.78	34.92	2979276.0
2007-12-12 11:30:00	MSFT	Stock	34.92	35.0	34.77	34.77	3249223.0
2007-12-12 12:00:00	MSFT	Stock	34.77	34.82	34.68	34.71	2407651.0
2007-12-12 12:30:00	MSFT	Stock	34.7	34.7	34.46	34.51	3470600.0
2007-12-12 13:00:00	MSFT	Stock	34.51	34.6	34.4	34.555	2074109.0
2007-12-12 13:30:00	MSFT	Stock	34.55	34.75	34.55	34.73	2162629.0
2007-12-12 14:00:00	MSFT	Stock	34.73	34.76	34.64	34.64	2478751.0
2007-12-12 14:30:00	MSFT	Stock	34.64	34.74	34.57	34.625	3219293.0
2007-12-12 15:00:00	MSFT	Stock	34.62	34.63	33.93	34.24	8358399.0
2007-12-12 15:30:00	MSFT	Stock	34.24	34.47	34.08	34.47	9017578.0
2007-12-12 16:00:00	MSFT	Stock	34.48	34.65	34.1	34.6	4811353.0

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

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