PREVIEW / stock_1hour / 2009-10-26

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-10-26.parquet
  size:    887 KB
  rows:    42,334
  symbols: 3,393

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
2009-10-26 05:00:00	AAPL	Stock	7.3161	7.3161	7.3125	7.3125	5600.0
2009-10-26 07:00:00	AAPL	Stock	7.3089	7.31	7.3054	7.31	8400.0
2009-10-26 08:00:00	AAPL	Stock	7.3	7.3036	7.2786	7.2879	933296.0
2009-10-26 09:00:00	AAPL	Stock	7.2857	7.375	7.1464	7.3675	80299380.0
2009-10-26 10:00:00	AAPL	Stock	7.3664	7.3839	7.3279	7.3493	74543056.0
2009-10-26 11:00:00	AAPL	Stock	7.3486	7.3579	7.25	7.2511	90129956.0
2009-10-26 12:00:00	AAPL	Stock	7.25	7.2639	7.2143	7.25	68237204.0
2009-10-26 13:00:00	AAPL	Stock	7.25	7.2629	7.2089	7.2593	42117068.0
2009-10-26 14:00:00	AAPL	Stock	7.2593	7.2657	7.2232	7.2347	44697520.0
2009-10-26 15:00:00	AAPL	Stock	7.2329	7.2571	7.2143	7.2243	65867788.0
2009-10-26 16:00:00	AAPL	Stock	7.2318	7.2899	7.2232	7.2314	9089332.0
2009-10-26 17:00:00	AAPL	Stock	7.2293	7.2357	7.185	7.185	1026004.0
2009-10-26 18:00:00	AAPL	Stock	7.1857	7.2314	7.1786	7.1875	1641836.0
2009-10-26 19:00:00	AAPL	Stock	7.1857	7.1964	7.1839	7.1839	428904.0
2009-10-26 04:00:00	MSFT	Stock	28.27	28.32	28.27	28.32	1100.0
2009-10-26 06:00:00	MSFT	Stock	28.27	28.27	28.25	28.25	5000.0
2009-10-26 07:00:00	MSFT	Stock	28.3	28.34	28.22	28.22	72084.0
2009-10-26 08:00:00	MSFT	Stock	28.22	28.27	28.14	28.25	206875.0
2009-10-26 09:00:00	MSFT	Stock	28.25	28.74	28.1	28.68	18250916.0
2009-10-26 10:00:00	MSFT	Stock	28.68	28.97	28.68	28.97	23780064.0
2009-10-26 11:00:00	MSFT	Stock	28.97	29.02	28.61	28.62	24807865.0
2009-10-26 12:00:00	MSFT	Stock	28.62	28.92	28.61	28.87	12030115.0
2009-10-26 13:00:00	MSFT	Stock	28.87	28.88	28.67	28.78	8981227.0
2009-10-26 14:00:00	MSFT	Stock	28.79	28.8	28.51	28.632	12780309.0
2009-10-26 15:00:00	MSFT	Stock	28.63	28.82	28.56	28.69	16477909.0
2009-10-26 16:00:00	MSFT	Stock	28.7	28.835	28.614	28.75	3186705.0
2009-10-26 17:00:00	MSFT	Stock	28.723	28.75	28.56	28.57	158803.0
2009-10-26 18:00:00	MSFT	Stock	28.55	28.68	28.55	28.6	101246.0
2009-10-26 19:00:00	MSFT	Stock	28.63	28.64	28.6	28.6	14435.0
2009-10-26 09:00:00	NVDA	Stock	0.3313	0.336	0.3285	0.3355	61513760.0
2009-10-26 10:00:00	NVDA	Stock	0.3356	0.3362	0.3325	0.3338	61852040.0
2009-10-26 11:00:00	NVDA	Stock	0.3338	0.3355	0.3267	0.3267	64541280.0
2009-10-26 12:00:00	NVDA	Stock	0.3268	0.3287	0.3228	0.3255	87818160.0
2009-10-26 13:00:00	NVDA	Stock	0.3258	0.329	0.3233	0.3248	87481960.0
2009-10-26 14:00:00	NVDA	Stock	0.3245	0.326	0.3235	0.3247	41911320.0
2009-10-26 15:00:00	NVDA	Stock	0.3245	0.3265	0.3238	0.3245	66266840.0
2009-10-26 16:00:00	NVDA	Stock	0.3248	0.3281	0.3244	0.325	1903920.0
2009-10-26 17:00:00	NVDA	Stock	0.325	0.325	0.3243	0.3243	99880.0
2009-10-26 18:00:00	NVDA	Stock	0.3243	0.3243	0.3225	0.3225	44800.0
2009-10-26 19:00:00	NVDA	Stock	0.324	0.324	0.324	0.324	4000.0
2009-10-26 04:00:00	AMZN	Stock	5.91	5.925	5.91	5.915	92360.0
2009-10-26 05:00:00	AMZN	Stock	5.915	5.915	5.9005	5.9005	79440.0
2009-10-26 06:00:00	AMZN	Stock	5.9115	5.925	5.9005	5.9135	78000.0
2009-10-26 07:00:00	AMZN	Stock	5.93	5.9695	5.92	5.952	280720.0
2009-10-26 08:00:00	AMZN	Stock	5.9495	6.06	5.942	6.005	7081840.0
2009-10-26 09:00:00	AMZN	Stock	6.002	6.133	5.9415	6.115	103926720.0
2009-10-26 10:00:00	AMZN	Stock	6.115	6.184	6.0816	6.1405	116715140.0
2009-10-26 11:00:00	AMZN	Stock	6.1395	6.195	6.0952	6.141	88011360.0
2009-10-26 12:00:00	AMZN	Stock	6.1405	6.1985	6.116	6.1865	57765940.0
2009-10-26 13:00:00	AMZN	Stock	6.185	6.2785	6.1705	6.234	81167080.0

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

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