PREVIEW / stock_5min / 2010-07-26

all stock 5-min files

  file:    by_date/stock_5min/2010/2010-07-26.parquet
  size:    4.8 MB
  rows:    332,595
  symbols: 3,476

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
2010-07-26 06:00:00	AAPL	Stock	9.2871	9.2871	9.2871	9.2871	2800.0
2010-07-26 06:15:00	AAPL	Stock	9.2957	9.2957	9.2929	9.2943	8400.0
2010-07-26 06:40:00	AAPL	Stock	9.2861	9.2861	9.2861	9.2861	12320.0
2010-07-26 06:45:00	AAPL	Stock	9.2871	9.2871	9.2871	9.2871	5600.0
2010-07-26 06:50:00	AAPL	Stock	9.2854	9.2854	9.2854	9.2854	8400.0
2010-07-26 06:55:00	AAPL	Stock	9.2786	9.2786	9.2786	9.2786	5600.0
2010-07-26 07:00:00	AAPL	Stock	9.2857	9.2857	9.2746	9.2854	29400.0
2010-07-26 07:05:00	AAPL	Stock	9.2854	9.2864	9.2854	9.2864	33740.0
2010-07-26 07:10:00	AAPL	Stock	9.2864	9.2864	9.2854	9.2854	5600.0
2010-07-26 07:30:00	AAPL	Stock	9.275	9.275	9.2682	9.2682	22400.0
2010-07-26 07:35:00	AAPL	Stock	9.2793	9.2793	9.2386	9.2386	33600.0
2010-07-26 07:40:00	AAPL	Stock	9.2629	9.2629	9.2532	9.2532	27916.0
2010-07-26 07:55:00	AAPL	Stock	9.275	9.275	9.275	9.275	2800.0
2010-07-26 08:00:00	AAPL	Stock	9.27	9.2746	9.2679	9.2732	115752.0
2010-07-26 08:05:00	AAPL	Stock	9.2689	9.2689	9.2607	9.2657	128016.0
2010-07-26 08:10:00	AAPL	Stock	9.2639	9.2671	9.2611	9.2661	83776.0
2010-07-26 08:15:00	AAPL	Stock	9.2636	9.2657	9.2564	9.2564	72744.0
2010-07-26 08:20:00	AAPL	Stock	9.2571	9.2571	9.2507	9.2507	33600.0
2010-07-26 08:25:00	AAPL	Stock	9.2511	9.2554	9.2511	9.2554	17584.0
2010-07-26 08:30:00	AAPL	Stock	9.2554	9.2671	9.2554	9.2654	173600.0
2010-07-26 08:35:00	AAPL	Stock	9.2657	9.2757	9.2646	9.2714	98224.0
2010-07-26 08:40:00	AAPL	Stock	9.2686	9.2686	9.2575	9.2575	84252.0
2010-07-26 08:45:00	AAPL	Stock	9.2607	9.2607	9.2596	9.26	84000.0
2010-07-26 08:50:00	AAPL	Stock	9.2639	9.2732	9.2639	9.2732	171500.0
2010-07-26 08:55:00	AAPL	Stock	9.2746	9.2764	9.2736	9.2764	97524.0
2010-07-26 09:00:00	AAPL	Stock	9.275	9.2996	9.275	9.2918	596344.0
2010-07-26 09:05:00	AAPL	Stock	9.2914	9.3114	9.29	9.3107	732340.0
2010-07-26 09:10:00	AAPL	Stock	9.3107	9.3129	9.3018	9.3036	829696.0
2010-07-26 09:15:00	AAPL	Stock	9.3018	9.3046	9.2989	9.3036	61600.0
2010-07-26 09:20:00	AAPL	Stock	9.3046	9.3071	9.2954	9.3032	267680.0
2010-07-26 09:25:00	AAPL	Stock	9.3011	9.3014	9.2857	9.2857	685440.0
2010-07-26 09:30:00	AAPL	Stock	9.2868	9.2893	9.2589	9.2664	11966584.0
2010-07-26 09:35:00	AAPL	Stock	9.2668	9.2673	9.2357	9.2421	12383028.0
2010-07-26 09:40:00	AAPL	Stock	9.24	9.2482	9.2189	9.2371	12236980.0
2010-07-26 09:45:00	AAPL	Stock	9.2376	9.2589	9.2346	9.2482	7399224.0
2010-07-26 09:50:00	AAPL	Stock	9.2482	9.2543	9.2154	9.2232	11003692.0
2010-07-26 09:55:00	AAPL	Stock	9.2291	9.2489	9.2221	9.2254	9538256.0
2010-07-26 10:00:00	AAPL	Stock	9.2254	9.2668	9.2254	9.2614	11298364.0
2010-07-26 10:05:00	AAPL	Stock	9.2593	9.27	9.2471	9.2668	7117124.0
2010-07-26 10:10:00	AAPL	Stock	9.2671	9.2768	9.2589	9.2675	8719340.0
2010-07-26 10:15:00	AAPL	Stock	9.2679	9.2761	9.2468	9.2482	7405216.0
2010-07-26 10:20:00	AAPL	Stock	9.2507	9.2507	9.2236	9.2318	10187576.0
2010-07-26 10:25:00	AAPL	Stock	9.2318	9.2393	9.2246	9.235	4117848.0
2010-07-26 10:30:00	AAPL	Stock	9.2354	9.2429	9.2039	9.2189	11076520.0
2010-07-26 10:35:00	AAPL	Stock	9.2221	9.2332	9.2182	9.2296	4260676.0
2010-07-26 10:40:00	AAPL	Stock	9.2283	9.2354	9.219	9.2236	3368652.0
2010-07-26 10:45:00	AAPL	Stock	9.2225	9.2354	9.2161	9.2331	5640348.0
2010-07-26 10:50:00	AAPL	Stock	9.2346	9.2414	9.2293	9.2404	3823624.0
2010-07-26 10:55:00	AAPL	Stock	9.2395	9.2536	9.2393	9.2521	4943820.0
2010-07-26 11:00:00	AAPL	Stock	9.2529	9.2614	9.245	9.2507	5851944.0

> showing 50 of 332,595 rows — these rows as CSV

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