PREVIEW / stock_1hour / 2013-01-16

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-01-16.parquet
  size:    943 KB
  rows:    44,535
  symbols: 3,463

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
2013-01-16 04:00:00	AAPL	Stock	17.4989	17.4989	17.4125	17.4289	33600.0
2013-01-16 05:00:00	AAPL	Stock	17.4336	17.4371	17.3932	17.3932	110964.0
2013-01-16 06:00:00	AAPL	Stock	17.4282	17.4929	17.4025	17.4439	409108.0
2013-01-16 07:00:00	AAPL	Stock	17.4432	17.6375	17.4286	17.6	3113908.0
2013-01-16 08:00:00	AAPL	Stock	17.6043	17.6786	17.5	17.61	9802464.0
2013-01-16 09:00:00	AAPL	Stock	17.61	17.8507	17.5714	17.8168	160096356.0
2013-01-16 10:00:00	AAPL	Stock	17.8168	18.0154	17.7888	17.8904	147125776.0
2013-01-16 11:00:00	AAPL	Stock	17.8886	18.0179	17.8879	17.9671	64244880.0
2013-01-16 12:00:00	AAPL	Stock	17.9696	18.0268	17.9525	17.9771	38195444.0
2013-01-16 13:00:00	AAPL	Stock	17.9736	18.1229	17.97	18.1104	60874492.0
2013-01-16 14:00:00	AAPL	Stock	18.1102	18.1904	18.0607	18.1831	71843660.0
2013-01-16 15:00:00	AAPL	Stock	18.1796	18.1943	18.0579	18.0743	94737944.0
2013-01-16 16:00:00	AAPL	Stock	18.075	18.1212	17.9394	18.0925	18701116.0
2013-01-16 17:00:00	AAPL	Stock	18.0857	18.0929	18.0536	18.0929	974372.0
2013-01-16 18:00:00	AAPL	Stock	18.0843	18.0843	18.0643	18.0686	293244.0
2013-01-16 19:00:00	AAPL	Stock	18.0739	18.1054	18.0714	18.1054	512680.0
2013-01-16 07:00:00	MSFT	Stock	27.18	27.18	27.16	27.16	8050.0
2013-01-16 08:00:00	MSFT	Stock	27.15	27.18	27.12	27.18	39160.0
2013-01-16 09:00:00	MSFT	Stock	27.17	27.25	27.08	27.18	4936533.0
2013-01-16 10:00:00	MSFT	Stock	27.175	27.23	27.09	27.139	6947950.0
2013-01-16 11:00:00	MSFT	Stock	27.13	27.21	27.12	27.14	4155925.0
2013-01-16 12:00:00	MSFT	Stock	27.15	27.155	27.01	27.08	3984170.0
2013-01-16 13:00:00	MSFT	Stock	27.07	27.11	27.02	27.095	3541545.0
2013-01-16 14:00:00	MSFT	Stock	27.09	27.17	27.07	27.15	3358434.0
2013-01-16 15:00:00	MSFT	Stock	27.145	27.15	27.01	27.02	9386622.0
2013-01-16 16:00:00	MSFT	Stock	27.01	27.21	27.0	27.03	3913448.0
2013-01-16 17:00:00	MSFT	Stock	27.03	27.03	27.02	27.02	2775.0
2013-01-16 18:00:00	MSFT	Stock	27.03	27.03	27.02	27.03	4592.0
2013-01-16 19:00:00	MSFT	Stock	27.02	27.02	27.0	27.0	9871.0
2013-01-16 07:00:00	NVDA	Stock	0.2998	0.2998	0.2998	0.2998	40000.0
2013-01-16 09:00:00	NVDA	Stock	0.299	0.304	0.299	0.3039	46362440.0
2013-01-16 10:00:00	NVDA	Stock	0.3039	0.3048	0.3022	0.3038	69792480.0
2013-01-16 11:00:00	NVDA	Stock	0.3038	0.3042	0.302	0.3022	30423080.0
2013-01-16 12:00:00	NVDA	Stock	0.3022	0.303	0.3008	0.3018	49304600.0
2013-01-16 13:00:00	NVDA	Stock	0.3018	0.3032	0.3015	0.3024	36137760.0
2013-01-16 14:00:00	NVDA	Stock	0.3025	0.303	0.301	0.3025	31073840.0
2013-01-16 15:00:00	NVDA	Stock	0.3026	0.303	0.3018	0.3022	55557440.0
2013-01-16 16:00:00	NVDA	Stock	0.3022	0.3023	0.2995	0.3022	3184240.0
2013-01-16 17:00:00	NVDA	Stock	0.3025	0.3025	0.3025	0.3025	34000.0
2013-01-16 19:00:00	NVDA	Stock	0.3025	0.3025	0.3025	0.3025	6000.0
2013-01-16 07:00:00	AMZN	Stock	13.615	13.615	13.595	13.615	46000.0
2013-01-16 08:00:00	AMZN	Stock	13.6465	13.6465	13.547	13.551	64880.0
2013-01-16 09:00:00	AMZN	Stock	13.551	13.562	13.475	13.497	4936420.0
2013-01-16 10:00:00	AMZN	Stock	13.497	13.5325	13.478	13.4935	7559720.0
2013-01-16 11:00:00	AMZN	Stock	13.4938	13.5195	13.418	13.433	6504340.0
2013-01-16 12:00:00	AMZN	Stock	13.4368	13.446	13.3915	13.4215	4729500.0
2013-01-16 13:00:00	AMZN	Stock	13.424	13.458	13.408	13.4555	3654660.0
2013-01-16 14:00:00	AMZN	Stock	13.4515	13.49	13.441	13.463	2520340.0
2013-01-16 15:00:00	AMZN	Stock	13.458	13.461	13.405	13.4415	7715020.0
2013-01-16 16:00:00	AMZN	Stock	13.4465	13.4905	13.3975	13.465	2963620.0

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

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