PREVIEW / stock_1hour / 2012-02-01

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-02-01.parquet
  size:    962 KB
  rows:    45,376
  symbols: 3,544

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
2012-02-01 04:00:00	AAPL	Stock	16.3214	16.4075	16.3214	16.4075	52080.0
2012-02-01 05:00:00	AAPL	Stock	16.4286	16.4286	16.3982	16.3982	76720.0
2012-02-01 06:00:00	AAPL	Stock	16.3964	16.3964	16.3914	16.3929	64820.0
2012-02-01 07:00:00	AAPL	Stock	16.3914	16.3914	16.3593	16.3786	673792.0
2012-02-01 08:00:00	AAPL	Stock	16.3743	16.3779	16.35	16.3675	1574636.0
2012-02-01 09:00:00	AAPL	Stock	16.3693	16.3925	16.3029	16.3314	47988780.0
2012-02-01 10:00:00	AAPL	Stock	16.3296	16.3375	16.2696	16.3135	56859320.0
2012-02-01 11:00:00	AAPL	Stock	16.3136	16.3311	16.2775	16.3011	40600644.0
2012-02-01 12:00:00	AAPL	Stock	16.3004	16.3304	16.2917	16.3236	22721160.0
2012-02-01 13:00:00	AAPL	Stock	16.323	16.3296	16.3061	16.3096	20123208.0
2012-02-01 14:00:00	AAPL	Stock	16.3104	16.3161	16.2946	16.3021	22494248.0
2012-02-01 15:00:00	AAPL	Stock	16.3025	16.3096	16.2768	16.2925	42000672.0
2012-02-01 16:00:00	AAPL	Stock	16.2919	16.3203	16.2846	16.3011	7400792.0
2012-02-01 17:00:00	AAPL	Stock	16.3018	16.3214	16.295	16.3082	397236.0
2012-02-01 18:00:00	AAPL	Stock	16.3089	16.3214	16.3071	16.3193	68656.0
2012-02-01 19:00:00	AAPL	Stock	16.3189	16.3304	16.3175	16.3304	539336.0
2012-02-01 06:00:00	MSFT	Stock	29.65	29.72	29.65	29.72	2200.0
2012-02-01 07:00:00	MSFT	Stock	29.82	29.82	29.71	29.73	39275.0
2012-02-01 08:00:00	MSFT	Stock	29.66	29.7	29.53	29.69	101724.0
2012-02-01 09:00:00	MSFT	Stock	29.69	29.9	29.69	29.9	6125319.0
2012-02-01 10:00:00	MSFT	Stock	29.9	30.0	29.84	30.0	10972830.0
2012-02-01 11:00:00	MSFT	Stock	29.995	30.05	29.91	29.99	14625821.0
2012-02-01 12:00:00	MSFT	Stock	30.0	30.04	29.92	29.96	7867974.0
2012-02-01 13:00:00	MSFT	Stock	29.956	30.05	29.95	29.999	4959477.0
2012-02-01 14:00:00	MSFT	Stock	30.0	30.04	29.96	29.97	5633260.0
2012-02-01 15:00:00	MSFT	Stock	29.965	30.03	29.87	29.89	11409191.0
2012-02-01 16:00:00	MSFT	Stock	29.89	30.011	29.53	29.91	2534656.0
2012-02-01 17:00:00	MSFT	Stock	29.91	29.97	29.91	29.95	9735.0
2012-02-01 18:00:00	MSFT	Stock	29.94	29.96	29.94	29.95	1650.0
2012-02-01 19:00:00	MSFT	Stock	29.95	29.97	29.95	29.97	3950.0
2012-02-01 09:00:00	NVDA	Stock	0.3713	0.3738	0.3682	0.37	35844640.0
2012-02-01 10:00:00	NVDA	Stock	0.37	0.3748	0.3695	0.3745	66859120.0
2012-02-01 11:00:00	NVDA	Stock	0.3743	0.3748	0.3718	0.374	46963720.0
2012-02-01 12:00:00	NVDA	Stock	0.3738	0.375	0.3738	0.375	26127120.0
2012-02-01 13:00:00	NVDA	Stock	0.3749	0.3775	0.3748	0.376	72364920.0
2012-02-01 14:00:00	NVDA	Stock	0.376	0.377	0.3753	0.3765	33837200.0
2012-02-01 15:00:00	NVDA	Stock	0.3765	0.377	0.373	0.3733	128589000.0
2012-02-01 16:00:00	NVDA	Stock	0.3745	0.3765	0.3732	0.3765	8887400.0
2012-02-01 17:00:00	NVDA	Stock	0.3743	0.375	0.3743	0.375	25760.0
2012-02-01 18:00:00	NVDA	Stock	0.3753	0.3753	0.3753	0.3753	4000.0
2012-02-01 04:00:00	AMZN	Stock	8.8475	8.9875	8.8475	8.949	60020.0
2012-02-01 05:00:00	AMZN	Stock	8.935	8.96	8.935	8.96	14000.0
2012-02-01 06:00:00	AMZN	Stock	8.9375	8.9415	8.887	8.91	152420.0
2012-02-01 07:00:00	AMZN	Stock	8.8925	8.9	8.8055	8.826	808800.0
2012-02-01 08:00:00	AMZN	Stock	8.835	8.8505	8.7	8.7025	7224600.0
2012-02-01 09:00:00	AMZN	Stock	8.705	8.8075	8.6	8.7815	122757320.0
2012-02-01 10:00:00	AMZN	Stock	8.7815	8.8605	8.725	8.8375	82718740.0
2012-02-01 11:00:00	AMZN	Stock	8.835	8.901	8.818	8.847	43154000.0
2012-02-01 12:00:00	AMZN	Stock	8.847	8.95	8.8245	8.9276	29059760.0
2012-02-01 13:00:00	AMZN	Stock	8.9255	8.9975	8.875	8.9424	48020540.0

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

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