PREVIEW / stock_30min / 2012-09-21

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-09-21.parquet
  size:    1.5 MB
  rows:    77,803
  symbols: 3,505

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
2012-09-21 04:00:00	AAPL	Stock	24.9911	25.0011	24.9911	25.0011	14000.0
2012-09-21 04:30:00	AAPL	Stock	25.0125	25.045	25.0021	25.045	28000.0
2012-09-21 05:00:00	AAPL	Stock	25.0446	25.0475	25.0446	25.0475	14000.0
2012-09-21 06:00:00	AAPL	Stock	25.0214	25.0214	25.0214	25.0214	5180.0
2012-09-21 06:30:00	AAPL	Stock	25.0475	25.0475	25.0393	25.0393	29400.0
2012-09-21 07:00:00	AAPL	Stock	25.0654	25.1018	25.0307	25.095	661892.0
2012-09-21 07:30:00	AAPL	Stock	25.0889	25.1546	25.0889	25.1304	722764.0
2012-09-21 08:00:00	AAPL	Stock	25.1304	25.1518	25.0671	25.1321	2346876.0
2012-09-21 08:30:00	AAPL	Stock	25.1339	25.1393	25.0957	25.1293	2284156.0
2012-09-21 09:00:00	AAPL	Stock	25.1304	25.1318	25.0721	25.0775	2930340.0
2012-09-21 09:30:00	AAPL	Stock	25.0768	25.1546	25.0539	25.1136	128724820.0
2012-09-21 10:00:00	AAPL	Stock	25.1139	25.1607	25.0954	25.1607	39920160.0
2012-09-21 10:30:00	AAPL	Stock	25.16	25.1811	25.1443	25.1536	34724732.0
2012-09-21 11:00:00	AAPL	Stock	25.1532	25.1664	25.1429	25.1593	19537532.0
2012-09-21 11:30:00	AAPL	Stock	25.1607	25.1768	25.1575	25.1714	12631808.0
2012-09-21 12:00:00	AAPL	Stock	25.1714	25.1761	25.1504	25.16	12332460.0
2012-09-21 12:30:00	AAPL	Stock	25.1605	25.1753	25.155	25.1682	13529012.0
2012-09-21 13:00:00	AAPL	Stock	25.1683	25.1707	25.1429	25.1429	10516128.0
2012-09-21 13:30:00	AAPL	Stock	25.1429	25.1457	25.0914	25.0929	24844120.0
2012-09-21 14:00:00	AAPL	Stock	25.0921	25.1179	25.0093	25.0671	41107668.0
2012-09-21 14:30:00	AAPL	Stock	25.0671	25.1071	25.0371	25.0771	22085056.0
2012-09-21 15:00:00	AAPL	Stock	25.081	25.085	25.0182	25.0254	23760744.0
2012-09-21 15:30:00	AAPL	Stock	25.0243	25.0504	24.9772	25.025	75404084.0
2012-09-21 16:00:00	AAPL	Stock	25.025	25.1071	24.9925	25.1071	47671484.0
2012-09-21 16:30:00	AAPL	Stock	25.0252	25.1517	25.0	25.0004	23499504.0
2012-09-21 17:00:00	AAPL	Stock	25.0018	25.0254	24.9921	25.0036	2091292.0
2012-09-21 17:30:00	AAPL	Stock	25.0036	25.0036	25.0	25.0036	238840.0
2012-09-21 18:00:00	AAPL	Stock	25.0029	25.0254	24.9989	25.0018	342748.0
2012-09-21 18:30:00	AAPL	Stock	24.9993	25.0036	24.9943	25.0025	89964.0
2012-09-21 19:00:00	AAPL	Stock	25.0021	25.0032	24.9971	25.0	83356.0
2012-09-21 19:30:00	AAPL	Stock	25.0	25.0036	24.9925	25.0036	389424.0
2012-09-21 04:00:00	MSFT	Stock	31.45	31.45	31.45	31.45	100.0
2012-09-21 04:30:00	MSFT	Stock	31.44	31.45	31.44	31.45	400.0
2012-09-21 07:00:00	MSFT	Stock	31.45	31.46	31.4	31.4	1100.0
2012-09-21 07:30:00	MSFT	Stock	31.4	31.46	31.4	31.46	5500.0
2012-09-21 08:00:00	MSFT	Stock	31.45	31.46	31.45	31.45	12075.0
2012-09-21 08:30:00	MSFT	Stock	31.45	31.45	31.36	31.4	17359.0
2012-09-21 09:00:00	MSFT	Stock	31.44	31.46	31.39	31.4	199468.0
2012-09-21 09:30:00	MSFT	Stock	31.4	31.61	31.39	31.54	23469126.0
2012-09-21 10:00:00	MSFT	Stock	31.54	31.59	31.41	31.43	4376360.0
2012-09-21 10:30:00	MSFT	Stock	31.43	31.47	31.32	31.32	4648599.0
2012-09-21 11:00:00	MSFT	Stock	31.32	31.33	31.16	31.16	3656370.0
2012-09-21 11:30:00	MSFT	Stock	31.165	31.32	31.15	31.245	3449082.0
2012-09-21 12:00:00	MSFT	Stock	31.245	31.33	31.24	31.26	1487448.0
2012-09-21 12:30:00	MSFT	Stock	31.265	31.34	31.265	31.34	1084212.0
2012-09-21 13:00:00	MSFT	Stock	31.33	31.37	31.32	31.32	1353875.0
2012-09-21 13:30:00	MSFT	Stock	31.32	31.34	31.27	31.27	2518743.0
2012-09-21 14:00:00	MSFT	Stock	31.27	31.28	31.09	31.13	3391838.0
2012-09-21 14:30:00	MSFT	Stock	31.13	31.2	31.1	31.155	2926602.0
2012-09-21 15:00:00	MSFT	Stock	31.155	31.31	31.14	31.255	5358574.0

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

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