PREVIEW / stock_30min / 2013-03-07

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-03-07.parquet
  size:    1.5 MB
  rows:    77,903
  symbols: 3,494

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
2013-03-07 05:30:00	AAPL	Stock	15.165	15.165	15.1643	15.1643	11676.0
2013-03-07 07:00:00	AAPL	Stock	15.1786	15.1893	15.1325	15.1429	120372.0
2013-03-07 07:30:00	AAPL	Stock	15.1525	15.1661	15.1429	15.1429	162708.0
2013-03-07 08:00:00	AAPL	Stock	15.1607	15.2143	15.1429	15.1821	648312.0
2013-03-07 08:30:00	AAPL	Stock	15.1839	15.2193	15.1607	15.2143	867636.0
2013-03-07 09:00:00	AAPL	Stock	15.2143	15.23	15.1536	15.1589	1022336.0
2013-03-07 09:30:00	AAPL	Stock	15.16	15.175	15.0464	15.0782	60758964.0
2013-03-07 10:00:00	AAPL	Stock	15.0807	15.1004	15.0379	15.0854	35591556.0
2013-03-07 10:30:00	AAPL	Stock	15.0804	15.1682	15.0775	15.1362	38780532.0
2013-03-07 11:00:00	AAPL	Stock	15.1372	15.2964	15.1332	15.2936	53381748.0
2013-03-07 11:30:00	AAPL	Stock	15.2943	15.3789	15.2679	15.3303	50894424.0
2013-03-07 12:00:00	AAPL	Stock	15.3287	15.3318	15.2446	15.31	28879032.0
2013-03-07 12:30:00	AAPL	Stock	15.3075	15.3481	15.2571	15.3289	19900692.0
2013-03-07 13:00:00	AAPL	Stock	15.3275	15.3307	15.2332	15.2475	18531800.0
2013-03-07 13:30:00	AAPL	Stock	15.2487	15.2946	15.2254	15.2571	15554672.0
2013-03-07 14:00:00	AAPL	Stock	15.2575	15.2657	15.1907	15.2307	16480604.0
2013-03-07 14:30:00	AAPL	Stock	15.2346	15.3554	15.2318	15.3554	23833320.0
2013-03-07 15:00:00	AAPL	Stock	15.355	15.3832	15.3132	15.3436	30923396.0
2013-03-07 15:30:00	AAPL	Stock	15.3436	15.4289	15.3318	15.3714	52526964.0
2013-03-07 16:00:00	AAPL	Stock	15.3718	15.3971	15.2429	15.3929	9992724.0
2013-03-07 16:30:00	AAPL	Stock	15.3929	15.3929	15.2045	15.3918	448728.0
2013-03-07 17:00:00	AAPL	Stock	15.3893	15.3929	15.3779	15.3875	178304.0
2013-03-07 17:30:00	AAPL	Stock	15.3861	15.3893	15.3857	15.3893	83552.0
2013-03-07 18:00:00	AAPL	Stock	15.3893	15.3914	15.3864	15.3907	66556.0
2013-03-07 18:30:00	AAPL	Stock	15.3864	15.3911	15.3779	15.3911	98056.0
2013-03-07 19:00:00	AAPL	Stock	15.3857	15.3893	15.3857	15.3861	76020.0
2013-03-07 19:30:00	AAPL	Stock	15.3875	15.3875	15.3789	15.3789	259308.0
2013-03-07 08:00:00	MSFT	Stock	28.05	28.05	28.0	28.01	1374.0
2013-03-07 08:30:00	MSFT	Stock	28.09	28.1	28.09	28.1	2224.0
2013-03-07 09:00:00	MSFT	Stock	28.15	28.24	28.09	28.1	46676.0
2013-03-07 09:30:00	MSFT	Stock	28.11	28.16	28.005	28.14	2819274.0
2013-03-07 10:00:00	MSFT	Stock	28.131	28.24	28.1	28.22	1988089.0
2013-03-07 10:30:00	MSFT	Stock	28.215	28.26	28.15	28.16	2152895.0
2013-03-07 11:00:00	MSFT	Stock	28.163	28.2	28.14	28.17	1742235.0
2013-03-07 11:30:00	MSFT	Stock	28.17	28.2	28.145	28.16	1479014.0
2013-03-07 12:00:00	MSFT	Stock	28.155	28.22	28.12	28.218	1306606.0
2013-03-07 12:30:00	MSFT	Stock	28.215	28.25	28.2	28.235	2245618.0
2013-03-07 13:00:00	MSFT	Stock	28.235	28.28	28.22	28.22	1601133.0
2013-03-07 13:30:00	MSFT	Stock	28.23	28.23	28.15	28.17	1191661.0
2013-03-07 14:00:00	MSFT	Stock	28.17	28.18	28.1	28.175	2267669.0
2013-03-07 14:30:00	MSFT	Stock	28.17	28.19	28.13	28.16	2672269.0
2013-03-07 15:00:00	MSFT	Stock	28.16	28.2	28.141	28.17	2312865.0
2013-03-07 15:30:00	MSFT	Stock	28.175	28.2	28.13	28.14	3054772.0
2013-03-07 16:00:00	MSFT	Stock	28.14	28.231	28.14	28.14	1996491.0
2013-03-07 16:30:00	MSFT	Stock	28.14	28.18	28.14	28.14	45822.0
2013-03-07 17:00:00	MSFT	Stock	28.1	28.14	28.1	28.14	5820.0
2013-03-07 17:30:00	MSFT	Stock	28.14	28.14	28.14	28.14	200.0
2013-03-07 19:00:00	MSFT	Stock	28.13	28.13	28.13	28.13	200.0
2013-03-07 19:30:00	MSFT	Stock	28.11	28.11	28.11	28.11	739.0
2013-03-07 08:00:00	NVDA	Stock	0.3243	0.3243	0.32	0.32	95000.0

> showing 50 of 77,903 rows — these rows as CSV

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