PREVIEW / stock_1hour / 2013-12-18

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-12-18.parquet
  size:    1.0 MB
  rows:    48,144
  symbols: 3,539

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-12-18 04:00:00	AAPL	Stock	19.8554	19.8554	19.75	19.7504	144676.0
2013-12-18 05:00:00	AAPL	Stock	19.7604	19.7732	19.7575	19.7621	22400.0
2013-12-18 06:00:00	AAPL	Stock	19.7618	19.7675	19.5136	19.5604	704004.0
2013-12-18 07:00:00	AAPL	Stock	19.5536	19.6186	19.4464	19.5754	2253104.0
2013-12-18 08:00:00	AAPL	Stock	19.5754	19.6304	19.4879	19.5882	5567492.0
2013-12-18 09:00:00	AAPL	Stock	19.5893	19.7625	19.4111	19.4643	93231656.0
2013-12-18 10:00:00	AAPL	Stock	19.4668	19.5814	19.4384	19.4714	67197928.0
2013-12-18 11:00:00	AAPL	Stock	19.4711	19.5143	19.3571	19.4093	43424108.0
2013-12-18 12:00:00	AAPL	Stock	19.4039	19.4286	19.3325	19.3568	40401956.0
2013-12-18 13:00:00	AAPL	Stock	19.3554	19.3586	19.2429	19.3146	41315400.0
2013-12-18 14:00:00	AAPL	Stock	19.3146	19.5968	19.2429	19.5182	87695496.0
2013-12-18 15:00:00	AAPL	Stock	19.5231	19.6946	19.5	19.6696	72154964.0
2013-12-18 16:00:00	AAPL	Stock	19.6704	19.6786	19.4911	19.6646	16456552.0
2013-12-18 17:00:00	AAPL	Stock	19.6643	19.6704	19.6518	19.6696	367556.0
2013-12-18 18:00:00	AAPL	Stock	19.6643	19.6729	19.6554	19.6696	340732.0
2013-12-18 19:00:00	AAPL	Stock	19.6629	19.6714	19.6571	19.6571	214984.0
2013-12-18 07:00:00	MSFT	Stock	36.52	36.6	36.45	36.6	6900.0
2013-12-18 08:00:00	MSFT	Stock	36.52	36.52	36.32	36.38	44390.0
2013-12-18 09:00:00	MSFT	Stock	36.36	36.39	36.17	36.18	5459562.0
2013-12-18 10:00:00	MSFT	Stock	36.175	36.25	35.94	36.027	8976737.0
2013-12-18 11:00:00	MSFT	Stock	36.025	36.06	35.91	35.96	4070112.0
2013-12-18 12:00:00	MSFT	Stock	35.966	35.99	35.68	35.85	4986163.0
2013-12-18 13:00:00	MSFT	Stock	35.85	35.95	35.675	35.92	4936668.0
2013-12-18 14:00:00	MSFT	Stock	35.9	36.396	35.53	36.2	10037410.0
2013-12-18 15:00:00	MSFT	Stock	36.21	36.6	36.14	36.57	11865651.0
2013-12-18 16:00:00	MSFT	Stock	36.57	36.6	36.068	36.175	8290142.0
2013-12-18 17:00:00	MSFT	Stock	36.53	36.64	36.51	36.64	13794.0
2013-12-18 18:00:00	MSFT	Stock	36.64	36.64	36.58	36.58	30200.0
2013-12-18 19:00:00	MSFT	Stock	36.55	36.55	36.55	36.55	473.0
2013-12-18 09:00:00	NVDA	Stock	0.3778	0.381	0.3775	0.381	20898200.0
2013-12-18 10:00:00	NVDA	Stock	0.3808	0.3825	0.3796	0.3804	69543000.0
2013-12-18 11:00:00	NVDA	Stock	0.3805	0.3811	0.3788	0.3798	26493400.0
2013-12-18 12:00:00	NVDA	Stock	0.3796	0.3801	0.3785	0.3785	24261040.0
2013-12-18 13:00:00	NVDA	Stock	0.3784	0.379	0.3763	0.3769	26259520.0
2013-12-18 14:00:00	NVDA	Stock	0.3768	0.382	0.3738	0.382	39515960.0
2013-12-18 15:00:00	NVDA	Stock	0.3818	0.3838	0.3813	0.3828	91424120.0
2013-12-18 16:00:00	NVDA	Stock	0.383	0.384	0.3783	0.383	27419480.0
2013-12-18 05:00:00	AMZN	Stock	19.4455	19.4455	19.4455	19.4455	2000.0
2013-12-18 06:00:00	AMZN	Stock	19.4745	19.495	19.4745	19.495	4000.0
2013-12-18 07:00:00	AMZN	Stock	19.475	19.519	19.475	19.518	54000.0
2013-12-18 08:00:00	AMZN	Stock	19.4	19.57	19.4	19.51	255780.0
2013-12-18 09:00:00	AMZN	Stock	19.5095	19.6365	19.4175	19.5072	9156360.0
2013-12-18 10:00:00	AMZN	Stock	19.5195	19.5665	19.4575	19.497	7155880.0
2013-12-18 11:00:00	AMZN	Stock	19.4945	19.515	19.2755	19.3	6067760.0
2013-12-18 12:00:00	AMZN	Stock	19.3025	19.3835	19.225	19.244	4309040.0
2013-12-18 13:00:00	AMZN	Stock	19.2415	19.34	19.175	19.3195	4307120.0
2013-12-18 14:00:00	AMZN	Stock	19.284	19.5995	19.155	19.554	10895960.0
2013-12-18 15:00:00	AMZN	Stock	19.5628	19.815	19.5245	19.794	16592940.0
2013-12-18 16:00:00	AMZN	Stock	19.798	19.825	19.57	19.77	3809960.0
2013-12-18 17:00:00	AMZN	Stock	19.7785	19.798	19.7755	19.7755	83100.0

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

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