PREVIEW / stock_5min / 2010-03-25

all stock 5-min files

  file:    by_date/stock_5min/2010/2010-03-25.parquet
  size:    4.9 MB
  rows:    332,606
  symbols: 3,493

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-03-25 05:05:00	AAPL	Stock	8.2054	8.2054	8.2054	8.2054	3052.0
2010-03-25 06:50:00	AAPL	Stock	8.2014	8.2014	8.2014	8.2014	8400.0
2010-03-25 07:10:00	AAPL	Stock	8.2282	8.2286	8.2282	8.2282	14000.0
2010-03-25 07:15:00	AAPL	Stock	8.2282	8.2346	8.225	8.225	110320.0
2010-03-25 07:20:00	AAPL	Stock	8.225	8.23	8.225	8.23	80472.0
2010-03-25 07:25:00	AAPL	Stock	8.2296	8.2296	8.2296	8.2296	8400.0
2010-03-25 07:30:00	AAPL	Stock	8.2296	8.2296	8.2296	8.2296	14000.0
2010-03-25 07:35:00	AAPL	Stock	8.2275	8.2275	8.2275	8.2275	2800.0
2010-03-25 07:40:00	AAPL	Stock	8.2286	8.2296	8.2286	8.2296	14000.0
2010-03-25 07:45:00	AAPL	Stock	8.2289	8.2289	8.2282	8.2282	29652.0
2010-03-25 07:50:00	AAPL	Stock	8.2286	8.2293	8.2257	8.2257	18760.0
2010-03-25 07:55:00	AAPL	Stock	8.2275	8.2282	8.2275	8.2279	14000.0
2010-03-25 08:00:00	AAPL	Stock	8.2261	8.2393	8.2229	8.2321	519260.0
2010-03-25 08:05:00	AAPL	Stock	8.2329	8.2329	8.2304	8.2318	35560.0
2010-03-25 08:10:00	AAPL	Stock	8.2304	8.2304	8.225	8.2304	46452.0
2010-03-25 08:15:00	AAPL	Stock	8.23	8.2304	8.2286	8.2304	95200.0
2010-03-25 08:20:00	AAPL	Stock	8.2307	8.2457	8.2304	8.2457	343308.0
2010-03-25 08:25:00	AAPL	Stock	8.2461	8.2475	8.2371	8.2382	242704.0
2010-03-25 08:30:00	AAPL	Stock	8.2386	8.2507	8.2325	8.2429	545608.0
2010-03-25 08:35:00	AAPL	Stock	8.2393	8.2429	8.2386	8.2418	128744.0
2010-03-25 08:40:00	AAPL	Stock	8.2411	8.2411	8.2321	8.2368	240100.0
2010-03-25 08:45:00	AAPL	Stock	8.2332	8.2375	8.2332	8.2336	64400.0
2010-03-25 08:50:00	AAPL	Stock	8.2339	8.2368	8.2321	8.2357	160356.0
2010-03-25 08:55:00	AAPL	Stock	8.2357	8.2393	8.2336	8.2364	98000.0
2010-03-25 09:00:00	AAPL	Stock	8.2364	8.2475	8.2364	8.2471	399812.0
2010-03-25 09:05:00	AAPL	Stock	8.2471	8.25	8.2429	8.25	802928.0
2010-03-25 09:10:00	AAPL	Stock	8.2489	8.25	8.2443	8.2482	386624.0
2010-03-25 09:15:00	AAPL	Stock	8.2489	8.2518	8.2461	8.2461	1317988.0
2010-03-25 09:20:00	AAPL	Stock	8.2457	8.2493	8.2361	8.2454	322000.0
2010-03-25 09:25:00	AAPL	Stock	8.2407	8.2482	8.2321	8.2482	582680.0
2010-03-25 09:30:00	AAPL	Stock	8.2471	8.2493	8.2143	8.2211	23774912.0
2010-03-25 09:35:00	AAPL	Stock	8.22	8.2321	8.2107	8.2179	15567384.0
2010-03-25 09:40:00	AAPL	Stock	8.2179	8.2321	8.2075	8.2319	10772272.0
2010-03-25 09:45:00	AAPL	Stock	8.2321	8.2329	8.2157	8.2157	9991352.0
2010-03-25 09:50:00	AAPL	Stock	8.2161	8.2195	8.2061	8.2068	11165868.0
2010-03-25 09:55:00	AAPL	Stock	8.207	8.2179	8.2057	8.21	6450612.0
2010-03-25 10:00:00	AAPL	Stock	8.2093	8.2175	8.2054	8.2073	8794212.0
2010-03-25 10:05:00	AAPL	Stock	8.2071	8.2089	8.195	8.2018	11991532.0
2010-03-25 10:10:00	AAPL	Stock	8.2024	8.2171	8.2004	8.2171	9194528.0
2010-03-25 10:15:00	AAPL	Stock	8.2171	8.2304	8.2121	8.2293	9540608.0
2010-03-25 10:20:00	AAPL	Stock	8.2296	8.2304	8.2143	8.2171	9105012.0
2010-03-25 10:25:00	AAPL	Stock	8.2171	8.2171	8.1961	8.2036	10840004.0
2010-03-25 10:30:00	AAPL	Stock	8.2029	8.2121	8.2004	8.2084	4183536.0
2010-03-25 10:35:00	AAPL	Stock	8.2086	8.2132	8.2079	8.21	3316740.0
2010-03-25 10:40:00	AAPL	Stock	8.21	8.2175	8.2079	8.2118	5780040.0
2010-03-25 10:45:00	AAPL	Stock	8.2115	8.2143	8.2071	8.2119	4082456.0
2010-03-25 10:50:00	AAPL	Stock	8.2121	8.2143	8.2004	8.2025	3765412.0
2010-03-25 10:55:00	AAPL	Stock	8.2022	8.2125	8.2004	8.2107	3035228.0
2010-03-25 11:00:00	AAPL	Stock	8.2089	8.2229	8.2071	8.22	6809516.0
2010-03-25 11:05:00	AAPL	Stock	8.2196	8.2254	8.2175	8.2246	4362232.0

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

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