PREVIEW / stock_1hour / 2010-09-28

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-09-28.parquet
  size:    912 KB
  rows:    44,338
  symbols: 3,480

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-09-28 05:00:00	AAPL	Stock	10.4196	10.4196	10.4196	10.4196	14000.0
2010-09-28 06:00:00	AAPL	Stock	10.4393	10.4393	10.4211	10.4211	16100.0
2010-09-28 07:00:00	AAPL	Stock	10.4286	10.4393	10.3939	10.4018	188020.0
2010-09-28 08:00:00	AAPL	Stock	10.4121	10.4375	10.4054	10.4268	2779196.0
2010-09-28 09:00:00	AAPL	Stock	10.425	10.4282	9.8214	10.1796	298901652.0
2010-09-28 10:00:00	AAPL	Stock	10.1782	10.3157	10.0875	10.3154	220175508.0
2010-09-28 11:00:00	AAPL	Stock	10.3139	10.3589	10.2618	10.2932	135774800.0
2010-09-28 12:00:00	AAPL	Stock	10.2929	10.3032	10.0811	10.2857	129389148.0
2010-09-28 13:00:00	AAPL	Stock	10.2844	10.3146	10.2557	10.3125	58016364.0
2010-09-28 14:00:00	AAPL	Stock	10.3121	10.3143	10.2418	10.2582	71324120.0
2010-09-28 15:00:00	AAPL	Stock	10.2582	10.3018	10.2339	10.2446	96266828.0
2010-09-28 16:00:00	AAPL	Stock	10.2446	10.2952	10.1635	10.2539	12841388.0
2010-09-28 17:00:00	AAPL	Stock	10.2536	10.2661	10.2471	10.2632	536200.0
2010-09-28 18:00:00	AAPL	Stock	10.2593	10.2679	10.245	10.2625	423528.0
2010-09-28 19:00:00	AAPL	Stock	10.2621	10.2625	10.2554	10.2607	403872.0
2010-09-28 07:00:00	MSFT	Stock	24.75	24.75	24.75	24.75	900.0
2010-09-28 08:00:00	MSFT	Stock	24.77	24.84	24.74	24.78	12951.0
2010-09-28 09:00:00	MSFT	Stock	24.78	24.9	24.53	24.53	6556504.0
2010-09-28 10:00:00	MSFT	Stock	24.53	24.57	24.35	24.54	11038128.0
2010-09-28 11:00:00	MSFT	Stock	24.54	24.69	24.52	24.63	6560445.0
2010-09-28 12:00:00	MSFT	Stock	24.637	24.69	24.58	24.63	4836885.0
2010-09-28 13:00:00	MSFT	Stock	24.625	24.77	24.61	24.76	6713528.0
2010-09-28 14:00:00	MSFT	Stock	24.755	24.76	24.52	24.54	5203832.0
2010-09-28 15:00:00	MSFT	Stock	24.545	24.75	24.51	24.68	10724959.0
2010-09-28 16:00:00	MSFT	Stock	24.68	24.7	24.53	24.68	2648007.0
2010-09-28 17:00:00	MSFT	Stock	24.67	24.72	24.66	24.72	948.0
2010-09-28 18:00:00	MSFT	Stock	24.68	24.71	24.63	24.63	28240.0
2010-09-28 19:00:00	MSFT	Stock	24.68	24.68	24.68	24.68	100.0
2010-09-28 08:00:00	NVDA	Stock	0.298	0.3012	0.298	0.3008	47200.0
2010-09-28 09:00:00	NVDA	Stock	0.3008	0.3035	0.2962	0.298	91210280.0
2010-09-28 10:00:00	NVDA	Stock	0.2982	0.2986	0.294	0.2967	228303520.0
2010-09-28 11:00:00	NVDA	Stock	0.2966	0.299	0.2952	0.2968	83174120.0
2010-09-28 12:00:00	NVDA	Stock	0.297	0.2988	0.2948	0.2986	86154520.0
2010-09-28 13:00:00	NVDA	Stock	0.2985	0.3005	0.297	0.3005	41930920.0
2010-09-28 14:00:00	NVDA	Stock	0.3002	0.3008	0.296	0.2974	73437080.0
2010-09-28 15:00:00	NVDA	Stock	0.2975	0.3	0.2968	0.2995	99347080.0
2010-09-28 16:00:00	NVDA	Stock	0.2995	0.2998	0.2958	0.2977	18013920.0
2010-09-28 17:00:00	NVDA	Stock	0.298	0.298	0.298	0.298	40000.0
2010-09-28 18:00:00	NVDA	Stock	0.298	0.2988	0.298	0.2988	41600.0
2010-09-28 19:00:00	NVDA	Stock	0.2988	0.2995	0.2988	0.2995	168160.0
2010-09-28 08:00:00	AMZN	Stock	7.994	8.0495	7.953	7.975	395760.0
2010-09-28 09:00:00	AMZN	Stock	7.971	7.993	7.7445	7.8655	34351840.0
2010-09-28 10:00:00	AMZN	Stock	7.8625	8.0	7.8055	7.998	36052100.0
2010-09-28 11:00:00	AMZN	Stock	7.9985	8.029	7.9555	7.963	19271380.0
2010-09-28 12:00:00	AMZN	Stock	7.9625	7.992	7.951	7.985	9790440.0
2010-09-28 13:00:00	AMZN	Stock	7.984	8.0385	7.951	8.0375	13706000.0
2010-09-28 14:00:00	AMZN	Stock	8.0375	8.044	7.9215	7.9586	22783100.0
2010-09-28 15:00:00	AMZN	Stock	7.9581	8.0055	7.9355	7.9835	27008500.0
2010-09-28 16:00:00	AMZN	Stock	7.985	8.015	7.9378	7.9895	4658880.0
2010-09-28 17:00:00	AMZN	Stock	8.0095	8.0095	8.0	8.0	6000.0

> showing 50 of 44,338 rows — these rows as CSV

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