PREVIEW / stock_30min / 2007-12-14

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-12-14.parquet
  size:    1.2 MB
  rows:    68,205
  symbols: 3,230

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-14 06:00:00	AAPL	Stock	6.8643	6.8643	6.8361	6.8361	8400.0
2007-12-14 06:30:00	AAPL	Stock	6.8371	6.8475	6.8368	6.8368	58800.0
2007-12-14 07:00:00	AAPL	Stock	6.8368	6.8368	6.8214	6.8229	25200.0
2007-12-14 07:30:00	AAPL	Stock	6.8304	6.8482	6.8304	6.8371	112000.0
2007-12-14 08:00:00	AAPL	Stock	6.8446	6.8554	6.8232	6.8318	1245216.0
2007-12-14 08:30:00	AAPL	Stock	6.8296	6.8296	6.7946	6.8089	2104228.0
2007-12-14 09:00:00	AAPL	Stock	6.8089	6.8089	6.7893	6.7986	2045708.0
2007-12-14 09:30:00	AAPL	Stock	6.7975	6.8407	6.7693	6.8164	101487036.0
2007-12-14 10:00:00	AAPL	Stock	6.8161	6.8346	6.7968	6.8232	60622968.0
2007-12-14 10:30:00	AAPL	Stock	6.8236	6.9	6.8057	6.8964	80958304.0
2007-12-14 11:00:00	AAPL	Stock	6.8964	6.8971	6.8586	6.8654	49112084.0
2007-12-14 11:30:00	AAPL	Stock	6.8654	6.8714	6.8207	6.8354	39041520.0
2007-12-14 12:00:00	AAPL	Stock	6.8343	6.8761	6.7861	6.7977	31756788.0
2007-12-14 12:30:00	AAPL	Stock	6.7982	6.8318	6.7957	6.8264	33767384.0
2007-12-14 13:00:00	AAPL	Stock	6.8275	6.8393	6.8146	6.8343	23609208.0
2007-12-14 13:30:00	AAPL	Stock	6.8339	6.8339	6.8071	6.8239	22998528.0
2007-12-14 14:00:00	AAPL	Stock	6.8239	6.8389	6.8121	6.8343	22007384.0
2007-12-14 14:30:00	AAPL	Stock	6.8343	6.8486	6.8089	6.8089	32574108.0
2007-12-14 15:00:00	AAPL	Stock	6.8093	6.8343	6.7893	6.7961	52035732.0
2007-12-14 15:30:00	AAPL	Stock	6.7954	6.8207	6.7857	6.7993	79587648.0
2007-12-14 16:00:00	AAPL	Stock	6.7993	6.8259	6.7946	6.7993	21518756.0
2007-12-14 16:30:00	AAPL	Stock	6.7989	6.8	6.7964	6.7996	15035048.0
2007-12-14 17:00:00	AAPL	Stock	6.7979	6.7996	6.7964	6.7993	2445128.0
2007-12-14 17:30:00	AAPL	Stock	6.7979	6.7989	6.7964	6.7964	81592.0
2007-12-14 18:00:00	AAPL	Stock	6.7982	6.7982	6.7957	6.7957	68684.0
2007-12-14 18:30:00	AAPL	Stock	6.7964	6.7964	6.7946	6.7964	53060.0
2007-12-14 19:00:00	AAPL	Stock	6.7964	6.7982	6.7964	6.7971	43764.0
2007-12-14 19:30:00	AAPL	Stock	6.7957	6.7996	6.7954	6.7996	179816.0
2007-12-14 06:30:00	MSFT	Stock	35.17	35.17	35.17	35.17	100.0
2007-12-14 07:30:00	MSFT	Stock	35.14	35.14	35.14	35.14	5000.0
2007-12-14 08:00:00	MSFT	Stock	35.12	35.2	35.12	35.13	1671.0
2007-12-14 08:30:00	MSFT	Stock	35.11	35.21	35.0	35.1	157029.0
2007-12-14 09:00:00	MSFT	Stock	35.04	35.22	35.0	35.08	3973317.0
2007-12-14 09:30:00	MSFT	Stock	35.07	35.52	35.01	35.36	8683015.0
2007-12-14 10:00:00	MSFT	Stock	35.36	35.68	35.36	35.63	4829343.0
2007-12-14 10:30:00	MSFT	Stock	35.64	35.811	35.32	35.78	5435528.0
2007-12-14 11:00:00	MSFT	Stock	35.78	35.84	35.65	35.74	4389565.0
2007-12-14 11:30:00	MSFT	Stock	35.73	35.82	35.69	35.7	3486941.0
2007-12-14 12:00:00	MSFT	Stock	35.7	35.75	35.63	35.67	3309882.0
2007-12-14 12:30:00	MSFT	Stock	35.67	35.7	35.51	35.67	3075810.0
2007-12-14 13:00:00	MSFT	Stock	35.66	35.755	35.63	35.71	1908796.0
2007-12-14 13:30:00	MSFT	Stock	35.72	35.79	35.67	35.74	1946323.0
2007-12-14 14:00:00	MSFT	Stock	35.74	35.83	35.67	35.82	2719873.0
2007-12-14 14:30:00	MSFT	Stock	35.8	35.84	35.65	35.65	3769739.0
2007-12-14 15:00:00	MSFT	Stock	35.66	35.73	35.42	35.44	6049140.0
2007-12-14 15:30:00	MSFT	Stock	35.45	35.55	35.17	35.32	10368900.0
2007-12-14 16:00:00	MSFT	Stock	35.32	35.564	35.288	35.31	6423669.0
2007-12-14 16:30:00	MSFT	Stock	35.3	35.62	35.3	35.31	594137.0
2007-12-14 17:30:00	MSFT	Stock	35.29	35.707	35.29	35.31	5934.0
2007-12-14 18:00:00	MSFT	Stock	35.31	35.31	35.31	35.31	1300.0

> showing 50 of 68,205 rows — these rows as CSV

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