PREVIEW / stock_1hour / 2010-02-26

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-02-26.parquet
  size:    886 KB
  rows:    42,433
  symbols: 3,453

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-02-26 06:00:00	AAPL	Stock	7.2357	7.2361	7.2343	7.2361	33600.0
2010-02-26 07:00:00	AAPL	Stock	7.235	7.2464	7.2236	7.2296	531020.0
2010-02-26 08:00:00	AAPL	Stock	7.2286	7.2571	7.2143	7.2511	3367028.0
2010-02-26 09:00:00	AAPL	Stock	7.2511	7.2571	7.2143	7.24	71911756.0
2010-02-26 10:00:00	AAPL	Stock	7.2418	7.3275	7.2357	7.2993	156691052.0
2010-02-26 11:00:00	AAPL	Stock	7.2996	7.3214	7.2904	7.3046	55532148.0
2010-02-26 12:00:00	AAPL	Stock	7.3043	7.3139	7.2929	7.3021	39296824.0
2010-02-26 13:00:00	AAPL	Stock	7.3021	7.3214	7.3011	7.3179	34070400.0
2010-02-26 14:00:00	AAPL	Stock	7.3179	7.3214	7.3089	7.3204	29960392.0
2010-02-26 15:00:00	AAPL	Stock	7.3211	7.3268	7.2946	7.3086	92359120.0
2010-02-26 16:00:00	AAPL	Stock	7.3086	7.3248	7.2947	7.3093	14887712.0
2010-02-26 17:00:00	AAPL	Stock	7.3079	7.3121	7.3071	7.3086	555100.0
2010-02-26 18:00:00	AAPL	Stock	7.3089	7.3093	7.3071	7.3093	114324.0
2010-02-26 19:00:00	AAPL	Stock	7.3096	7.3154	7.3071	7.3107	271572.0
2010-02-26 06:00:00	MSFT	Stock	28.8	28.8	28.8	28.8	100.0
2010-02-26 08:00:00	MSFT	Stock	28.55	28.66	28.54	28.65	42676.0
2010-02-26 09:00:00	MSFT	Stock	28.64	28.68	28.51	28.61	3471850.0
2010-02-26 10:00:00	MSFT	Stock	28.62	28.85	28.58	28.7	7184311.0
2010-02-26 11:00:00	MSFT	Stock	28.7	28.84	28.67	28.79	3881719.0
2010-02-26 12:00:00	MSFT	Stock	28.79	28.8	28.65	28.745	3445581.0
2010-02-26 13:00:00	MSFT	Stock	28.75	28.8	28.71	28.765	3031840.0
2010-02-26 14:00:00	MSFT	Stock	28.77	28.77	28.68	28.76	2458125.0
2010-02-26 15:00:00	MSFT	Stock	28.755	28.81	28.67	28.67	8742877.0
2010-02-26 16:00:00	MSFT	Stock	28.68	28.753	28.648	28.67	5652593.0
2010-02-26 17:00:00	MSFT	Stock	28.66	28.67	28.66	28.67	79123.0
2010-02-26 18:00:00	MSFT	Stock	28.7	28.7	28.7	28.7	200.0
2010-02-26 19:00:00	MSFT	Stock	28.67	28.71	28.66	28.66	2203.0
2010-02-26 08:00:00	NVDA	Stock	0.41	0.41	0.404	0.4048	142880.0
2010-02-26 09:00:00	NVDA	Stock	0.4082	0.411	0.4025	0.4055	38064360.0
2010-02-26 10:00:00	NVDA	Stock	0.4055	0.4093	0.4032	0.4055	71328840.0
2010-02-26 11:00:00	NVDA	Stock	0.406	0.407	0.4048	0.4053	36745600.0
2010-02-26 12:00:00	NVDA	Stock	0.4055	0.4058	0.404	0.4045	30662600.0
2010-02-26 13:00:00	NVDA	Stock	0.4045	0.4062	0.4043	0.406	20905840.0
2010-02-26 14:00:00	NVDA	Stock	0.4062	0.4065	0.405	0.4057	40770960.0
2010-02-26 15:00:00	NVDA	Stock	0.4058	0.406	0.404	0.405	126219360.0
2010-02-26 16:00:00	NVDA	Stock	0.405	0.41	0.4046	0.405	22692120.0
2010-02-26 17:00:00	NVDA	Stock	0.405	0.405	0.405	0.405	436200.0
2010-02-26 18:00:00	NVDA	Stock	0.405	0.4058	0.405	0.4058	1904840.0
2010-02-26 08:00:00	AMZN	Stock	5.91	5.9135	5.9	5.9135	65120.0
2010-02-26 09:00:00	AMZN	Stock	5.9155	5.9155	5.85	5.8645	9505120.0
2010-02-26 10:00:00	AMZN	Stock	5.8645	5.923	5.8525	5.904	22215780.0
2010-02-26 11:00:00	AMZN	Stock	5.9035	5.9715	5.8985	5.9455	21922940.0
2010-02-26 12:00:00	AMZN	Stock	5.945	5.957	5.9215	5.9295	11945360.0
2010-02-26 13:00:00	AMZN	Stock	5.9295	5.944	5.925	5.941	7496220.0
2010-02-26 14:00:00	AMZN	Stock	5.94	5.94	5.9165	5.9245	9022820.0
2010-02-26 15:00:00	AMZN	Stock	5.924	5.935	5.91	5.9155	25932500.0
2010-02-26 16:00:00	AMZN	Stock	5.912	5.933	5.91	5.92	1104380.0
2010-02-26 17:00:00	AMZN	Stock	5.92	5.9255	5.92	5.9255	152020.0
2010-02-26 18:00:00	AMZN	Stock	5.92	5.92	5.92	5.92	150100.0
2010-02-26 19:00:00	AMZN	Stock	5.9225	5.9225	5.9225	5.9225	6200.0

> showing 50 of 42,433 rows — these rows as CSV

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