PREVIEW / stock_1hour / 2009-03-25

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-03-25.parquet
  size:    821 KB
  rows:    40,405
  symbols: 3,324

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-03-25 04:00:00	AAPL	Stock	3.8121	3.8121	3.8121	3.8121	14000.0
2009-03-25 05:00:00	AAPL	Stock	3.8139	3.8207	3.8129	3.8207	14000.0
2009-03-25 06:00:00	AAPL	Stock	3.8121	3.8121	3.8121	3.8121	11200.0
2009-03-25 07:00:00	AAPL	Stock	3.8121	3.8146	3.8036	3.8125	42000.0
2009-03-25 08:00:00	AAPL	Stock	3.8125	3.8364	3.8032	3.8354	1382500.0
2009-03-25 09:00:00	AAPL	Stock	3.8357	3.8629	3.8182	3.8454	69335952.0
2009-03-25 10:00:00	AAPL	Stock	3.8471	3.87	3.8354	3.8396	88143860.0
2009-03-25 11:00:00	AAPL	Stock	3.8404	3.8561	3.8171	3.8489	73332784.0
2009-03-25 12:00:00	AAPL	Stock	3.8489	3.8679	3.8011	3.8154	72236948.0
2009-03-25 13:00:00	AAPL	Stock	3.8153	3.8243	3.7607	3.7718	76483764.0
2009-03-25 14:00:00	AAPL	Stock	3.7718	3.7739	3.7218	3.7239	97904772.0
2009-03-25 15:00:00	AAPL	Stock	3.7243	3.8243	3.7093	3.8032	130659536.0
2009-03-25 16:00:00	AAPL	Stock	3.8032	3.8292	3.7595	3.7996	19806388.0
2009-03-25 17:00:00	AAPL	Stock	3.8	3.8125	3.8	3.8114	396228.0
2009-03-25 18:00:00	AAPL	Stock	3.8096	3.8096	3.8032	3.8089	220472.0
2009-03-25 19:00:00	AAPL	Stock	3.8107	3.8121	3.8089	3.8118	16576.0
2009-03-25 07:00:00	MSFT	Stock	18.15	18.15	18.01	18.01	3700.0
2009-03-25 08:00:00	MSFT	Stock	18.05	18.05	17.93	18.04	184331.0
2009-03-25 09:00:00	MSFT	Stock	18.05	18.17	17.85	18.15	8225196.0
2009-03-25 10:00:00	MSFT	Stock	18.15	18.31	18.08	18.21	8714170.0
2009-03-25 11:00:00	MSFT	Stock	18.21	18.27	18.04	18.11	6247820.0
2009-03-25 12:00:00	MSFT	Stock	18.1	18.28	18.07	18.265	7701474.0
2009-03-25 13:00:00	MSFT	Stock	18.26	18.3	17.87	17.87	6593766.0
2009-03-25 14:00:00	MSFT	Stock	17.87	17.89	17.53	17.58	7512752.0
2009-03-25 15:00:00	MSFT	Stock	17.58	17.99	17.52	17.86	15267711.0
2009-03-25 16:00:00	MSFT	Stock	17.87	18.17	17.726	17.9	7974642.0
2009-03-25 17:00:00	MSFT	Stock	17.88	17.97	17.88	17.93	2006500.0
2009-03-25 18:00:00	MSFT	Stock	17.95	17.95	17.9	17.9	4315.0
2009-03-25 19:00:00	MSFT	Stock	17.95	17.99	17.94	17.95	3390.0
2009-03-25 08:00:00	NVDA	Stock	0.2448	0.2547	0.2448	0.25	1281680.0
2009-03-25 09:00:00	NVDA	Stock	0.2507	0.26	0.25	0.2545	196995160.0
2009-03-25 10:00:00	NVDA	Stock	0.2545	0.259	0.2507	0.2507	295419680.0
2009-03-25 11:00:00	NVDA	Stock	0.251	0.2535	0.2488	0.2513	106104800.0
2009-03-25 12:00:00	NVDA	Stock	0.251	0.253	0.2473	0.249	153162320.0
2009-03-25 13:00:00	NVDA	Stock	0.249	0.2503	0.2422	0.2448	141276720.0
2009-03-25 14:00:00	NVDA	Stock	0.2448	0.245	0.2392	0.2402	128730360.0
2009-03-25 15:00:00	NVDA	Stock	0.2402	0.2498	0.2389	0.2485	193400200.0
2009-03-25 16:00:00	NVDA	Stock	0.2488	0.2502	0.2475	0.2485	15916280.0
2009-03-25 17:00:00	NVDA	Stock	0.2493	0.2493	0.2493	0.2493	8000.0
2009-03-25 18:00:00	NVDA	Stock	0.2495	0.2495	0.2495	0.2495	84000.0
2009-03-25 19:00:00	NVDA	Stock	0.2495	0.2495	0.2475	0.2475	72000.0
2009-03-25 08:00:00	AMZN	Stock	3.64	3.6545	3.638	3.65	457380.0
2009-03-25 09:00:00	AMZN	Stock	3.6545	3.6845	3.63	3.6665	15966560.0
2009-03-25 10:00:00	AMZN	Stock	3.6675	3.6975	3.5925	3.5975	32414920.0
2009-03-25 11:00:00	AMZN	Stock	3.5975	3.625	3.5815	3.595	21039660.0
2009-03-25 12:00:00	AMZN	Stock	3.596	3.6245	3.5585	3.57	16186380.0
2009-03-25 13:00:00	AMZN	Stock	3.57	3.5765	3.5156	3.525	16279760.0
2009-03-25 14:00:00	AMZN	Stock	3.5245	3.535	3.492	3.5155	20679720.0
2009-03-25 15:00:00	AMZN	Stock	3.515	3.625	3.507	3.6195	30645600.0
2009-03-25 16:00:00	AMZN	Stock	3.6225	3.6225	3.4935	3.616	1178400.0

> showing 50 of 40,405 rows — these rows as CSV

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