PREVIEW / stock_5min / 2011-01-27

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-01-27.parquet
  size:    4.8 MB
  rows:    326,285
  symbols: 3,540

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
2011-01-27 04:20:00	AAPL	Stock	12.3032	12.3032	12.3032	12.3032	5600.0
2011-01-27 05:30:00	AAPL	Stock	12.3107	12.3107	12.3107	12.3107	2800.0
2011-01-27 05:40:00	AAPL	Stock	12.3225	12.3225	12.3214	12.3214	22400.0
2011-01-27 05:50:00	AAPL	Stock	12.3214	12.3386	12.3214	12.3386	16800.0
2011-01-27 06:00:00	AAPL	Stock	12.3257	12.3257	12.325	12.325	14000.0
2011-01-27 06:15:00	AAPL	Stock	12.3339	12.3339	12.3339	12.3339	5600.0
2011-01-27 06:20:00	AAPL	Stock	12.3339	12.3339	12.3339	12.3339	13720.0
2011-01-27 06:25:00	AAPL	Stock	12.3375	12.3375	12.3329	12.3329	5600.0
2011-01-27 06:30:00	AAPL	Stock	12.3189	12.3189	12.3189	12.3189	2800.0
2011-01-27 06:35:00	AAPL	Stock	12.3214	12.3214	12.3214	12.3214	2800.0
2011-01-27 06:50:00	AAPL	Stock	12.3268	12.3268	12.3268	12.3268	14000.0
2011-01-27 07:00:00	AAPL	Stock	12.3268	12.3268	12.3214	12.3214	8400.0
2011-01-27 07:10:00	AAPL	Stock	12.3214	12.3214	12.3214	12.3214	5600.0
2011-01-27 07:15:00	AAPL	Stock	12.3304	12.3304	12.3304	12.3304	2800.0
2011-01-27 07:20:00	AAPL	Stock	12.3214	12.3214	12.3214	12.3214	5600.0
2011-01-27 07:25:00	AAPL	Stock	12.3214	12.3214	12.295	12.3079	71120.0
2011-01-27 07:30:00	AAPL	Stock	12.3186	12.3207	12.3143	12.3207	12880.0
2011-01-27 07:35:00	AAPL	Stock	12.315	12.3214	12.315	12.3214	62160.0
2011-01-27 07:40:00	AAPL	Stock	12.3214	12.3214	12.3214	12.3214	2800.0
2011-01-27 07:45:00	AAPL	Stock	12.3214	12.3214	12.3214	12.3214	8400.0
2011-01-27 07:50:00	AAPL	Stock	12.3157	12.3157	12.3157	12.3157	2800.0
2011-01-27 07:55:00	AAPL	Stock	12.3161	12.3186	12.3161	12.3186	18284.0
2011-01-27 08:00:00	AAPL	Stock	12.3054	12.3193	12.3043	12.3193	172620.0
2011-01-27 08:05:00	AAPL	Stock	12.3139	12.3143	12.3107	12.3107	76860.0
2011-01-27 08:10:00	AAPL	Stock	12.3161	12.3168	12.3057	12.3129	103348.0
2011-01-27 08:15:00	AAPL	Stock	12.3071	12.3071	12.3018	12.3043	128660.0
2011-01-27 08:20:00	AAPL	Stock	12.3075	12.3161	12.3075	12.3161	31920.0
2011-01-27 08:25:00	AAPL	Stock	12.3136	12.3175	12.3136	12.3175	88900.0
2011-01-27 08:30:00	AAPL	Stock	12.3107	12.3107	12.2871	12.2943	226968.0
2011-01-27 08:35:00	AAPL	Stock	12.2907	12.2907	12.2779	12.2893	284760.0
2011-01-27 08:40:00	AAPL	Stock	12.2882	12.2882	12.25	12.275	487704.0
2011-01-27 08:45:00	AAPL	Stock	12.2729	12.2729	12.25	12.2536	129808.0
2011-01-27 08:50:00	AAPL	Stock	12.2589	12.2679	12.2589	12.2618	106092.0
2011-01-27 08:55:00	AAPL	Stock	12.2618	12.2821	12.2611	12.2661	102872.0
2011-01-27 09:00:00	AAPL	Stock	12.2661	12.2671	12.2571	12.2571	84672.0
2011-01-27 09:05:00	AAPL	Stock	12.2607	12.2625	12.2554	12.2607	88200.0
2011-01-27 09:10:00	AAPL	Stock	12.2589	12.2607	12.2543	12.2579	74424.0
2011-01-27 09:15:00	AAPL	Stock	12.26	12.2907	12.26	12.2893	96600.0
2011-01-27 09:20:00	AAPL	Stock	12.2893	12.2961	12.2789	12.2804	295848.0
2011-01-27 09:25:00	AAPL	Stock	12.2793	12.2821	12.275	12.2779	1289932.0
2011-01-27 09:30:00	AAPL	Stock	12.2779	12.2911	12.2486	12.2754	13350316.0
2011-01-27 09:35:00	AAPL	Stock	12.2732	12.2857	12.2543	12.2634	7387912.0
2011-01-27 09:40:00	AAPL	Stock	12.2636	12.2771	12.2464	12.2571	7777504.0
2011-01-27 09:45:00	AAPL	Stock	12.2564	12.2754	12.244	12.2746	8420888.0
2011-01-27 09:50:00	AAPL	Stock	12.2746	12.2829	12.2575	12.2818	6367032.0
2011-01-27 09:55:00	AAPL	Stock	12.2807	12.3025	12.2757	12.2914	7568064.0
2011-01-27 10:00:00	AAPL	Stock	12.2936	12.3036	12.265	12.2729	7417788.0
2011-01-27 10:05:00	AAPL	Stock	12.2729	12.2839	12.2646	12.2755	4065208.0
2011-01-27 10:10:00	AAPL	Stock	12.2754	12.2943	12.2732	12.2836	3715180.0
2011-01-27 10:15:00	AAPL	Stock	12.2857	12.2946	12.2821	12.2928	2699956.0

> showing 50 of 326,285 rows — these rows as CSV

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