PREVIEW / stock_1hour / 2011-11-21

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-11-21.parquet
  size:    925 KB
  rows:    44,405
  symbols: 3,513

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
2011-11-21 04:00:00	AAPL	Stock	13.1821	13.1975	13.1332	13.1429	116200.0
2011-11-21 05:00:00	AAPL	Stock	13.1518	13.2136	13.1518	13.2136	73640.0
2011-11-21 06:00:00	AAPL	Stock	13.2046	13.2104	13.2046	13.2104	8400.0
2011-11-21 07:00:00	AAPL	Stock	13.2143	13.2339	13.1964	13.2214	467404.0
2011-11-21 08:00:00	AAPL	Stock	13.225	13.2854	13.2143	13.2414	3376716.0
2011-11-21 09:00:00	AAPL	Stock	13.2429	13.2743	13.1107	13.1529	72555952.0
2011-11-21 10:00:00	AAPL	Stock	13.1571	13.1675	13.075	13.0811	80052056.0
2011-11-21 11:00:00	AAPL	Stock	13.0764	13.1621	13.0736	13.1235	59094616.0
2011-11-21 12:00:00	AAPL	Stock	13.1236	13.1464	13.0682	13.0968	43432816.0
2011-11-21 13:00:00	AAPL	Stock	13.0964	13.1514	13.0821	13.0911	36337028.0
2011-11-21 14:00:00	AAPL	Stock	13.0946	13.1918	13.0839	13.1554	51961700.0
2011-11-21 15:00:00	AAPL	Stock	13.1557	13.2586	13.1325	13.1789	78526700.0
2011-11-21 16:00:00	AAPL	Stock	13.185	13.2266	13.1181	13.1607	16097088.0
2011-11-21 17:00:00	AAPL	Stock	13.1607	13.2043	13.1429	13.1964	783524.0
2011-11-21 18:00:00	AAPL	Stock	13.1946	13.2	13.1707	13.1789	240548.0
2011-11-21 19:00:00	AAPL	Stock	13.1925	13.2139	13.1839	13.2125	225876.0
2011-11-21 04:00:00	MSFT	Stock	25.1	25.1	25.05	25.05	500.0
2011-11-21 06:00:00	MSFT	Stock	25.17	25.17	25.05	25.05	700.0
2011-11-21 07:00:00	MSFT	Stock	25.04	25.07	24.95	25.06	2275.0
2011-11-21 08:00:00	MSFT	Stock	25.07	25.3	25.0	25.09	49285.0
2011-11-21 09:00:00	MSFT	Stock	25.09	25.25	25.08	25.115	4578771.0
2011-11-21 10:00:00	MSFT	Stock	25.12	25.15	24.96	24.97	10933644.0
2011-11-21 11:00:00	MSFT	Stock	24.97	25.059	24.9	24.956	7135287.0
2011-11-21 12:00:00	MSFT	Stock	24.95	25.03	24.92	24.995	6200911.0
2011-11-21 13:00:00	MSFT	Stock	25.0	25.06	24.98	24.99	5442175.0
2011-11-21 14:00:00	MSFT	Stock	24.99	25.1	24.97	25.035	7764755.0
2011-11-21 15:00:00	MSFT	Stock	25.03	25.22	25.0	25.0	13216209.0
2011-11-21 16:00:00	MSFT	Stock	25.0	25.22	24.92	24.995	3882119.0
2011-11-21 17:00:00	MSFT	Stock	24.95	25.0	24.95	24.96	4976.0
2011-11-21 18:00:00	MSFT	Stock	25.0	25.04	24.9	24.9	18796.0
2011-11-21 19:00:00	MSFT	Stock	24.97	25.05	24.95	25.05	3445.0
2011-11-21 04:00:00	NVDA	Stock	0.34	0.34	0.3388	0.3388	30000.0
2011-11-21 05:00:00	NVDA	Stock	0.3388	0.3388	0.3388	0.3388	10000.0
2011-11-21 07:00:00	NVDA	Stock	0.3375	0.3375	0.3375	0.3375	20000.0
2011-11-21 08:00:00	NVDA	Stock	0.34	0.345	0.335	0.3378	675400.0
2011-11-21 09:00:00	NVDA	Stock	0.3393	0.3438	0.3375	0.3393	60169280.0
2011-11-21 10:00:00	NVDA	Stock	0.3395	0.3428	0.3375	0.339	152092400.0
2011-11-21 11:00:00	NVDA	Stock	0.339	0.3522	0.3385	0.3516	214412160.0
2011-11-21 12:00:00	NVDA	Stock	0.3518	0.3587	0.3515	0.3555	188757440.0
2011-11-21 13:00:00	NVDA	Stock	0.3555	0.3595	0.3545	0.3546	109368880.0
2011-11-21 14:00:00	NVDA	Stock	0.3548	0.3648	0.3538	0.3618	173874800.0
2011-11-21 15:00:00	NVDA	Stock	0.362	0.3692	0.3598	0.366	407411720.0
2011-11-21 16:00:00	NVDA	Stock	0.367	0.3692	0.3544	0.3642	21557800.0
2011-11-21 17:00:00	NVDA	Stock	0.3635	0.3658	0.3635	0.3658	391800.0
2011-11-21 18:00:00	NVDA	Stock	0.3658	0.3668	0.3638	0.3668	782120.0
2011-11-21 19:00:00	NVDA	Stock	0.3638	0.37	0.3638	0.37	626000.0
2011-11-21 05:00:00	AMZN	Stock	9.702	9.7025	9.702	9.7025	6700.0
2011-11-21 07:00:00	AMZN	Stock	9.6915	9.715	9.657	9.657	128640.0
2011-11-21 08:00:00	AMZN	Stock	9.687	9.697	9.615	9.68	624860.0
2011-11-21 09:00:00	AMZN	Stock	9.6785	9.68	9.276	9.3053	53402040.0

> showing 50 of 44,405 rows — these rows as CSV

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