PREVIEW / stock_1hour / 2015-06-11

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-06-11.parquet
  size:    1.0 MB
  rows:    49,153
  symbols: 3,519

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-06-11 04:00:00	AAPL	Stock	32.2825	32.2875	32.2775	32.2875	5676.0
2015-06-11 05:00:00	AAPL	Stock	32.25	32.2875	32.25	32.275	5264.0
2015-06-11 06:00:00	AAPL	Stock	32.285	32.3025	32.2775	32.3	18000.0
2015-06-11 07:00:00	AAPL	Stock	32.3025	32.3275	32.28	32.3275	59232.0
2015-06-11 08:00:00	AAPL	Stock	32.3225	32.325	32.2775	32.3	377272.0
2015-06-11 09:00:00	AAPL	Stock	32.2958	32.545	32.275	32.5225	24592200.0
2015-06-11 10:00:00	AAPL	Stock	32.515	32.5225	32.2875	32.32	24308896.0
2015-06-11 11:00:00	AAPL	Stock	32.32	32.41	32.305	32.325	12813376.0
2015-06-11 12:00:00	AAPL	Stock	32.325	32.365	32.1188	32.3325	15281296.0
2015-06-11 13:00:00	AAPL	Stock	32.3325	32.335	32.265	32.3125	8166204.0
2015-06-11 14:00:00	AAPL	Stock	32.3108	32.33	32.1675	32.175	11314740.0
2015-06-11 15:00:00	AAPL	Stock	32.175	32.2225	32.1475	32.15	19388988.0
2015-06-11 16:00:00	AAPL	Stock	32.1475	32.2125	32.1475	32.1775	15945748.0
2015-06-11 17:00:00	AAPL	Stock	32.17	32.1825	32.1475	32.1625	54216.0
2015-06-11 18:00:00	AAPL	Stock	32.1625	32.175	32.1475	32.15	74724.0
2015-06-11 19:00:00	AAPL	Stock	32.15	32.1725	32.1475	32.17	44412.0
2015-06-11 04:00:00	MSFT	Stock	46.65	46.65	46.65	46.65	100.0
2015-06-11 07:00:00	MSFT	Stock	46.65	46.65	46.65	46.65	2300.0
2015-06-11 08:00:00	MSFT	Stock	46.65	46.7	46.563	46.65	26562.0
2015-06-11 09:00:00	MSFT	Stock	46.66	46.92	46.6	46.75	2655515.0
2015-06-11 10:00:00	MSFT	Stock	46.755	46.81	46.32	46.34	4351534.0
2015-06-11 11:00:00	MSFT	Stock	46.34	46.46	46.27	46.329	2781462.0
2015-06-11 12:00:00	MSFT	Stock	46.325	46.365	46.17	46.235	1825115.0
2015-06-11 13:00:00	MSFT	Stock	46.23	46.37	46.13	46.32	2123245.0
2015-06-11 14:00:00	MSFT	Stock	46.315	46.475	46.3	46.43	2184758.0
2015-06-11 15:00:00	MSFT	Stock	46.43	46.51	46.39	46.44	5775491.0
2015-06-11 16:00:00	MSFT	Stock	46.44	46.51	46.44	46.51	4422591.0
2015-06-11 17:00:00	MSFT	Stock	46.46	46.46	46.46	46.46	945.0
2015-06-11 18:00:00	MSFT	Stock	46.223	46.44	46.223	46.44	56360.0
2015-06-11 19:00:00	MSFT	Stock	46.45	46.45	46.45	46.45	1300.0
2015-06-11 09:00:00	NVDA	Stock	0.5372	0.5438	0.5367	0.5438	46179920.0
2015-06-11 10:00:00	NVDA	Stock	0.5438	0.5462	0.5428	0.544	40775600.0
2015-06-11 11:00:00	NVDA	Stock	0.5438	0.5452	0.5425	0.545	25028360.0
2015-06-11 12:00:00	NVDA	Stock	0.545	0.5455	0.5422	0.5435	37743520.0
2015-06-11 13:00:00	NVDA	Stock	0.5432	0.544	0.5425	0.543	23540360.0
2015-06-11 14:00:00	NVDA	Stock	0.5428	0.544	0.5422	0.543	33831760.0
2015-06-11 15:00:00	NVDA	Stock	0.543	0.5438	0.5415	0.5425	58122240.0
2015-06-11 16:00:00	NVDA	Stock	0.5425	0.5425	0.5425	0.5425	9136120.0
2015-06-11 18:00:00	NVDA	Stock	0.5428	0.5428	0.5428	0.5428	12000.0
2015-06-11 08:00:00	AMZN	Stock	21.575	21.6	21.575	21.6	12000.0
2015-06-11 09:00:00	AMZN	Stock	21.576	21.8285	21.5735	21.7538	10266880.0
2015-06-11 10:00:00	AMZN	Stock	21.7495	21.8525	21.692	21.8182	11219000.0
2015-06-11 11:00:00	AMZN	Stock	21.8115	21.9445	21.7825	21.795	8272280.0
2015-06-11 12:00:00	AMZN	Stock	21.7935	21.8085	21.731	21.75	3086340.0
2015-06-11 13:00:00	AMZN	Stock	21.7542	21.7735	21.705	21.739	3096240.0
2015-06-11 14:00:00	AMZN	Stock	21.7415	21.763	21.7075	21.7185	2850380.0
2015-06-11 15:00:00	AMZN	Stock	21.717	21.7234	21.6115	21.6295	8478420.0
2015-06-11 16:00:00	AMZN	Stock	21.6365	21.6705	21.6255	21.6705	128920.0
2015-06-11 09:00:00	GOOGL	Stock	27.655	27.7415	27.535	27.7025	3324520.0
2015-06-11 10:00:00	GOOGL	Stock	27.691	27.698	27.4585	27.48	2719680.0

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

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