PREVIEW / stock_1hour / 2013-03-11

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-03-11.parquet
  size:    971 KB
  rows:    45,409
  symbols: 3,469

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
2013-03-11 05:00:00	AAPL	Stock	15.3589	15.3589	15.3589	15.3589	2800.0
2013-03-11 06:00:00	AAPL	Stock	15.3589	15.3589	15.3393	15.3393	11200.0
2013-03-11 07:00:00	AAPL	Stock	15.3839	15.3839	15.25	15.3214	264208.0
2013-03-11 08:00:00	AAPL	Stock	15.2786	15.3879	15.2786	15.3361	1460060.0
2013-03-11 09:00:00	AAPL	Stock	15.3361	15.3482	15.2264	15.2732	53211144.0
2013-03-11 10:00:00	AAPL	Stock	15.2689	15.2836	15.1836	15.205	55518848.0
2013-03-11 11:00:00	AAPL	Stock	15.2055	15.2618	15.1946	15.2379	33697832.0
2013-03-11 12:00:00	AAPL	Stock	15.2418	15.3029	15.2396	15.275	22799308.0
2013-03-11 13:00:00	AAPL	Stock	15.275	15.3207	15.2375	15.2986	24611076.0
2013-03-11 14:00:00	AAPL	Stock	15.2989	15.6571	15.275	15.5826	119882672.0
2013-03-11 15:00:00	AAPL	Stock	15.5804	15.6789	15.5486	15.6341	120081948.0
2013-03-11 16:00:00	AAPL	Stock	15.6334	15.6414	15.2314	15.6075	35724108.0
2013-03-11 17:00:00	AAPL	Stock	15.6171	15.6382	15.6107	15.6161	741132.0
2013-03-11 18:00:00	AAPL	Stock	15.6164	15.6182	15.6111	15.6182	348040.0
2013-03-11 19:00:00	AAPL	Stock	15.6182	15.6182	15.5982	15.6175	796880.0
2013-03-11 08:00:00	MSFT	Stock	28.0	28.0	27.9	27.9	10830.0
2013-03-11 09:00:00	MSFT	Stock	27.9	27.97	27.77	27.848	4669832.0
2013-03-11 10:00:00	MSFT	Stock	27.846	27.87	27.67	27.71	4945484.0
2013-03-11 11:00:00	MSFT	Stock	27.715	27.84	27.71	27.82	3008270.0
2013-03-11 12:00:00	MSFT	Stock	27.83	27.87	27.76	27.78	3314517.0
2013-03-11 13:00:00	MSFT	Stock	27.779	27.91	27.77	27.85	3534515.0
2013-03-11 14:00:00	MSFT	Stock	27.86	27.86	27.77	27.785	3566617.0
2013-03-11 15:00:00	MSFT	Stock	27.79	27.88	27.76	27.88	8275480.0
2013-03-11 16:00:00	MSFT	Stock	27.87	28.04	27.783	27.87	4262954.0
2013-03-11 17:00:00	MSFT	Stock	27.87	27.87	27.86	27.86	10789.0
2013-03-11 18:00:00	MSFT	Stock	27.85	27.87	27.85	27.86	3400.0
2013-03-11 19:00:00	MSFT	Stock	27.87	27.87	27.85	27.87	4832.0
2013-03-11 06:00:00	NVDA	Stock	0.3198	0.3198	0.3165	0.317	16000.0
2013-03-11 07:00:00	NVDA	Stock	0.3175	0.318	0.3175	0.318	200000.0
2013-03-11 08:00:00	NVDA	Stock	0.3175	0.3175	0.317	0.3175	276000.0
2013-03-11 09:00:00	NVDA	Stock	0.3183	0.3183	0.3148	0.3175	47372760.0
2013-03-11 10:00:00	NVDA	Stock	0.3174	0.3174	0.3155	0.3163	39584280.0
2013-03-11 11:00:00	NVDA	Stock	0.3164	0.3173	0.316	0.3161	23235720.0
2013-03-11 12:00:00	NVDA	Stock	0.3163	0.3178	0.316	0.3173	34212840.0
2013-03-11 13:00:00	NVDA	Stock	0.3173	0.3188	0.3171	0.3175	21161680.0
2013-03-11 14:00:00	NVDA	Stock	0.3176	0.3183	0.3173	0.3176	21610440.0
2013-03-11 15:00:00	NVDA	Stock	0.3176	0.318	0.3155	0.3175	101778480.0
2013-03-11 16:00:00	NVDA	Stock	0.3175	0.318	0.3158	0.3175	9624280.0
2013-03-11 17:00:00	NVDA	Stock	0.3174	0.3174	0.3174	0.3174	356120.0
2013-03-11 05:00:00	AMZN	Stock	13.6825	13.6825	13.6825	13.6825	2000.0
2013-03-11 06:00:00	AMZN	Stock	13.7175	13.7175	13.6975	13.6975	6000.0
2013-03-11 08:00:00	AMZN	Stock	13.6765	13.6765	13.633	13.633	28000.0
2013-03-11 09:00:00	AMZN	Stock	13.6505	13.6995	13.612	13.632	5285020.0
2013-03-11 10:00:00	AMZN	Stock	13.633	13.6515	13.545	13.5635	6669480.0
2013-03-11 11:00:00	AMZN	Stock	13.5615	13.604	13.5515	13.5815	4618440.0
2013-03-11 12:00:00	AMZN	Stock	13.583	13.62	13.5775	13.615	4712700.0
2013-03-11 13:00:00	AMZN	Stock	13.618	13.628	13.5923	13.5975	2482960.0
2013-03-11 14:00:00	AMZN	Stock	13.5945	13.601	13.551	13.5805	2954920.0
2013-03-11 15:00:00	AMZN	Stock	13.5785	13.5995	13.52	13.5585	8249740.0
2013-03-11 16:00:00	AMZN	Stock	13.5995	13.6545	13.553	13.5793	372400.0

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

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