PREVIEW / stock_5min / 2014-07-03

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-07-03.parquet
  size:    3.3 MB
  rows:    207,592
  symbols: 3,537

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
2014-07-03 04:40:00	AAPL	Stock	23.4075	23.4075	23.4075	23.4075	400.0
2014-07-03 05:00:00	AAPL	Stock	23.4	23.4	23.4	23.4	800.0
2014-07-03 05:15:00	AAPL	Stock	23.3875	23.4	23.3875	23.4	2800.0
2014-07-03 05:20:00	AAPL	Stock	23.3775	23.3775	23.3775	23.3775	1200.0
2014-07-03 05:30:00	AAPL	Stock	23.3925	23.3925	23.3925	23.3925	560.0
2014-07-03 05:45:00	AAPL	Stock	23.3975	23.3975	23.3975	23.3975	1200.0
2014-07-03 05:50:00	AAPL	Stock	23.3975	23.4	23.3975	23.4	2240.0
2014-07-03 05:55:00	AAPL	Stock	23.3975	23.4	23.3975	23.4	2800.0
2014-07-03 06:00:00	AAPL	Stock	23.4075	23.4075	23.4075	23.4075	1920.0
2014-07-03 06:05:00	AAPL	Stock	23.42	23.445	23.42	23.445	3200.0
2014-07-03 06:15:00	AAPL	Stock	23.42	23.42	23.42	23.42	7120.0
2014-07-03 06:35:00	AAPL	Stock	23.4325	23.4325	23.4325	23.4325	2556.0
2014-07-03 06:40:00	AAPL	Stock	23.43	23.43	23.43	23.43	636.0
2014-07-03 06:55:00	AAPL	Stock	23.425	23.425	23.42	23.42	10400.0
2014-07-03 07:00:00	AAPL	Stock	23.42	23.42	23.41	23.41	11248.0
2014-07-03 07:05:00	AAPL	Stock	23.42	23.45	23.42	23.4375	36920.0
2014-07-03 07:10:00	AAPL	Stock	23.4375	23.4375	23.4375	23.4375	15028.0
2014-07-03 07:15:00	AAPL	Stock	23.43	23.43	23.43	23.43	4000.0
2014-07-03 07:25:00	AAPL	Stock	23.425	23.425	23.38	23.38	28148.0
2014-07-03 07:30:00	AAPL	Stock	23.42	23.42	23.4175	23.4175	4800.0
2014-07-03 07:40:00	AAPL	Stock	23.4125	23.4125	23.4125	23.4125	1200.0
2014-07-03 07:50:00	AAPL	Stock	23.4175	23.4175	23.4	23.4	9700.0
2014-07-03 07:55:00	AAPL	Stock	23.395	23.395	23.395	23.395	400.0
2014-07-03 08:00:00	AAPL	Stock	23.415	23.4375	23.375	23.385	92040.0
2014-07-03 08:05:00	AAPL	Stock	23.385	23.4	23.385	23.3875	66000.0
2014-07-03 08:10:00	AAPL	Stock	23.395	23.395	23.375	23.38	28284.0
2014-07-03 08:15:00	AAPL	Stock	23.38	23.385	23.375	23.375	12440.0
2014-07-03 08:20:00	AAPL	Stock	23.385	23.385	23.3725	23.375	31236.0
2014-07-03 08:25:00	AAPL	Stock	23.375	23.4	23.375	23.375	38732.0
2014-07-03 08:30:00	AAPL	Stock	23.3925	23.4375	23.3625	23.4375	238548.0
2014-07-03 08:35:00	AAPL	Stock	23.4325	23.4375	23.415	23.42	65780.0
2014-07-03 08:40:00	AAPL	Stock	23.4125	23.425	23.41	23.4225	23964.0
2014-07-03 08:45:00	AAPL	Stock	23.4225	23.425	23.4125	23.4125	27360.0
2014-07-03 08:50:00	AAPL	Stock	23.425	23.425	23.4125	23.415	33816.0
2014-07-03 08:55:00	AAPL	Stock	23.425	23.435	23.415	23.4325	148996.0
2014-07-03 09:00:00	AAPL	Stock	23.435	23.435	23.4225	23.43	45296.0
2014-07-03 09:05:00	AAPL	Stock	23.43	23.4325	23.4175	23.425	29804.0
2014-07-03 09:10:00	AAPL	Stock	23.425	23.425	23.4175	23.425	22304.0
2014-07-03 09:15:00	AAPL	Stock	23.4225	23.4275	23.4175	23.4225	34200.0
2014-07-03 09:20:00	AAPL	Stock	23.425	23.425	23.42	23.425	52512.0
2014-07-03 09:25:00	AAPL	Stock	23.4225	23.425	23.405	23.42	32480.0
2014-07-03 09:30:00	AAPL	Stock	23.4125	23.425	23.34	23.3597	5340912.0
2014-07-03 09:35:00	AAPL	Stock	23.355	23.375	23.305	23.3625	2324536.0
2014-07-03 09:40:00	AAPL	Stock	23.3625	23.3775	23.33	23.355	1859584.0
2014-07-03 09:45:00	AAPL	Stock	23.3525	23.365	23.3325	23.345	2020400.0
2014-07-03 09:50:00	AAPL	Stock	23.3425	23.37	23.3275	23.3475	1832332.0
2014-07-03 09:55:00	AAPL	Stock	23.35	23.3975	23.3475	23.3875	2434696.0
2014-07-03 10:00:00	AAPL	Stock	23.3898	23.395	23.3425	23.375	2153836.0
2014-07-03 10:05:00	AAPL	Stock	23.3775	23.3825	23.3325	23.3668	1743948.0
2014-07-03 10:10:00	AAPL	Stock	23.365	23.3805	23.3502	23.365	881724.0

> showing 50 of 207,592 rows — these rows as CSV

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