PREVIEW / stock_1hour / 2011-02-15

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-02-15.parquet
  size:    949 KB
  rows:    44,798
  symbols: 3,550

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
2011-02-15 04:00:00	AAPL	Stock	12.855	12.8846	12.855	12.8839	38640.0
2011-02-15 05:00:00	AAPL	Stock	12.8929	12.8989	12.8839	12.8929	19600.0
2011-02-15 06:00:00	AAPL	Stock	12.8718	12.8893	12.8682	12.875	19600.0
2011-02-15 07:00:00	AAPL	Stock	12.875	12.8789	12.8571	12.8571	252476.0
2011-02-15 08:00:00	AAPL	Stock	12.8518	12.8625	12.8289	12.8486	2036468.0
2011-02-15 09:00:00	AAPL	Stock	12.8464	12.8561	12.7964	12.8335	54046300.0
2011-02-15 10:00:00	AAPL	Stock	12.8307	12.8386	12.7696	12.8136	61636092.0
2011-02-15 11:00:00	AAPL	Stock	12.8136	12.8396	12.7965	12.8089	28390544.0
2011-02-15 12:00:00	AAPL	Stock	12.8096	12.83	12.7929	12.8261	20044780.0
2011-02-15 13:00:00	AAPL	Stock	12.8269	12.835	12.8139	12.8234	16413684.0
2011-02-15 14:00:00	AAPL	Stock	12.8229	12.8364	12.7975	12.8239	30309104.0
2011-02-15 15:00:00	AAPL	Stock	12.8236	12.8554	12.8189	12.8554	54663028.0
2011-02-15 16:00:00	AAPL	Stock	12.8536	12.8671	12.8162	12.8636	8034964.0
2011-02-15 17:00:00	AAPL	Stock	12.8636	12.8657	12.86	12.8607	275100.0
2011-02-15 18:00:00	AAPL	Stock	12.8607	12.8646	12.8568	12.8607	754432.0
2011-02-15 19:00:00	AAPL	Stock	12.8607	12.8661	12.8593	12.8661	378028.0
2011-02-15 06:00:00	MSFT	Stock	27.18	27.21	27.18	27.21	2400.0
2011-02-15 07:00:00	MSFT	Stock	27.18	27.25	27.16	27.16	2800.0
2011-02-15 08:00:00	MSFT	Stock	27.19	27.3	27.08	27.14	24636.0
2011-02-15 09:00:00	MSFT	Stock	27.14	27.33	27.02	27.27	8449990.0
2011-02-15 10:00:00	MSFT	Stock	27.27	27.28	26.96	27.06	8097234.0
2011-02-15 11:00:00	MSFT	Stock	27.06	27.095	27.01	27.025	3861411.0
2011-02-15 12:00:00	MSFT	Stock	27.02	27.06	27.0	27.03	5214056.0
2011-02-15 13:00:00	MSFT	Stock	27.04	27.06	27.01	27.02	2377786.0
2011-02-15 14:00:00	MSFT	Stock	27.022	27.05	26.98	27.04	4024486.0
2011-02-15 15:00:00	MSFT	Stock	27.03	27.06	26.95	26.96	8605524.0
2011-02-15 16:00:00	MSFT	Stock	26.96	27.08	26.95	27.02	3059301.0
2011-02-15 17:00:00	MSFT	Stock	27.07	27.08	27.02	27.06	8100.0
2011-02-15 18:00:00	MSFT	Stock	27.05	27.05	26.96	27.05	5522.0
2011-02-15 19:00:00	MSFT	Stock	27.06	27.06	27.05	27.06	4101.0
2011-02-15 07:00:00	NVDA	Stock	0.58	0.5855	0.58	0.585	95000.0
2011-02-15 08:00:00	NVDA	Stock	0.5805	0.5848	0.5782	0.5825	2320840.0
2011-02-15 09:00:00	NVDA	Stock	0.5825	0.585	0.57	0.5741	146966680.0
2011-02-15 10:00:00	NVDA	Stock	0.5742	0.5745	0.5612	0.5646	237138480.0
2011-02-15 11:00:00	NVDA	Stock	0.5646	0.5675	0.5632	0.5647	77648200.0
2011-02-15 12:00:00	NVDA	Stock	0.5645	0.5702	0.5632	0.5698	76429920.0
2011-02-15 13:00:00	NVDA	Stock	0.5698	0.5718	0.5675	0.5684	64919240.0
2011-02-15 14:00:00	NVDA	Stock	0.5682	0.5685	0.5628	0.5645	70403160.0
2011-02-15 15:00:00	NVDA	Stock	0.5645	0.5652	0.5618	0.5638	138062720.0
2011-02-15 16:00:00	NVDA	Stock	0.564	0.5671	0.5622	0.567	68766480.0
2011-02-15 17:00:00	NVDA	Stock	0.5665	0.567	0.564	0.5655	1554640.0
2011-02-15 18:00:00	NVDA	Stock	0.5662	0.5662	0.5638	0.5638	402000.0
2011-02-15 19:00:00	NVDA	Stock	0.5648	0.5668	0.5648	0.565	294640.0
2011-02-15 05:00:00	AMZN	Stock	9.57	9.57	9.57	9.57	4000.0
2011-02-15 06:00:00	AMZN	Stock	9.555	9.585	9.555	9.585	4000.0
2011-02-15 07:00:00	AMZN	Stock	9.5165	9.5205	9.5125	9.5125	20000.0
2011-02-15 08:00:00	AMZN	Stock	9.495	9.5	9.4695	9.47	81600.0
2011-02-15 09:00:00	AMZN	Stock	9.4725	9.519	9.4225	9.4845	13425040.0
2011-02-15 10:00:00	AMZN	Stock	9.485	9.4925	9.4125	9.463	15155960.0
2011-02-15 11:00:00	AMZN	Stock	9.463	9.4885	9.451	9.455	8521420.0

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

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