PREVIEW / stock_1hour / 2014-03-20

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-03-20.parquet
  size:    1.0 MB
  rows:    48,864
  symbols: 3,538

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-03-20 06:00:00	AAPL	Stock	18.9114	18.9132	18.9032	18.9132	30800.0
2014-03-20 07:00:00	AAPL	Stock	18.9061	18.965	18.9061	18.965	61600.0
2014-03-20 08:00:00	AAPL	Stock	18.88	18.9643	18.8789	18.9393	283612.0
2014-03-20 09:00:00	AAPL	Stock	18.9464	19.0239	18.8446	18.9107	36207500.0
2014-03-20 10:00:00	AAPL	Stock	18.91	18.9711	18.8721	18.8889	27929272.0
2014-03-20 11:00:00	AAPL	Stock	18.8882	18.9025	18.8339	18.8711	21883120.0
2014-03-20 12:00:00	AAPL	Stock	18.8711	18.9568	18.8614	18.955	13749260.0
2014-03-20 13:00:00	AAPL	Stock	18.955	18.9736	18.8975	18.9129	12097512.0
2014-03-20 14:00:00	AAPL	Stock	18.9107	18.9582	18.8929	18.9036	10652684.0
2014-03-20 15:00:00	AAPL	Stock	18.9	18.9103	18.8482	18.8839	28736512.0
2014-03-20 16:00:00	AAPL	Stock	18.8821	18.9055	18.8786	18.8904	5761700.0
2014-03-20 17:00:00	AAPL	Stock	18.8896	18.8929	18.875	18.885	294532.0
2014-03-20 18:00:00	AAPL	Stock	18.885	18.885	18.875	18.875	106288.0
2014-03-20 19:00:00	AAPL	Stock	18.8804	18.8804	18.8607	18.8607	63224.0
2014-03-20 08:00:00	MSFT	Stock	39.15	39.169	39.08	39.169	720.0
2014-03-20 09:00:00	MSFT	Stock	39.11	39.57	39.11	39.52	4443108.0
2014-03-20 10:00:00	MSFT	Stock	39.52	39.96	39.48	39.92	8419266.0
2014-03-20 11:00:00	MSFT	Stock	39.92	40.17	39.88	40.06	7285188.0
2014-03-20 12:00:00	MSFT	Stock	40.06	40.445	39.97	40.44	6215904.0
2014-03-20 13:00:00	MSFT	Stock	40.43	40.56	40.42	40.51	8256087.0
2014-03-20 14:00:00	MSFT	Stock	40.515	40.649	40.41	40.487	5923027.0
2014-03-20 15:00:00	MSFT	Stock	40.48	40.49	40.12	40.33	12673223.0
2014-03-20 16:00:00	MSFT	Stock	40.33	40.73	39.78	40.44	2074914.0
2014-03-20 17:00:00	MSFT	Stock	40.44	40.44	39.27	40.36	1830503.0
2014-03-20 18:00:00	MSFT	Stock	40.38	40.4	40.36	40.39	7676.0
2014-03-20 19:00:00	MSFT	Stock	40.4	40.4	40.33	40.35	12193.0
2014-03-20 08:00:00	NVDA	Stock	0.464	0.464	0.464	0.464	1892000.0
2014-03-20 09:00:00	NVDA	Stock	0.4638	0.4655	0.4595	0.4643	26417200.0
2014-03-20 10:00:00	NVDA	Stock	0.4645	0.4683	0.4635	0.4656	37426000.0
2014-03-20 11:00:00	NVDA	Stock	0.4658	0.4662	0.4644	0.4646	14407000.0
2014-03-20 12:00:00	NVDA	Stock	0.4645	0.4652	0.4635	0.4652	16030680.0
2014-03-20 13:00:00	NVDA	Stock	0.4652	0.4659	0.464	0.4645	12151600.0
2014-03-20 14:00:00	NVDA	Stock	0.4645	0.4648	0.462	0.463	17408520.0
2014-03-20 15:00:00	NVDA	Stock	0.4629	0.465	0.4615	0.4644	54530240.0
2014-03-20 16:00:00	NVDA	Stock	0.4643	0.465	0.4643	0.4643	8533800.0
2014-03-20 05:00:00	AMZN	Stock	18.652	18.652	18.6445	18.6445	6000.0
2014-03-20 06:00:00	AMZN	Stock	18.6	18.6	18.591	18.6	6040.0
2014-03-20 07:00:00	AMZN	Stock	18.625	18.645	18.625	18.625	12000.0
2014-03-20 08:00:00	AMZN	Stock	18.5505	18.6935	18.524	18.5405	293240.0
2014-03-20 09:00:00	AMZN	Stock	18.535	18.65	18.375	18.411	9435420.0
2014-03-20 10:00:00	AMZN	Stock	18.4168	18.533	18.4015	18.4195	8980780.0
2014-03-20 11:00:00	AMZN	Stock	18.4145	18.449	18.311	18.439	8435600.0
2014-03-20 12:00:00	AMZN	Stock	18.4438	18.463	18.382	18.4055	3879280.0
2014-03-20 13:00:00	AMZN	Stock	18.411	18.452	18.4025	18.4204	2190040.0
2014-03-20 14:00:00	AMZN	Stock	18.4185	18.4737	18.403	18.408	2869340.0
2014-03-20 15:00:00	AMZN	Stock	18.408	18.45	18.3675	18.4485	7477360.0
2014-03-20 16:00:00	AMZN	Stock	18.4485	18.4522	18.4475	18.4507	3272620.0
2014-03-20 18:00:00	AMZN	Stock	18.413	18.4485	18.4105	18.4485	81360.0
2014-03-20 19:00:00	AMZN	Stock	18.4275	18.4275	18.4275	18.4275	3980.0
2014-03-20 05:00:00	META	Stock	68.2	68.2	68.18	68.18	2300.0

> showing 50 of 48,864 rows — these rows as CSV

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