PREVIEW / stock_5min / 2013-12-23

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-12-23.parquet
  size:    5.5 MB
  rows:    370,460
  symbols: 3,543

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-12-23 04:00:00	AAPL	Stock	19.7861	20.3446	19.7861	20.1075	197400.0
2013-12-23 04:05:00	AAPL	Stock	20.1404	20.1504	20.1089	20.1504	33068.0
2013-12-23 04:10:00	AAPL	Stock	20.1746	20.1786	20.1746	20.1768	33600.0
2013-12-23 04:15:00	AAPL	Stock	20.1854	20.1979	20.1854	20.1979	6300.0
2013-12-23 04:20:00	AAPL	Stock	20.2143	20.2143	20.2136	20.2136	57960.0
2013-12-23 04:25:00	AAPL	Stock	20.2139	20.2139	20.1786	20.1964	26600.0
2013-12-23 04:30:00	AAPL	Stock	20.2014	20.2032	20.1832	20.1843	81200.0
2013-12-23 04:35:00	AAPL	Stock	20.1818	20.2011	20.1768	20.1786	118272.0
2013-12-23 04:40:00	AAPL	Stock	20.1768	20.1843	20.1768	20.1786	92400.0
2013-12-23 04:45:00	AAPL	Stock	20.1786	20.1786	20.1775	20.1775	61600.0
2013-12-23 04:50:00	AAPL	Stock	20.1782	20.1782	20.1782	20.1782	2800.0
2013-12-23 04:55:00	AAPL	Stock	20.1786	20.1846	20.1786	20.1846	48888.0
2013-12-23 05:05:00	AAPL	Stock	20.2118	20.2118	20.2118	20.2118	2800.0
2013-12-23 05:10:00	AAPL	Stock	20.2125	20.2507	20.2125	20.2507	36400.0
2013-12-23 05:15:00	AAPL	Stock	20.2607	20.2607	20.2511	20.2511	14000.0
2013-12-23 05:20:00	AAPL	Stock	20.2411	20.2411	20.2411	20.2411	2800.0
2013-12-23 05:25:00	AAPL	Stock	20.25	20.25	20.25	20.25	6972.0
2013-12-23 05:30:00	AAPL	Stock	20.2493	20.2943	20.2493	20.2943	46144.0
2013-12-23 05:35:00	AAPL	Stock	20.2989	20.3	20.2989	20.2993	11200.0
2013-12-23 05:40:00	AAPL	Stock	20.2918	20.2954	20.2918	20.2954	32284.0
2013-12-23 05:45:00	AAPL	Stock	20.2954	20.2954	20.2857	20.2857	38108.0
2013-12-23 05:50:00	AAPL	Stock	20.2954	20.3036	20.2954	20.3036	7840.0
2013-12-23 06:00:00	AAPL	Stock	20.3304	20.3304	20.3275	20.3275	34076.0
2013-12-23 06:05:00	AAPL	Stock	20.3379	20.3379	20.2954	20.2954	39200.0
2013-12-23 06:10:00	AAPL	Stock	20.3021	20.3036	20.3	20.3036	16800.0
2013-12-23 06:20:00	AAPL	Stock	20.345	20.3482	20.3289	20.3289	57820.0
2013-12-23 06:25:00	AAPL	Stock	20.3407	20.3482	20.3214	20.3461	43400.0
2013-12-23 06:30:00	AAPL	Stock	20.3479	20.3479	20.3214	20.3214	36400.0
2013-12-23 06:35:00	AAPL	Stock	20.3339	20.3393	20.3214	20.3214	38500.0
2013-12-23 06:40:00	AAPL	Stock	20.3279	20.3364	20.3279	20.3364	14000.0
2013-12-23 06:45:00	AAPL	Stock	20.3368	20.3368	20.3218	20.3346	33600.0
2013-12-23 06:50:00	AAPL	Stock	20.3214	20.3218	20.3036	20.3036	227808.0
2013-12-23 06:55:00	AAPL	Stock	20.3036	20.3036	20.2975	20.2975	25284.0
2013-12-23 07:00:00	AAPL	Stock	20.2911	20.4111	20.2911	20.4111	296632.0
2013-12-23 07:05:00	AAPL	Stock	20.4104	20.4654	20.4104	20.4371	613396.0
2013-12-23 07:10:00	AAPL	Stock	20.4532	20.4532	20.4	20.4039	458808.0
2013-12-23 07:15:00	AAPL	Stock	20.4039	20.4046	20.3571	20.375	376824.0
2013-12-23 07:20:00	AAPL	Stock	20.375	20.375	20.3321	20.3357	452200.0
2013-12-23 07:25:00	AAPL	Stock	20.3379	20.3571	20.3036	20.3036	437332.0
2013-12-23 07:30:00	AAPL	Stock	20.3021	20.3314	20.2975	20.3268	185388.0
2013-12-23 07:35:00	AAPL	Stock	20.3314	20.3446	20.3118	20.3196	376040.0
2013-12-23 07:40:00	AAPL	Stock	20.3189	20.3189	20.2975	20.3004	263088.0
2013-12-23 07:45:00	AAPL	Stock	20.3036	20.3214	20.2964	20.2964	384524.0
2013-12-23 07:50:00	AAPL	Stock	20.295	20.295	20.2275	20.2286	697228.0
2013-12-23 07:55:00	AAPL	Stock	20.2304	20.2589	20.2107	20.2521	603960.0
2013-12-23 08:00:00	AAPL	Stock	20.2729	20.4643	20.1786	20.296	1700552.0
2013-12-23 08:05:00	AAPL	Stock	20.2904	20.3036	20.2679	20.2682	692636.0
2013-12-23 08:10:00	AAPL	Stock	20.2807	20.2854	20.25	20.2811	639604.0
2013-12-23 08:15:00	AAPL	Stock	20.2789	20.285	20.2518	20.2643	496944.0
2013-12-23 08:20:00	AAPL	Stock	20.2579	20.2846	20.2579	20.2639	327572.0

> showing 50 of 370,460 rows — these rows as CSV

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