PREVIEW / stock_1hour / 2010-10-21

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-10-21.parquet
  size:    946 KB
  rows:    45,298
  symbols: 3,488

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-10-21 04:00:00	AAPL	Stock	11.1607	11.1875	11.1607	11.1875	8400.0
2010-10-21 05:00:00	AAPL	Stock	11.1525	11.1546	11.145	11.145	28000.0
2010-10-21 06:00:00	AAPL	Stock	11.1429	11.1604	11.1429	11.1604	48944.0
2010-10-21 07:00:00	AAPL	Stock	11.1604	11.2143	11.1504	11.1957	855232.0
2010-10-21 08:00:00	AAPL	Stock	11.1711	11.1893	11.0904	11.1843	5585188.0
2010-10-21 09:00:00	AAPL	Stock	11.1843	11.2407	11.1114	11.2039	94339448.0
2010-10-21 10:00:00	AAPL	Stock	11.1996	11.225	11.1557	11.1732	89771612.0
2010-10-21 11:00:00	AAPL	Stock	11.1726	11.1896	11.0743	11.1093	80687964.0
2010-10-21 12:00:00	AAPL	Stock	11.1089	11.1118	11.0361	11.0786	50753192.0
2010-10-21 13:00:00	AAPL	Stock	11.0786	11.1007	10.9661	10.9787	58895312.0
2010-10-21 14:00:00	AAPL	Stock	10.9811	11.0411	10.9571	11.0369	71600816.0
2010-10-21 15:00:00	AAPL	Stock	11.0382	11.07	11.0179	11.0495	72344020.0
2010-10-21 16:00:00	AAPL	Stock	11.0536	11.104	11.0107	11.0107	12534620.0
2010-10-21 17:00:00	AAPL	Stock	11.0157	11.0895	11.0036	11.0207	1214668.0
2010-10-21 18:00:00	AAPL	Stock	11.0207	11.0543	11.0054	11.0143	371224.0
2010-10-21 19:00:00	AAPL	Stock	11.0196	11.0196	10.9429	10.9557	3285268.0
2010-10-21 04:00:00	MSFT	Stock	25.5	25.5	25.5	25.5	600.0
2010-10-21 07:00:00	MSFT	Stock	25.5	25.75	25.32	25.37	34300.0
2010-10-21 08:00:00	MSFT	Stock	25.4	25.45	25.3	25.35	71629.0
2010-10-21 09:00:00	MSFT	Stock	25.36	25.45	25.26	25.39	5564318.0
2010-10-21 10:00:00	MSFT	Stock	25.39	25.54	25.3	25.509	8526937.0
2010-10-21 11:00:00	MSFT	Stock	25.505	25.53	25.36	25.415	5548480.0
2010-10-21 12:00:00	MSFT	Stock	25.41	25.44	25.3	25.33	3418161.0
2010-10-21 13:00:00	MSFT	Stock	25.325	25.39	25.065	25.1	4794156.0
2010-10-21 14:00:00	MSFT	Stock	25.1	25.27	25.05	25.26	9052467.0
2010-10-21 15:00:00	MSFT	Stock	25.26	25.42	25.23	25.4	9090430.0
2010-10-21 16:00:00	MSFT	Stock	25.4	25.44	25.306	25.4	2947118.0
2010-10-21 17:00:00	MSFT	Stock	25.287	25.4	25.287	25.38	49328.0
2010-10-21 18:00:00	MSFT	Stock	25.42	25.42	25.23	25.32	19150.0
2010-10-21 19:00:00	MSFT	Stock	25.36	25.36	25.35	25.35	500.0
2010-10-21 08:00:00	NVDA	Stock	0.2825	0.2825	0.2825	0.2825	20000.0
2010-10-21 09:00:00	NVDA	Stock	0.2835	0.2835	0.279	0.279	102987600.0
2010-10-21 10:00:00	NVDA	Stock	0.2792	0.2795	0.2738	0.2773	316142920.0
2010-10-21 11:00:00	NVDA	Stock	0.2772	0.2783	0.2752	0.2761	136070760.0
2010-10-21 12:00:00	NVDA	Stock	0.2763	0.2763	0.273	0.275	91700440.0
2010-10-21 13:00:00	NVDA	Stock	0.2749	0.275	0.2731	0.2743	81203160.0
2010-10-21 14:00:00	NVDA	Stock	0.2745	0.2763	0.2732	0.2756	128908080.0
2010-10-21 15:00:00	NVDA	Stock	0.2756	0.2772	0.2755	0.2772	143244840.0
2010-10-21 16:00:00	NVDA	Stock	0.277	0.2772	0.276	0.2768	1110600.0
2010-10-21 17:00:00	NVDA	Stock	0.2817	0.2822	0.275	0.2765	1125200.0
2010-10-21 18:00:00	NVDA	Stock	0.2772	0.2772	0.2752	0.2752	113480.0
2010-10-21 06:00:00	AMZN	Stock	8.1	8.1775	8.1	8.177	43000.0
2010-10-21 07:00:00	AMZN	Stock	8.1905	8.2145	8.156	8.18	342400.0
2010-10-21 08:00:00	AMZN	Stock	8.176	8.199	8.075	8.105	1291620.0
2010-10-21 09:00:00	AMZN	Stock	8.115	8.3065	8.1	8.2565	47285580.0
2010-10-21 10:00:00	AMZN	Stock	8.257	8.275	8.195	8.271	30783200.0
2010-10-21 11:00:00	AMZN	Stock	8.271	8.2945	8.196	8.218	20531340.0
2010-10-21 12:00:00	AMZN	Stock	8.217	8.2195	8.1655	8.2	15387640.0
2010-10-21 13:00:00	AMZN	Stock	8.202	8.2485	8.09	8.1035	20436300.0
2010-10-21 14:00:00	AMZN	Stock	8.1011	8.1825	8.0645	8.167	30189260.0

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

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