PREVIEW / stock_30min / 2014-04-25

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-04-25.parquet
  size:    1.5 MB
  rows:    81,021
  symbols: 3,525

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
2014-04-25 04:00:00	AAPL	Stock	20.1857	20.1857	20.15	20.1607	19600.0
2014-04-25 04:30:00	AAPL	Stock	20.1607	20.1607	20.1429	20.1429	35420.0
2014-04-25 05:00:00	AAPL	Stock	20.1429	20.1618	20.1429	20.1614	21840.0
2014-04-25 05:30:00	AAPL	Stock	20.1593	20.1593	20.1593	20.1593	2800.0
2014-04-25 06:00:00	AAPL	Stock	20.15	20.1743	20.15	20.1743	10864.0
2014-04-25 06:30:00	AAPL	Stock	20.1661	20.1679	20.0754	20.0754	143276.0
2014-04-25 07:00:00	AAPL	Stock	20.1318	20.1318	20.0714	20.1071	211624.0
2014-04-25 07:30:00	AAPL	Stock	20.1161	20.1607	20.0929	20.1432	326648.0
2014-04-25 08:00:00	AAPL	Stock	20.1429	20.1564	20.1	20.1429	896168.0
2014-04-25 08:30:00	AAPL	Stock	20.145	20.1839	20.1429	20.1736	918708.0
2014-04-25 09:00:00	AAPL	Stock	20.1782	20.2029	20.1379	20.1464	1327900.0
2014-04-25 09:30:00	AAPL	Stock	20.1618	20.2817	20.1414	20.205	48093080.0
2014-04-25 10:00:00	AAPL	Stock	20.2075	20.2639	20.165	20.2268	25013464.0
2014-04-25 10:30:00	AAPL	Stock	20.2239	20.227	20.1789	20.2139	14749896.0
2014-04-25 11:00:00	AAPL	Stock	20.2123	20.2786	20.1846	20.2763	19164096.0
2014-04-25 11:30:00	AAPL	Stock	20.2766	20.3786	20.2766	20.3446	40657596.0
2014-04-25 12:00:00	AAPL	Stock	20.3493	20.3564	20.2975	20.3136	14993580.0
2014-04-25 12:30:00	AAPL	Stock	20.3161	20.3164	20.2393	20.2618	11688600.0
2014-04-25 13:00:00	AAPL	Stock	20.2654	20.3357	20.2539	20.3282	13263236.0
2014-04-25 13:30:00	AAPL	Stock	20.3268	20.3393	20.3082	20.3207	11764340.0
2014-04-25 14:00:00	AAPL	Stock	20.3218	20.3296	20.2921	20.3254	14766164.0
2014-04-25 14:30:00	AAPL	Stock	20.3243	20.3804	20.3179	20.3742	23835924.0
2014-04-25 15:00:00	AAPL	Stock	20.3739	20.3889	20.3414	20.3875	20457780.0
2014-04-25 15:30:00	AAPL	Stock	20.3868	20.4282	20.3693	20.4279	42427084.0
2014-04-25 16:00:00	AAPL	Stock	20.4264	20.4286	20.2995	20.3836	11710832.0
2014-04-25 16:30:00	AAPL	Stock	20.3836	20.4224	20.2126	20.4224	542052.0
2014-04-25 17:00:00	AAPL	Stock	20.3804	20.4264	20.3714	20.3732	1443848.0
2014-04-25 17:30:00	AAPL	Stock	20.3839	20.3989	20.3839	20.3929	66360.0
2014-04-25 18:00:00	AAPL	Stock	20.3882	20.3939	20.3875	20.3939	37632.0
2014-04-25 18:30:00	AAPL	Stock	20.3868	20.3961	20.3857	20.3925	110908.0
2014-04-25 19:00:00	AAPL	Stock	20.3864	20.3964	20.3864	20.3893	68040.0
2014-04-25 19:30:00	AAPL	Stock	20.3957	20.3964	20.3893	20.3957	114184.0
2014-04-25 04:30:00	MSFT	Stock	40.68	40.68	40.68	40.68	100.0
2014-04-25 05:30:00	MSFT	Stock	40.56	40.56	40.5	40.5	300.0
2014-04-25 06:00:00	MSFT	Stock	40.36	40.52	40.36	40.52	2450.0
2014-04-25 06:30:00	MSFT	Stock	40.52	40.53	40.4	40.4	15612.0
2014-04-25 07:00:00	MSFT	Stock	40.45	40.5	40.24	40.43	25420.0
2014-04-25 07:30:00	MSFT	Stock	40.41	40.67	40.3	40.65	68181.0
2014-04-25 08:00:00	MSFT	Stock	40.6	40.95	40.28	40.45	177736.0
2014-04-25 08:30:00	MSFT	Stock	40.45	40.77	40.35	40.42	189112.0
2014-04-25 09:00:00	MSFT	Stock	40.43	40.46	40.17	40.29	361665.0
2014-04-25 09:30:00	MSFT	Stock	40.29	40.68	40.19	40.3	10765600.0
2014-04-25 10:00:00	MSFT	Stock	40.29	40.37	40.25	40.28	5776256.0
2014-04-25 10:30:00	MSFT	Stock	40.281	40.3	39.75	39.825	4923233.0
2014-04-25 11:00:00	MSFT	Stock	39.83	40.16	39.77	40.11	4037996.0
2014-04-25 11:30:00	MSFT	Stock	40.12	40.17	39.87	40.119	3074485.0
2014-04-25 12:00:00	MSFT	Stock	40.105	40.284	40.07	40.25	2890255.0
2014-04-25 12:30:00	MSFT	Stock	40.25	40.28	40.08	40.17	2661764.0
2014-04-25 13:00:00	MSFT	Stock	40.17	40.19	39.95	40.0	2645639.0
2014-04-25 13:30:00	MSFT	Stock	39.99	40.05	39.92	40.01	1923447.0

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

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