PREVIEW / stock_1hour / 2014-10-13

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-10-13.parquet
  size:    1.0 MB
  rows:    49,753
  symbols: 3,535

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-10-13 04:00:00	AAPL	Stock	25.0975	25.1775	25.0	25.17	29120.0
2014-10-13 05:00:00	AAPL	Stock	25.175	25.1925	25.17	25.1725	27496.0
2014-10-13 06:00:00	AAPL	Stock	25.175	25.28	25.165	25.265	83856.0
2014-10-13 07:00:00	AAPL	Stock	25.2775	25.4125	25.2775	25.3375	248680.0
2014-10-13 08:00:00	AAPL	Stock	25.3375	25.425	25.2625	25.4125	1332220.0
2014-10-13 09:00:00	AAPL	Stock	25.4125	25.445	25.2225	25.29	27445372.0
2014-10-13 10:00:00	AAPL	Stock	25.29	25.3428	24.9575	25.1525	41538080.0
2014-10-13 11:00:00	AAPL	Stock	25.1525	25.3325	25.0775	25.2175	25543444.0
2014-10-13 12:00:00	AAPL	Stock	25.2175	25.3975	25.18	25.3375	18802812.0
2014-10-13 13:00:00	AAPL	Stock	25.3375	25.365	25.205	25.2915	15023596.0
2014-10-13 14:00:00	AAPL	Stock	25.29	25.36	25.22	25.2325	16161916.0
2014-10-13 15:00:00	AAPL	Stock	25.2325	25.2725	24.9525	24.9575	44154288.0
2014-10-13 16:00:00	AAPL	Stock	24.9525	25.1445	24.9375	24.9625	11188724.0
2014-10-13 17:00:00	AAPL	Stock	24.9525	26.0165	18.0487	24.9425	279368.0
2014-10-13 18:00:00	AAPL	Stock	24.95	25.226	24.9425	24.9575	254048.0
2014-10-13 19:00:00	AAPL	Stock	24.9575	24.9875	24.9575	24.9875	247272.0
2014-10-13 04:00:00	MSFT	Stock	43.84	43.85	43.77	43.85	5264.0
2014-10-13 05:00:00	MSFT	Stock	43.85	43.85	43.83	43.85	4500.0
2014-10-13 06:00:00	MSFT	Stock	43.85	43.95	43.85	43.95	7862.0
2014-10-13 07:00:00	MSFT	Stock	43.95	43.95	43.8	43.8	3800.0
2014-10-13 08:00:00	MSFT	Stock	43.82	43.9	43.74	43.81	22265.0
2014-10-13 09:00:00	MSFT	Stock	43.78	43.91	43.49	43.805	6281301.0
2014-10-13 10:00:00	MSFT	Stock	43.81	44.24	43.73	44.111	5315870.0
2014-10-13 11:00:00	MSFT	Stock	44.12	44.32	43.92	44.21	3267991.0
2014-10-13 12:00:00	MSFT	Stock	44.2	44.55	44.17	44.3	2933273.0
2014-10-13 13:00:00	MSFT	Stock	44.305	44.53	44.19	44.336	3348605.0
2014-10-13 14:00:00	MSFT	Stock	44.33	44.56	44.25	44.31	2501199.0
2014-10-13 15:00:00	MSFT	Stock	44.31	44.34	43.65	43.66	8874695.0
2014-10-13 16:00:00	MSFT	Stock	43.65	44.109	43.6	43.65	3071303.0
2014-10-13 17:00:00	MSFT	Stock	43.65	43.65	43.61	43.61	1400.0
2014-10-13 18:00:00	MSFT	Stock	43.61	44.203	43.56	43.57	74618.0
2014-10-13 19:00:00	MSFT	Stock	43.58	43.7	43.58	43.68	3020.0
2014-10-13 08:00:00	NVDA	Stock	0.4228	0.4238	0.4225	0.4238	108000.0
2014-10-13 09:00:00	NVDA	Stock	0.4248	0.4288	0.4213	0.4238	55965000.0
2014-10-13 10:00:00	NVDA	Stock	0.4238	0.4254	0.4192	0.4243	51924760.0
2014-10-13 11:00:00	NVDA	Stock	0.4245	0.4315	0.424	0.4301	62900520.0
2014-10-13 12:00:00	NVDA	Stock	0.4302	0.4325	0.4288	0.4315	35281880.0
2014-10-13 13:00:00	NVDA	Stock	0.4315	0.4322	0.426	0.427	35113360.0
2014-10-13 14:00:00	NVDA	Stock	0.427	0.4284	0.4254	0.4258	30212600.0
2014-10-13 15:00:00	NVDA	Stock	0.4258	0.4268	0.4195	0.4196	101737960.0
2014-10-13 16:00:00	NVDA	Stock	0.4196	0.4228	0.418	0.418	2397040.0
2014-10-13 04:00:00	AMZN	Stock	15.5005	15.525	15.4225	15.525	24560.0
2014-10-13 06:00:00	AMZN	Stock	15.5375	15.5565	15.5375	15.5565	13140.0
2014-10-13 07:00:00	AMZN	Stock	15.5625	15.5625	15.518	15.5325	63800.0
2014-10-13 08:00:00	AMZN	Stock	15.569	15.569	15.499	15.511	228740.0
2014-10-13 09:00:00	AMZN	Stock	15.521	15.5675	15.375	15.3998	12196520.0
2014-10-13 10:00:00	AMZN	Stock	15.4042	15.4435	15.1735	15.3588	16323540.0
2014-10-13 11:00:00	AMZN	Stock	15.3565	15.553	15.344	15.494	10057520.0
2014-10-13 12:00:00	AMZN	Stock	15.491	15.6565	15.4385	15.5955	7599280.0
2014-10-13 13:00:00	AMZN	Stock	15.6055	15.66	15.514	15.5465	5398840.0

> showing 50 of 49,753 rows — these rows as CSV

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