PREVIEW / stock_30min / 2011-02-15

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-02-15.parquet
  size:    1.4 MB
  rows:    76,649
  symbols: 3,550

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
2011-02-15 04:00:00	AAPL	Stock	12.855	12.8846	12.855	12.8839	38640.0
2011-02-15 05:00:00	AAPL	Stock	12.8929	12.8989	12.8839	12.8989	16800.0
2011-02-15 05:30:00	AAPL	Stock	12.8929	12.8929	12.8929	12.8929	2800.0
2011-02-15 06:30:00	AAPL	Stock	12.8718	12.8893	12.8682	12.875	19600.0
2011-02-15 07:00:00	AAPL	Stock	12.875	12.8789	12.8636	12.8789	85792.0
2011-02-15 07:30:00	AAPL	Stock	12.8643	12.8643	12.8571	12.8571	166684.0
2011-02-15 08:00:00	AAPL	Stock	12.8518	12.8625	12.8289	12.8518	1083152.0
2011-02-15 08:30:00	AAPL	Stock	12.8486	12.8607	12.8375	12.8486	953316.0
2011-02-15 09:00:00	AAPL	Stock	12.8464	12.8464	12.8214	12.8289	1527288.0
2011-02-15 09:30:00	AAPL	Stock	12.8286	12.8561	12.7964	12.8335	52519012.0
2011-02-15 10:00:00	AAPL	Stock	12.8307	12.8386	12.7696	12.7853	38816176.0
2011-02-15 10:30:00	AAPL	Stock	12.7839	12.8314	12.7818	12.8136	22819916.0
2011-02-15 11:00:00	AAPL	Stock	12.8136	12.8396	12.8107	12.8314	14682332.0
2011-02-15 11:30:00	AAPL	Stock	12.8325	12.8386	12.7965	12.8089	13708212.0
2011-02-15 12:00:00	AAPL	Stock	12.8096	12.8214	12.7929	12.8193	12038908.0
2011-02-15 12:30:00	AAPL	Stock	12.8191	12.83	12.8125	12.8261	8005872.0
2011-02-15 13:00:00	AAPL	Stock	12.8269	12.8289	12.8189	12.8253	7444892.0
2011-02-15 13:30:00	AAPL	Stock	12.8257	12.835	12.8139	12.8234	8968792.0
2011-02-15 14:00:00	AAPL	Stock	12.8229	12.8246	12.7989	12.7993	14190148.0
2011-02-15 14:30:00	AAPL	Stock	12.7993	12.8364	12.7975	12.8239	16118956.0
2011-02-15 15:00:00	AAPL	Stock	12.8236	12.8393	12.8214	12.8286	13994288.0
2011-02-15 15:30:00	AAPL	Stock	12.83	12.8554	12.8189	12.8554	40668740.0
2011-02-15 16:00:00	AAPL	Stock	12.8536	12.8671	12.8162	12.8618	7599956.0
2011-02-15 16:30:00	AAPL	Stock	12.8614	12.8646	12.8294	12.8636	435008.0
2011-02-15 17:00:00	AAPL	Stock	12.8636	12.8657	12.86	12.8657	183064.0
2011-02-15 17:30:00	AAPL	Stock	12.8654	12.8657	12.8607	12.8607	92036.0
2011-02-15 18:00:00	AAPL	Stock	12.8607	12.8646	12.8568	12.8586	484932.0
2011-02-15 18:30:00	AAPL	Stock	12.8586	12.8621	12.8571	12.8607	269500.0
2011-02-15 19:00:00	AAPL	Stock	12.8607	12.8621	12.8593	12.8604	144032.0
2011-02-15 19:30:00	AAPL	Stock	12.8607	12.8661	12.8593	12.8661	233996.0
2011-02-15 06:00:00	MSFT	Stock	27.18	27.18	27.18	27.18	100.0
2011-02-15 06:30:00	MSFT	Stock	27.2	27.21	27.19	27.21	2300.0
2011-02-15 07:00:00	MSFT	Stock	27.18	27.25	27.18	27.25	1100.0
2011-02-15 07:30:00	MSFT	Stock	27.2	27.2	27.16	27.16	1700.0
2011-02-15 08:00:00	MSFT	Stock	27.19	27.3	27.11	27.14	10873.0
2011-02-15 08:30:00	MSFT	Stock	27.13	27.15	27.08	27.14	13763.0
2011-02-15 09:00:00	MSFT	Stock	27.14	27.15	27.02	27.02	44305.0
2011-02-15 09:30:00	MSFT	Stock	27.04	27.33	27.03	27.27	8405685.0
2011-02-15 10:00:00	MSFT	Stock	27.27	27.28	26.96	26.97	4743177.0
2011-02-15 10:30:00	MSFT	Stock	26.97	27.09	26.97	27.06	3354057.0
2011-02-15 11:00:00	MSFT	Stock	27.06	27.095	27.03	27.04	2505144.0
2011-02-15 11:30:00	MSFT	Stock	27.04	27.05	27.01	27.025	1356267.0
2011-02-15 12:00:00	MSFT	Stock	27.02	27.04	27.0	27.0	3795440.0
2011-02-15 12:30:00	MSFT	Stock	27.01	27.06	27.0	27.03	1418616.0
2011-02-15 13:00:00	MSFT	Stock	27.04	27.06	27.01	27.03	1214724.0
2011-02-15 13:30:00	MSFT	Stock	27.04	27.06	27.02	27.02	1163062.0
2011-02-15 14:00:00	MSFT	Stock	27.022	27.04	26.98	26.99	2034888.0
2011-02-15 14:30:00	MSFT	Stock	26.99	27.05	26.98	27.04	1989598.0
2011-02-15 15:00:00	MSFT	Stock	27.03	27.06	27.0	27.01	1843355.0
2011-02-15 15:30:00	MSFT	Stock	27.0	27.03	26.95	26.96	6762169.0

> showing 50 of 76,649 rows — these rows as CSV

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