PREVIEW / stock_5min / 2010-04-22

all stock 5-min files

  file:    by_date/stock_5min/2010/2010-04-22.parquet
  size:    4.9 MB
  rows:    333,758
  symbols: 3,473

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-04-22 04:05:00	AAPL	Stock	9.2689	9.2689	9.2689	9.2689	14000.0
2010-04-22 04:10:00	AAPL	Stock	9.2732	9.2732	9.2732	9.2732	14000.0
2010-04-22 04:15:00	AAPL	Stock	9.2504	9.2718	9.2504	9.2718	8400.0
2010-04-22 04:20:00	AAPL	Stock	9.2732	9.2732	9.2643	9.2643	19600.0
2010-04-22 04:25:00	AAPL	Stock	9.2643	9.2643	9.2625	9.2625	21140.0
2010-04-22 04:30:00	AAPL	Stock	9.2625	9.2625	9.2625	9.2625	30800.0
2010-04-22 04:35:00	AAPL	Stock	9.2625	9.2625	9.2625	9.2625	4060.0
2010-04-22 04:40:00	AAPL	Stock	9.2625	9.2625	9.2625	9.2625	2800.0
2010-04-22 04:45:00	AAPL	Stock	9.2571	9.2571	9.2571	9.2571	2800.0
2010-04-22 04:50:00	AAPL	Stock	9.2589	9.265	9.2571	9.2589	36400.0
2010-04-22 04:55:00	AAPL	Stock	9.2571	9.2629	9.2571	9.2575	33600.0
2010-04-22 05:00:00	AAPL	Stock	9.2575	9.2593	9.2575	9.2575	58800.0
2010-04-22 05:05:00	AAPL	Stock	9.2539	9.2539	9.2464	9.2464	25200.0
2010-04-22 05:30:00	AAPL	Stock	9.2236	9.2236	9.2236	9.2236	12600.0
2010-04-22 05:35:00	AAPL	Stock	9.2171	9.2171	9.2171	9.2171	4200.0
2010-04-22 05:45:00	AAPL	Stock	9.2146	9.2146	9.2146	9.2146	2800.0
2010-04-22 06:00:00	AAPL	Stock	9.2318	9.2318	9.2318	9.2318	2800.0
2010-04-22 06:10:00	AAPL	Stock	9.2146	9.2146	9.2071	9.2071	9800.0
2010-04-22 06:15:00	AAPL	Stock	9.2071	9.2071	9.2071	9.2071	11200.0
2010-04-22 06:25:00	AAPL	Stock	9.2211	9.2211	9.2211	9.2211	2800.0
2010-04-22 06:40:00	AAPL	Stock	9.2075	9.2143	9.2075	9.2143	19600.0
2010-04-22 06:45:00	AAPL	Stock	9.2079	9.2079	9.2079	9.2079	2800.0
2010-04-22 06:50:00	AAPL	Stock	9.2139	9.2139	9.2136	9.2136	8400.0
2010-04-22 06:55:00	AAPL	Stock	9.2143	9.2143	9.2143	9.2143	25200.0
2010-04-22 07:00:00	AAPL	Stock	9.2211	9.2211	9.2211	9.2211	2800.0
2010-04-22 07:10:00	AAPL	Stock	9.2214	9.2214	9.2214	9.2214	28000.0
2010-04-22 07:20:00	AAPL	Stock	9.2164	9.2179	9.2164	9.2179	19600.0
2010-04-22 07:30:00	AAPL	Stock	9.2121	9.2161	9.2107	9.2107	39172.0
2010-04-22 07:35:00	AAPL	Stock	9.2204	9.2204	9.2146	9.2146	11200.0
2010-04-22 07:40:00	AAPL	Stock	9.2146	9.2196	9.2146	9.2196	8400.0
2010-04-22 07:45:00	AAPL	Stock	9.2207	9.2321	9.2189	9.2321	91224.0
2010-04-22 07:50:00	AAPL	Stock	9.2289	9.2321	9.2143	9.2175	107716.0
2010-04-22 07:55:00	AAPL	Stock	9.2196	9.2214	9.2179	9.2214	62468.0
2010-04-22 08:00:00	AAPL	Stock	9.2196	9.2232	9.2129	9.2196	277704.0
2010-04-22 08:05:00	AAPL	Stock	9.2196	9.2336	9.2196	9.2321	413196.0
2010-04-22 08:10:00	AAPL	Stock	9.2336	9.2389	9.2321	9.2359	134764.0
2010-04-22 08:15:00	AAPL	Stock	9.2389	9.2432	9.2361	9.2361	200844.0
2010-04-22 08:20:00	AAPL	Stock	9.2382	9.2407	9.2271	9.2271	130592.0
2010-04-22 08:25:00	AAPL	Stock	9.2304	9.2321	9.2268	9.2286	89068.0
2010-04-22 08:30:00	AAPL	Stock	9.2304	9.2325	9.2232	9.2282	231392.0
2010-04-22 08:35:00	AAPL	Stock	9.2286	9.2304	9.2252	9.2304	103796.0
2010-04-22 08:40:00	AAPL	Stock	9.2261	9.23	9.2246	9.2268	30800.0
2010-04-22 08:45:00	AAPL	Stock	9.2307	9.2318	9.2261	9.2282	65632.0
2010-04-22 08:50:00	AAPL	Stock	9.2279	9.2282	9.2236	9.2282	44660.0
2010-04-22 08:55:00	AAPL	Stock	9.225	9.2282	9.2239	9.2264	34860.0
2010-04-22 09:00:00	AAPL	Stock	9.2282	9.2282	9.2118	9.2143	527100.0
2010-04-22 09:05:00	AAPL	Stock	9.2132	9.2143	9.2089	9.2143	464940.0
2010-04-22 09:10:00	AAPL	Stock	9.2143	9.215	9.2089	9.2096	163716.0
2010-04-22 09:15:00	AAPL	Stock	9.2096	9.2107	9.2054	9.2098	179368.0
2010-04-22 09:20:00	AAPL	Stock	9.2139	9.2171	9.2139	9.2146	86800.0

> showing 50 of 333,758 rows — these rows as CSV

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