PREVIEW / stock_5min / 2012-11-20

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-11-20.parquet
  size:    4.7 MB
  rows:    317,125
  symbols: 3,472

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-11-20 04:00:00	AAPL	Stock	20.2764	20.2764	20.275	20.275	8400.0
2012-11-20 04:05:00	AAPL	Stock	20.2746	20.2746	20.2743	20.2743	11200.0
2012-11-20 04:10:00	AAPL	Stock	20.2554	20.2554	20.2554	20.2554	20020.0
2012-11-20 04:15:00	AAPL	Stock	20.2571	20.2739	20.2571	20.2739	5600.0
2012-11-20 04:20:00	AAPL	Stock	20.2786	20.2786	20.2786	20.2786	2800.0
2012-11-20 04:25:00	AAPL	Stock	20.2661	20.2661	20.2625	20.2643	14280.0
2012-11-20 04:35:00	AAPL	Stock	20.2607	20.2607	20.2554	20.2554	8400.0
2012-11-20 04:45:00	AAPL	Stock	20.2554	20.2554	20.2257	20.2325	34440.0
2012-11-20 04:55:00	AAPL	Stock	20.2386	20.2386	20.2386	20.2386	2800.0
2012-11-20 05:00:00	AAPL	Stock	20.2268	20.2268	20.2268	20.2268	2800.0
2012-11-20 05:05:00	AAPL	Stock	20.2386	20.25	20.2386	20.25	11200.0
2012-11-20 05:20:00	AAPL	Stock	20.25	20.25	20.2325	20.2325	21420.0
2012-11-20 05:25:00	AAPL	Stock	20.2529	20.2529	20.2529	20.2529	2800.0
2012-11-20 05:30:00	AAPL	Stock	20.2554	20.2554	20.2554	20.2554	11984.0
2012-11-20 05:35:00	AAPL	Stock	20.2679	20.2789	20.2679	20.2789	19600.0
2012-11-20 05:40:00	AAPL	Stock	20.2821	20.2821	20.2789	20.2789	11200.0
2012-11-20 05:45:00	AAPL	Stock	20.3	20.3	20.2875	20.2875	5600.0
2012-11-20 05:55:00	AAPL	Stock	20.2946	20.3	20.2779	20.2779	32984.0
2012-11-20 06:00:00	AAPL	Stock	20.2714	20.2714	20.2671	20.2671	25620.0
2012-11-20 06:05:00	AAPL	Stock	20.2554	20.2554	20.2525	20.2525	8400.0
2012-11-20 06:10:00	AAPL	Stock	20.2521	20.2668	20.2504	20.2554	16800.0
2012-11-20 06:15:00	AAPL	Stock	20.2554	20.2554	20.2554	20.2554	65604.0
2012-11-20 06:20:00	AAPL	Stock	20.255	20.2554	20.255	20.2554	44800.0
2012-11-20 06:25:00	AAPL	Stock	20.2554	20.2554	20.2432	20.2536	26040.0
2012-11-20 06:40:00	AAPL	Stock	20.2446	20.25	20.2446	20.25	14000.0
2012-11-20 06:50:00	AAPL	Stock	20.2446	20.2446	20.2343	20.2343	29400.0
2012-11-20 06:55:00	AAPL	Stock	20.2321	20.2321	20.2321	20.2321	8400.0
2012-11-20 07:00:00	AAPL	Stock	20.2407	20.2407	20.2321	20.2321	17556.0
2012-11-20 07:05:00	AAPL	Stock	20.2421	20.25	20.2421	20.2482	286300.0
2012-11-20 07:10:00	AAPL	Stock	20.2489	20.2489	20.2286	20.2375	53452.0
2012-11-20 07:15:00	AAPL	Stock	20.2311	20.2414	20.2286	20.2411	92736.0
2012-11-20 07:20:00	AAPL	Stock	20.2393	20.2393	20.23	20.2321	22372.0
2012-11-20 07:25:00	AAPL	Stock	20.2321	20.2389	20.2321	20.2336	14000.0
2012-11-20 07:30:00	AAPL	Stock	20.2286	20.2286	20.2196	20.2196	22316.0
2012-11-20 07:35:00	AAPL	Stock	20.22	20.2221	20.2036	20.2036	209356.0
2012-11-20 07:40:00	AAPL	Stock	20.1979	20.2054	20.1879	20.1946	177100.0
2012-11-20 07:45:00	AAPL	Stock	20.1843	20.1921	20.1825	20.1893	58436.0
2012-11-20 07:50:00	AAPL	Stock	20.1893	20.2021	20.1814	20.1964	107940.0
2012-11-20 07:55:00	AAPL	Stock	20.1964	20.1964	20.1839	20.1839	157920.0
2012-11-20 08:00:00	AAPL	Stock	20.1857	20.2554	20.1446	20.145	601748.0
2012-11-20 08:05:00	AAPL	Stock	20.1432	20.1432	20.1021	20.13	312340.0
2012-11-20 08:10:00	AAPL	Stock	20.13	20.1654	20.13	20.1654	131516.0
2012-11-20 08:15:00	AAPL	Stock	20.1607	20.2	20.1607	20.1857	173376.0
2012-11-20 08:20:00	AAPL	Stock	20.1946	20.1957	20.1746	20.1775	194488.0
2012-11-20 08:25:00	AAPL	Stock	20.1786	20.1868	20.1714	20.1861	186592.0
2012-11-20 08:30:00	AAPL	Stock	20.1846	20.1871	20.1661	20.1825	216328.0
2012-11-20 08:35:00	AAPL	Stock	20.1854	20.1854	20.1696	20.1761	108752.0
2012-11-20 08:40:00	AAPL	Stock	20.1686	20.1943	20.1661	20.1943	209076.0
2012-11-20 08:45:00	AAPL	Stock	20.1946	20.2232	20.1911	20.2232	287392.0
2012-11-20 08:50:00	AAPL	Stock	20.2257	20.25	20.2186	20.2482	607992.0

> showing 50 of 317,125 rows — these rows as CSV

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