PREVIEW / stock_1hour / 2015-08-11

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-08-11.parquet
  size:    1.0 MB
  rows:    48,640
  symbols: 3,476

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
2015-08-11 04:00:00	AAPL	Stock	29.83	29.86	29.75	29.75	81960.0
2015-08-11 05:00:00	AAPL	Stock	29.72	29.79	29.6275	29.6875	49400.0
2015-08-11 06:00:00	AAPL	Stock	29.6875	29.7425	29.675	29.6875	119204.0
2015-08-11 07:00:00	AAPL	Stock	29.6875	29.7425	29.475	29.5125	677868.0
2015-08-11 08:00:00	AAPL	Stock	29.505	29.7425	29.43	29.47	2050292.0
2015-08-11 09:00:00	AAPL	Stock	29.4575	29.545	29.225	29.3225	40956556.0
2015-08-11 10:00:00	AAPL	Stock	29.3178	29.32	29.0612	29.0875	49058780.0
2015-08-11 11:00:00	AAPL	Stock	29.0888	29.125	28.85	28.875	39160996.0
2015-08-11 12:00:00	AAPL	Stock	28.8725	28.89	28.7025	28.715	38973664.0
2015-08-11 13:00:00	AAPL	Stock	28.7125	28.7225	28.4275	28.47	60751140.0
2015-08-11 14:00:00	AAPL	Stock	28.475	28.53	28.3325	28.51	55567152.0
2015-08-11 15:00:00	AAPL	Stock	28.515	28.5925	28.3725	28.3875	67445956.0
2015-08-11 16:00:00	AAPL	Stock	28.3725	29.4045	28.3525	28.4125	8775804.0
2015-08-11 17:00:00	AAPL	Stock	28.4118	28.46	28.41	28.43	194096.0
2015-08-11 18:00:00	AAPL	Stock	28.43	28.46	28.4125	28.455	298252.0
2015-08-11 19:00:00	AAPL	Stock	28.4575	28.475	28.4375	28.465	230680.0
2015-08-11 05:00:00	MSFT	Stock	47.0	47.0	47.0	47.0	2450.0
2015-08-11 07:00:00	MSFT	Stock	46.95	47.0	46.95	46.95	2200.0
2015-08-11 08:00:00	MSFT	Stock	47.0	47.0	46.8	46.8	14897.0
2015-08-11 09:00:00	MSFT	Stock	46.77	46.94	46.51	46.76	3111333.0
2015-08-11 10:00:00	MSFT	Stock	46.76	46.79	46.48	46.49	3072719.0
2015-08-11 11:00:00	MSFT	Stock	46.499	46.53	46.171	46.23	2975792.0
2015-08-11 12:00:00	MSFT	Stock	46.23	46.35	46.18	46.2	2179799.0
2015-08-11 13:00:00	MSFT	Stock	46.19	46.21	45.97	46.0	2657597.0
2015-08-11 14:00:00	MSFT	Stock	46.01	46.275	45.9	46.2	2695191.0
2015-08-11 15:00:00	MSFT	Stock	46.195	46.49	46.12	46.42	7005012.0
2015-08-11 16:00:00	MSFT	Stock	46.41	46.646	46.39	46.5	3511263.0
2015-08-11 17:00:00	MSFT	Stock	46.5	46.5	46.45	46.45	3987.0
2015-08-11 19:00:00	MSFT	Stock	46.41	46.443	46.36	46.44	2864.0
2015-08-11 08:00:00	NVDA	Stock	0.5903	0.5903	0.587	0.5875	613240.0
2015-08-11 09:00:00	NVDA	Stock	0.588	0.592	0.5858	0.5895	52560080.0
2015-08-11 10:00:00	NVDA	Stock	0.5895	0.5959	0.5883	0.5952	59366960.0
2015-08-11 11:00:00	NVDA	Stock	0.595	0.5952	0.5908	0.5935	65608240.0
2015-08-11 12:00:00	NVDA	Stock	0.5935	0.5973	0.5923	0.595	40978080.0
2015-08-11 13:00:00	NVDA	Stock	0.5948	0.5963	0.5923	0.5925	62723400.0
2015-08-11 14:00:00	NVDA	Stock	0.5928	0.593	0.5875	0.5898	47785080.0
2015-08-11 15:00:00	NVDA	Stock	0.5898	0.5928	0.5895	0.5915	78500640.0
2015-08-11 16:00:00	NVDA	Stock	0.5915	0.5928	0.5915	0.5928	15221480.0
2015-08-11 17:00:00	NVDA	Stock	0.5925	0.5938	0.5918	0.5918	40000.0
2015-08-11 19:00:00	NVDA	Stock	0.5933	0.5933	0.5933	0.5933	40000.0
2015-08-11 04:00:00	AMZN	Stock	26.175	26.175	26.021	26.047	8000.0
2015-08-11 05:00:00	AMZN	Stock	26.15	26.15	26.075	26.095	10420.0
2015-08-11 06:00:00	AMZN	Stock	26.081	26.081	26.081	26.081	4000.0
2015-08-11 07:00:00	AMZN	Stock	26.136	26.136	26.125	26.125	8000.0
2015-08-11 08:00:00	AMZN	Stock	26.125	26.125	26.075	26.075	56580.0
2015-08-11 09:00:00	AMZN	Stock	26.056	26.449	26.0075	26.369	9049700.0
2015-08-11 10:00:00	AMZN	Stock	26.359	26.443	26.261	26.3185	6622800.0
2015-08-11 11:00:00	AMZN	Stock	26.305	26.347	26.1231	26.154	4469200.0
2015-08-11 12:00:00	AMZN	Stock	26.164	26.245	26.14	26.1505	2375700.0
2015-08-11 13:00:00	AMZN	Stock	26.1525	26.225	26.1005	26.1365	4425400.0

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

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