PREVIEW / stock_30min / 2009-03-27

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-03-27.parquet
  size:    1.2 MB
  rows:    68,695
  symbols: 3,310

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
2009-03-27 07:00:00	AAPL	Stock	3.8714	3.8714	3.8714	3.8714	12068.0
2009-03-27 07:30:00	AAPL	Stock	3.8714	3.8889	3.8714	3.8754	71960.0
2009-03-27 08:00:00	AAPL	Stock	3.8811	3.8911	3.8689	3.8789	393540.0
2009-03-27 08:30:00	AAPL	Stock	3.8882	3.8893	3.8689	3.8804	669900.0
2009-03-27 09:00:00	AAPL	Stock	3.8775	3.8943	3.8618	3.8654	1190168.0
2009-03-27 09:30:00	AAPL	Stock	3.8675	3.8761	3.8289	3.8414	74328016.0
2009-03-27 10:00:00	AAPL	Stock	3.8421	3.8482	3.8171	3.8307	51986116.0
2009-03-27 10:30:00	AAPL	Stock	3.8318	3.8461	3.8221	3.8375	33603696.0
2009-03-27 11:00:00	AAPL	Stock	3.8375	3.8621	3.8182	3.8479	43371244.0
2009-03-27 11:30:00	AAPL	Stock	3.8479	3.8536	3.8382	3.8439	23569952.0
2009-03-27 12:00:00	AAPL	Stock	3.8443	3.8529	3.8254	3.8332	24663912.0
2009-03-27 12:30:00	AAPL	Stock	3.8321	3.8411	3.82	3.8218	19449276.0
2009-03-27 13:00:00	AAPL	Stock	3.8208	3.825	3.805	3.8196	26580372.0
2009-03-27 13:30:00	AAPL	Stock	3.8204	3.8304	3.8018	3.8132	32727604.0
2009-03-27 14:00:00	AAPL	Stock	3.8132	3.8229	3.8061	3.8129	27097588.0
2009-03-27 14:30:00	AAPL	Stock	3.8129	3.8218	3.8	3.8189	27560624.0
2009-03-27 15:00:00	AAPL	Stock	3.8189	3.8379	3.8125	3.8179	33426736.0
2009-03-27 15:30:00	AAPL	Stock	3.8179	3.8371	3.805	3.8261	52080616.0
2009-03-27 16:00:00	AAPL	Stock	3.8161	3.8314	3.8075	3.8214	10363136.0
2009-03-27 16:30:00	AAPL	Stock	3.8186	3.8232	3.8161	3.8232	3627736.0
2009-03-27 17:00:00	AAPL	Stock	3.825	3.8268	3.82	3.8246	90720.0
2009-03-27 17:30:00	AAPL	Stock	3.8196	3.8196	3.8164	3.8179	42504.0
2009-03-27 18:00:00	AAPL	Stock	3.81	3.8193	3.81	3.8193	1092756.0
2009-03-27 18:30:00	AAPL	Stock	3.8193	3.8196	3.8193	3.8196	26880.0
2009-03-27 19:00:00	AAPL	Stock	3.8179	3.8214	3.8161	3.8171	104160.0
2009-03-27 19:30:00	AAPL	Stock	3.8196	3.8196	3.8161	3.8161	37800.0
2009-03-27 05:30:00	MSFT	Stock	18.7	18.7	18.7	18.7	600.0
2009-03-27 07:00:00	MSFT	Stock	18.51	18.55	18.5	18.5	2600.0
2009-03-27 07:30:00	MSFT	Stock	18.55	18.9	18.55	18.9	4018.0
2009-03-27 08:00:00	MSFT	Stock	18.57	18.83	18.52	18.62	22258.0
2009-03-27 08:30:00	MSFT	Stock	18.67	18.67	18.52	18.54	11701.0
2009-03-27 09:00:00	MSFT	Stock	18.53	18.64	18.46	18.55	17197.0
2009-03-27 09:30:00	MSFT	Stock	18.55	18.615	18.24	18.29	5185651.0
2009-03-27 10:00:00	MSFT	Stock	18.29	18.34	18.1	18.21	3525523.0
2009-03-27 10:30:00	MSFT	Stock	18.2	18.24	18.15	18.16	3296598.0
2009-03-27 11:00:00	MSFT	Stock	18.15	18.2	18.1	18.16	2440701.0
2009-03-27 11:30:00	MSFT	Stock	18.16	18.34	18.13	18.32	3454643.0
2009-03-27 12:00:00	MSFT	Stock	18.32	18.4	18.15	18.33	3470587.0
2009-03-27 12:30:00	MSFT	Stock	18.33	18.38	18.23	18.249	1761534.0
2009-03-27 13:00:00	MSFT	Stock	18.255	18.32	18.18	18.29	2769705.0
2009-03-27 13:30:00	MSFT	Stock	18.29	18.336	18.12	18.198	2606938.0
2009-03-27 14:00:00	MSFT	Stock	18.2	18.34	18.17	18.25	2615150.0
2009-03-27 14:30:00	MSFT	Stock	18.25	18.269	18.12	18.22	2644618.0
2009-03-27 15:00:00	MSFT	Stock	18.21	18.33	18.12	18.14	3061671.0
2009-03-27 15:30:00	MSFT	Stock	18.13	18.18	18.05	18.13	7117841.0
2009-03-27 16:00:00	MSFT	Stock	18.13	18.23	18.09	18.13	2008866.0
2009-03-27 16:30:00	MSFT	Stock	18.12	18.15	18.12	18.14	569502.0
2009-03-27 17:00:00	MSFT	Stock	18.13	18.15	18.12	18.12	1800.0
2009-03-27 17:30:00	MSFT	Stock	18.14	18.14	18.14	18.14	1840.0
2009-03-27 18:00:00	MSFT	Stock	18.08	18.14	18.08	18.14	231405.0

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

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