PREVIEW / stock_30min / 2013-05-31

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-05-31.parquet
  size:    1.6 MB
  rows:    81,863
  symbols: 3,519

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-05-31 04:00:00	AAPL	Stock	16.0893	16.0893	16.0893	16.0893	14000.0
2013-05-31 04:30:00	AAPL	Stock	16.0282	16.0282	16.0282	16.0282	13720.0
2013-05-31 05:00:00	AAPL	Stock	16.0289	16.0289	16.0289	16.0289	2800.0
2013-05-31 05:30:00	AAPL	Stock	16.0357	16.0357	16.0268	16.0268	16800.0
2013-05-31 06:00:00	AAPL	Stock	16.0268	16.0286	16.0268	16.0286	19600.0
2013-05-31 06:30:00	AAPL	Stock	16.0357	16.0504	16.0286	16.0286	16800.0
2013-05-31 07:00:00	AAPL	Stock	16.0357	16.1064	16.0357	16.0964	156212.0
2013-05-31 07:30:00	AAPL	Stock	16.1054	16.1054	16.0639	16.0668	93240.0
2013-05-31 08:00:00	AAPL	Stock	16.0789	16.1429	16.0289	16.0707	880824.0
2013-05-31 08:30:00	AAPL	Stock	16.0607	16.1246	16.0482	16.1143	1193724.0
2013-05-31 09:00:00	AAPL	Stock	16.1143	16.1671	16.1096	16.1611	2036300.0
2013-05-31 09:30:00	AAPL	Stock	16.1607	16.2961	16.1589	16.2564	66956988.0
2013-05-31 10:00:00	AAPL	Stock	16.2579	16.3011	16.2343	16.2493	34106996.0
2013-05-31 10:30:00	AAPL	Stock	16.2539	16.2946	16.2382	16.2567	26188848.0
2013-05-31 11:00:00	AAPL	Stock	16.2561	16.2996	16.2414	16.2932	20434540.0
2013-05-31 11:30:00	AAPL	Stock	16.2929	16.325	16.2861	16.3129	19086396.0
2013-05-31 12:00:00	AAPL	Stock	16.3132	16.3177	16.2761	16.3064	13032012.0
2013-05-31 12:30:00	AAPL	Stock	16.3064	16.3139	16.2943	16.3036	7016408.0
2013-05-31 13:00:00	AAPL	Stock	16.3036	16.3221	16.2888	16.295	12416740.0
2013-05-31 13:30:00	AAPL	Stock	16.295	16.295	16.2429	16.2446	16495640.0
2013-05-31 14:00:00	AAPL	Stock	16.245	16.2529	16.1861	16.2286	22649732.0
2013-05-31 14:30:00	AAPL	Stock	16.2286	16.2307	16.1618	16.1782	21645596.0
2013-05-31 15:00:00	AAPL	Stock	16.1775	16.2196	16.1649	16.2143	20059480.0
2013-05-31 15:30:00	AAPL	Stock	16.2143	16.2143	16.0536	16.0536	57991192.0
2013-05-31 16:00:00	AAPL	Stock	16.0632	16.2286	16.0536	16.0714	22144500.0
2013-05-31 16:30:00	AAPL	Stock	16.0595	16.2136	16.0557	16.06	5132316.0
2013-05-31 17:00:00	AAPL	Stock	16.0704	16.0732	16.0599	16.0607	2505972.0
2013-05-31 17:30:00	AAPL	Stock	16.0607	16.0707	16.0586	16.0586	391888.0
2013-05-31 18:00:00	AAPL	Stock	16.0575	16.06	16.0439	16.0518	334460.0
2013-05-31 18:30:00	AAPL	Stock	16.0439	16.0439	16.0268	16.0321	519344.0
2013-05-31 19:00:00	AAPL	Stock	16.0321	16.0411	16.0321	16.0368	59976.0
2013-05-31 19:30:00	AAPL	Stock	16.0361	16.0518	16.0321	16.0414	60228.0
2013-05-31 08:00:00	MSFT	Stock	34.87	34.95	34.87	34.95	1989.0
2013-05-31 08:30:00	MSFT	Stock	34.89	35.03	34.89	34.92	26165.0
2013-05-31 09:00:00	MSFT	Stock	34.87	35.03	34.82	34.82	675103.0
2013-05-31 09:30:00	MSFT	Stock	34.84	35.05	34.79	35.045	4087826.0
2013-05-31 10:00:00	MSFT	Stock	35.045	35.15	34.94	34.97	2905390.0
2013-05-31 10:30:00	MSFT	Stock	34.98	35.12	34.97	35.1	2143037.0
2013-05-31 11:00:00	MSFT	Stock	35.091	35.28	35.091	35.15	3575709.0
2013-05-31 11:30:00	MSFT	Stock	35.15	35.19	35.11	35.165	1756687.0
2013-05-31 12:00:00	MSFT	Stock	35.165	35.19	35.1	35.15	1404806.0
2013-05-31 12:30:00	MSFT	Stock	35.16	35.16	35.07	35.11	1342065.0
2013-05-31 13:00:00	MSFT	Stock	35.11	35.2	35.11	35.195	1122090.0
2013-05-31 13:30:00	MSFT	Stock	35.195	35.21	35.15	35.2	1562934.0
2013-05-31 14:00:00	MSFT	Stock	35.195	35.266	35.19	35.24	1891215.0
2013-05-31 14:30:00	MSFT	Stock	35.24	35.24	35.16	35.165	2339432.0
2013-05-31 15:00:00	MSFT	Stock	35.165	35.2	35.045	35.06	3205072.0
2013-05-31 15:30:00	MSFT	Stock	35.06	35.08	34.87	34.88	10655217.0
2013-05-31 16:00:00	MSFT	Stock	34.88	35.042	34.76	34.77	12957867.0
2013-05-31 16:30:00	MSFT	Stock	34.867	34.893	34.75	34.88	2528655.0

> showing 50 of 81,863 rows — these rows as CSV

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