PREVIEW / stock_1hour / 2010-06-25

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-06-25.parquet
  size:    969 KB
  rows:    45,010
  symbols: 3,446

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
2010-06-25 05:00:00	AAPL	Stock	9.6111	9.6111	9.5896	9.5896	8400.0
2010-06-25 06:00:00	AAPL	Stock	9.5825	9.6004	9.5711	9.6004	49588.0
2010-06-25 07:00:00	AAPL	Stock	9.635	9.6711	9.6168	9.6521	358456.0
2010-06-25 08:00:00	AAPL	Stock	9.6625	9.6629	9.6004	9.6468	3603852.0
2010-06-25 09:00:00	AAPL	Stock	9.6479	9.6589	9.5321	9.5975	93551584.0
2010-06-25 10:00:00	AAPL	Stock	9.6	9.6336	9.5011	9.5093	115207820.0
2010-06-25 11:00:00	AAPL	Stock	9.5125	9.5571	9.4932	9.5357	58937508.0
2010-06-25 12:00:00	AAPL	Stock	9.5359	9.5754	9.5239	9.5389	43148252.0
2010-06-25 13:00:00	AAPL	Stock	9.54	9.6032	9.5346	9.5607	57492652.0
2010-06-25 14:00:00	AAPL	Stock	9.5605	9.5894	9.5375	9.5536	42686728.0
2010-06-25 15:00:00	AAPL	Stock	9.5539	9.5757	9.5	9.5004	87312736.0
2010-06-25 16:00:00	AAPL	Stock	9.5	9.5587	9.4825	9.5014	37911048.0
2010-06-25 17:00:00	AAPL	Stock	9.5175	9.5571	9.4946	9.5168	1819972.0
2010-06-25 18:00:00	AAPL	Stock	9.5161	9.525	9.4989	9.5214	388332.0
2010-06-25 19:00:00	AAPL	Stock	9.5214	9.5221	9.5154	9.5196	274176.0
2010-06-25 05:00:00	MSFT	Stock	24.86	24.86	24.86	24.86	1000.0
2010-06-25 06:00:00	MSFT	Stock	24.92	24.93	24.92	24.93	1118.0
2010-06-25 07:00:00	MSFT	Stock	25.0	25.18	25.0	25.16	39265.0
2010-06-25 08:00:00	MSFT	Stock	25.16	25.17	25.05	25.07	74758.0
2010-06-25 09:00:00	MSFT	Stock	25.08	25.14	24.74	24.76	8857651.0
2010-06-25 10:00:00	MSFT	Stock	24.75	25.1	24.67	24.7	11387614.0
2010-06-25 11:00:00	MSFT	Stock	24.7	24.92	24.695	24.81	6941941.0
2010-06-25 12:00:00	MSFT	Stock	24.81	24.89	24.72	24.745	6529088.0
2010-06-25 13:00:00	MSFT	Stock	24.745	25.09	24.73	24.995	9158352.0
2010-06-25 14:00:00	MSFT	Stock	24.995	25.0	24.68	24.73	9833803.0
2010-06-25 15:00:00	MSFT	Stock	24.73	24.8	24.37	24.38	23759298.0
2010-06-25 16:00:00	MSFT	Stock	24.39	24.861	24.31	24.39	61190601.0
2010-06-25 17:00:00	MSFT	Stock	24.43	24.783	24.365	24.42	12971297.0
2010-06-25 18:00:00	MSFT	Stock	24.42	24.53	24.39	24.41	622367.0
2010-06-25 19:00:00	MSFT	Stock	24.42	24.42	24.41	24.41	32620.0
2010-06-25 08:00:00	NVDA	Stock	0.2792	0.28	0.2783	0.28	546800.0
2010-06-25 09:00:00	NVDA	Stock	0.28	0.28	0.273	0.275	64007760.0
2010-06-25 10:00:00	NVDA	Stock	0.2752	0.2775	0.2725	0.2728	77554000.0
2010-06-25 11:00:00	NVDA	Stock	0.2728	0.276	0.2725	0.2755	52519440.0
2010-06-25 12:00:00	NVDA	Stock	0.2752	0.2772	0.275	0.2763	45659880.0
2010-06-25 13:00:00	NVDA	Stock	0.2763	0.2778	0.2755	0.277	64710400.0
2010-06-25 14:00:00	NVDA	Stock	0.2768	0.2772	0.2755	0.2763	67617960.0
2010-06-25 15:00:00	NVDA	Stock	0.2763	0.2783	0.275	0.277	100424680.0
2010-06-25 16:00:00	NVDA	Stock	0.277	0.2785	0.2749	0.2769	28385080.0
2010-06-25 17:00:00	NVDA	Stock	0.2771	0.2771	0.2767	0.2767	3677600.0
2010-06-25 18:00:00	NVDA	Stock	0.2765	0.2765	0.275	0.275	243600.0
2010-06-25 08:00:00	AMZN	Stock	5.9375	5.9375	5.9	5.912	19140.0
2010-06-25 09:00:00	AMZN	Stock	5.936	5.9505	5.8813	5.946	11804360.0
2010-06-25 10:00:00	AMZN	Stock	5.946	6.0	5.937	5.945	22762860.0
2010-06-25 11:00:00	AMZN	Stock	5.9465	6.0465	5.945	6.0135	16558780.0
2010-06-25 12:00:00	AMZN	Stock	6.0138	6.025	5.9861	5.9915	8279300.0
2010-06-25 13:00:00	AMZN	Stock	5.992	6.088	5.9892	6.077	13638840.0
2010-06-25 14:00:00	AMZN	Stock	6.077	6.0835	6.0425	6.053	8084900.0
2010-06-25 15:00:00	AMZN	Stock	6.0525	6.0575	6.0075	6.0565	19287960.0
2010-06-25 16:00:00	AMZN	Stock	6.0495	6.0601	6.0034	6.0544	4831440.0

> showing 50 of 45,010 rows — these rows as CSV

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