PREVIEW / stock_5min / 2014-03-27

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-03-27.parquet
  size:    5.5 MB
  rows:    366,375
  symbols: 3,528

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-03-27 05:40:00	AAPL	Stock	19.25	19.25	19.25	19.25	12600.0
2014-03-27 07:00:00	AAPL	Stock	19.3129	19.3129	19.28	19.2875	14000.0
2014-03-27 07:05:00	AAPL	Stock	19.2996	19.2996	19.2996	19.2996	4200.0
2014-03-27 07:10:00	AAPL	Stock	19.3136	19.3136	19.3121	19.3121	5600.0
2014-03-27 07:15:00	AAPL	Stock	19.3029	19.3029	19.2964	19.2964	11340.0
2014-03-27 07:20:00	AAPL	Stock	19.3	19.3	19.3	19.3	12992.0
2014-03-27 07:25:00	AAPL	Stock	19.3054	19.3054	19.3054	19.3054	27300.0
2014-03-27 07:30:00	AAPL	Stock	19.31	19.3111	19.31	19.3111	5880.0
2014-03-27 07:35:00	AAPL	Stock	19.3	19.3	19.3	19.3	2800.0
2014-03-27 07:45:00	AAPL	Stock	19.2868	19.2868	19.2857	19.2857	34300.0
2014-03-27 07:55:00	AAPL	Stock	19.2821	19.2821	19.2821	19.2821	3780.0
2014-03-27 08:00:00	AAPL	Stock	19.3146	19.3146	19.2786	19.2804	34720.0
2014-03-27 08:05:00	AAPL	Stock	19.2804	19.2825	19.2804	19.2825	8400.0
2014-03-27 08:10:00	AAPL	Stock	19.2786	19.2786	19.2464	19.2464	227808.0
2014-03-27 08:15:00	AAPL	Stock	19.2371	19.2371	19.2264	19.2282	54600.0
2014-03-27 08:20:00	AAPL	Stock	19.2411	19.25	19.2321	19.25	27328.0
2014-03-27 08:25:00	AAPL	Stock	19.25	19.2782	19.25	19.2782	53200.0
2014-03-27 08:30:00	AAPL	Stock	19.2775	19.2839	19.2611	19.2839	90972.0
2014-03-27 08:35:00	AAPL	Stock	19.2754	19.2768	19.2679	19.275	67508.0
2014-03-27 08:40:00	AAPL	Stock	19.2711	19.2736	19.2679	19.2679	54740.0
2014-03-27 08:45:00	AAPL	Stock	19.2679	19.2679	19.2361	19.25	148400.0
2014-03-27 08:50:00	AAPL	Stock	19.2561	19.2589	19.25	19.25	22232.0
2014-03-27 08:55:00	AAPL	Stock	19.2607	19.2643	19.2571	19.2643	45444.0
2014-03-27 09:00:00	AAPL	Stock	19.2696	19.2743	19.2643	19.2743	25816.0
2014-03-27 09:05:00	AAPL	Stock	19.2679	19.2679	19.2679	19.2679	4060.0
2014-03-27 09:10:00	AAPL	Stock	19.2768	19.2768	19.2768	19.2768	5600.0
2014-03-27 09:15:00	AAPL	Stock	19.2768	19.2832	19.2768	19.2832	58800.0
2014-03-27 09:20:00	AAPL	Stock	19.2832	19.3014	19.2832	19.2871	89208.0
2014-03-27 09:25:00	AAPL	Stock	19.2982	19.2982	19.2707	19.2957	129360.0
2014-03-27 09:30:00	AAPL	Stock	19.2862	19.33	19.2554	19.2857	8789452.0
2014-03-27 09:35:00	AAPL	Stock	19.2826	19.2882	19.1607	19.1693	7690312.0
2014-03-27 09:40:00	AAPL	Stock	19.1679	19.2096	19.1657	19.1911	4639292.0
2014-03-27 09:45:00	AAPL	Stock	19.1904	19.2454	19.175	19.2389	5556908.0
2014-03-27 09:50:00	AAPL	Stock	19.2371	19.2639	19.2175	19.2546	4091136.0
2014-03-27 09:55:00	AAPL	Stock	19.2571	19.2654	19.2286	19.2639	3339112.0
2014-03-27 10:00:00	AAPL	Stock	19.2607	19.2671	19.24	19.2636	2456468.0
2014-03-27 10:05:00	AAPL	Stock	19.2529	19.3189	19.2434	19.2986	5229588.0
2014-03-27 10:10:00	AAPL	Stock	19.3014	19.3393	19.2589	19.2636	5223764.0
2014-03-27 10:15:00	AAPL	Stock	19.2689	19.2868	19.2271	19.255	2609740.0
2014-03-27 10:20:00	AAPL	Stock	19.2586	19.2889	19.2532	19.26	3303328.0
2014-03-27 10:25:00	AAPL	Stock	19.2636	19.2964	19.2521	19.2557	2266516.0
2014-03-27 10:30:00	AAPL	Stock	19.2561	19.2643	19.2346	19.2504	1767472.0
2014-03-27 10:35:00	AAPL	Stock	19.2546	19.2754	19.2129	19.2164	2818872.0
2014-03-27 10:40:00	AAPL	Stock	19.2148	19.2225	19.1961	19.1982	2383248.0
2014-03-27 10:45:00	AAPL	Stock	19.1964	19.2321	19.1907	19.2211	2157708.0
2014-03-27 10:50:00	AAPL	Stock	19.2254	19.2321	19.205	19.2204	1605716.0
2014-03-27 10:55:00	AAPL	Stock	19.2204	19.2639	19.22	19.2496	2393188.0
2014-03-27 11:00:00	AAPL	Stock	19.25	19.2679	19.2264	19.2265	1336776.0
2014-03-27 11:05:00	AAPL	Stock	19.2329	19.2564	19.2086	19.225	1346800.0
2014-03-27 11:10:00	AAPL	Stock	19.2196	19.2354	19.2036	19.2125	1109836.0

> showing 50 of 366,375 rows — these rows as CSV

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