PREVIEW / stock_1hour / 2015-05-14

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-05-14.parquet
  size:    1.1 MB
  rows:    49,367
  symbols: 3,511

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-05-14 04:00:00	AAPL	Stock	29.0	31.63	29.0	31.63	19040.0
2015-05-14 05:00:00	AAPL	Stock	31.605	31.625	31.5625	31.625	3932.0
2015-05-14 06:00:00	AAPL	Stock	31.5875	31.6825	31.5875	31.6825	103448.0
2015-05-14 07:00:00	AAPL	Stock	31.67	31.725	31.65	31.7175	330560.0
2015-05-14 08:00:00	AAPL	Stock	31.715	31.8	31.6525	31.7825	1220848.0
2015-05-14 09:00:00	AAPL	Stock	31.785	31.95	31.775	31.925	33017168.0
2015-05-14 10:00:00	AAPL	Stock	31.925	32.0625	31.875	32.06	36503500.0
2015-05-14 11:00:00	AAPL	Stock	32.0575	32.1125	32.0375	32.0962	20298628.0
2015-05-14 12:00:00	AAPL	Stock	32.0975	32.14	32.0425	32.1275	14718232.0
2015-05-14 13:00:00	AAPL	Stock	32.1275	32.2125	32.1175	32.1708	15042524.0
2015-05-14 14:00:00	AAPL	Stock	32.1725	32.23	32.1275	32.2275	13235192.0
2015-05-14 15:00:00	AAPL	Stock	32.23	32.2375	32.16	32.2375	26471672.0
2015-05-14 16:00:00	AAPL	Stock	32.2375	32.2375	32.155	32.2125	5804864.0
2015-05-14 17:00:00	AAPL	Stock	32.2	32.225	32.1952	32.2175	156796.0
2015-05-14 18:00:00	AAPL	Stock	32.2175	32.2225	32.1975	32.22	49896.0
2015-05-14 19:00:00	AAPL	Stock	32.2225	32.24	32.2125	32.2325	160184.0
2015-05-14 04:00:00	MSFT	Stock	47.83	47.95	47.83	47.95	2000.0
2015-05-14 06:00:00	MSFT	Stock	47.89	47.95	47.89	47.95	4073.0
2015-05-14 07:00:00	MSFT	Stock	47.9	47.94	47.88	47.94	2978.0
2015-05-14 08:00:00	MSFT	Stock	47.94	48.05	47.84	47.97	27141.0
2015-05-14 09:00:00	MSFT	Stock	47.97	48.59	47.97	48.505	4317355.0
2015-05-14 10:00:00	MSFT	Stock	48.505	48.82	48.47	48.615	5913281.0
2015-05-14 11:00:00	MSFT	Stock	48.62	48.693	48.55	48.63	3650891.0
2015-05-14 12:00:00	MSFT	Stock	48.63	48.725	48.59	48.63	2360192.0
2015-05-14 13:00:00	MSFT	Stock	48.631	48.8	48.615	48.715	3087569.0
2015-05-14 14:00:00	MSFT	Stock	48.715	48.74	48.6	48.65	2254537.0
2015-05-14 15:00:00	MSFT	Stock	48.655	48.76	48.605	48.72	5285568.0
2015-05-14 16:00:00	MSFT	Stock	48.72	48.72	47.62	48.63	3720680.0
2015-05-14 17:00:00	MSFT	Stock	48.64	48.77	48.64	48.76	8731.0
2015-05-14 18:00:00	MSFT	Stock	48.731	48.75	48.7	48.75	2800.0
2015-05-14 19:00:00	MSFT	Stock	48.701	48.75	48.701	48.75	1174.0
2015-05-14 09:00:00	NVDA	Stock	0.526	0.5312	0.524	0.53	30455480.0
2015-05-14 10:00:00	NVDA	Stock	0.5302	0.535	0.5298	0.5302	45769880.0
2015-05-14 11:00:00	NVDA	Stock	0.5302	0.5319	0.5298	0.5302	22814080.0
2015-05-14 12:00:00	NVDA	Stock	0.5302	0.5337	0.53	0.5327	37327960.0
2015-05-14 13:00:00	NVDA	Stock	0.533	0.5332	0.531	0.532	21642320.0
2015-05-14 14:00:00	NVDA	Stock	0.5322	0.5334	0.53	0.531	44667400.0
2015-05-14 15:00:00	NVDA	Stock	0.5312	0.5345	0.5305	0.5322	67376000.0
2015-05-14 16:00:00	NVDA	Stock	0.5322	0.5332	0.5322	0.5332	1883160.0
2015-05-14 08:00:00	AMZN	Stock	21.475	21.52	21.455	21.485	68720.0
2015-05-14 09:00:00	AMZN	Stock	21.4945	21.4945	21.3505	21.435	5255760.0
2015-05-14 10:00:00	AMZN	Stock	21.435	21.5385	21.415	21.502	5099100.0
2015-05-14 11:00:00	AMZN	Stock	21.5048	21.605	21.495	21.5755	4004780.0
2015-05-14 12:00:00	AMZN	Stock	21.5842	21.618	21.563	21.6055	2857080.0
2015-05-14 13:00:00	AMZN	Stock	21.617	21.633	21.5615	21.5825	2520900.0
2015-05-14 14:00:00	AMZN	Stock	21.5865	21.65	21.5755	21.619	3718200.0
2015-05-14 15:00:00	AMZN	Stock	21.615	21.6325	21.5402	21.614	6021700.0
2015-05-14 16:00:00	AMZN	Stock	21.614	21.614	21.613	21.613	2170660.0
2015-05-14 17:00:00	AMZN	Stock	21.6	21.6	21.5555	21.5555	33000.0
2015-05-14 08:00:00	GOOGL	Stock	27.1475	27.2	27.1	27.15	30000.0

> showing 50 of 49,367 rows — these rows as CSV

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