PREVIEW / stock_1hour / 2010-09-20

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-09-20.parquet
  size:    947 KB
  rows:    46,156
  symbols: 3,502

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-09-20 04:00:00	AAPL	Stock	9.8571	9.8571	9.8571	9.8571	5600.0
2010-09-20 05:00:00	AAPL	Stock	9.8571	9.8571	9.8571	9.8571	5600.0
2010-09-20 07:00:00	AAPL	Stock	9.8493	9.8764	9.8489	9.8682	108500.0
2010-09-20 08:00:00	AAPL	Stock	9.8739	9.8739	9.8482	9.8532	1996232.0
2010-09-20 09:00:00	AAPL	Stock	9.8525	9.9961	9.8518	9.9732	127715672.0
2010-09-20 10:00:00	AAPL	Stock	9.9739	10.0629	9.9646	10.0271	149181788.0
2010-09-20 11:00:00	AAPL	Stock	10.0271	10.0446	10.0132	10.0254	49661472.0
2010-09-20 12:00:00	AAPL	Stock	10.0254	10.0475	10.015	10.0425	50580152.0
2010-09-20 13:00:00	AAPL	Stock	10.0428	10.0714	10.0325	10.0696	61607224.0
2010-09-20 14:00:00	AAPL	Stock	10.0693	10.1054	10.0575	10.1021	68325712.0
2010-09-20 15:00:00	AAPL	Stock	10.1025	10.135	10.0939	10.1264	131411728.0
2010-09-20 16:00:00	AAPL	Stock	10.1225	10.1243	9.876	10.1086	10787980.0
2010-09-20 17:00:00	AAPL	Stock	10.11	10.1204	10.1079	10.1175	762524.0
2010-09-20 18:00:00	AAPL	Stock	10.1175	10.1196	10.1111	10.1139	327460.0
2010-09-20 19:00:00	AAPL	Stock	10.1121	10.1193	10.1107	10.1157	341460.0
2010-09-20 07:00:00	MSFT	Stock	25.4	25.4	25.4	25.4	300.0
2010-09-20 08:00:00	MSFT	Stock	25.3	25.31	25.26	25.27	30030.0
2010-09-20 09:00:00	MSFT	Stock	25.29	25.3	25.11	25.22	4587700.0
2010-09-20 10:00:00	MSFT	Stock	25.23	25.45	25.166	25.385	8319164.0
2010-09-20 11:00:00	MSFT	Stock	25.39	25.41	25.3	25.36	4698222.0
2010-09-20 12:00:00	MSFT	Stock	25.36	25.36	25.26	25.315	3485477.0
2010-09-20 13:00:00	MSFT	Stock	25.31	25.34	25.26	25.315	3428254.0
2010-09-20 14:00:00	MSFT	Stock	25.312	25.41	25.27	25.402	4923795.0
2010-09-20 15:00:00	MSFT	Stock	25.4	25.52	25.4	25.43	13155288.0
2010-09-20 16:00:00	MSFT	Stock	25.43	25.5	25.36	25.42	7043308.0
2010-09-20 17:00:00	MSFT	Stock	25.43	25.44	25.38	25.38	52592.0
2010-09-20 18:00:00	MSFT	Stock	25.38	25.43	25.37	25.38	40695.0
2010-09-20 19:00:00	MSFT	Stock	25.39	25.4	25.37	25.37	2194.0
2010-09-20 08:00:00	NVDA	Stock	0.2645	0.2645	0.2645	0.2645	20000.0
2010-09-20 09:00:00	NVDA	Stock	0.2645	0.265	0.2612	0.2628	57774880.0
2010-09-20 10:00:00	NVDA	Stock	0.2628	0.2663	0.2625	0.2655	90089760.0
2010-09-20 11:00:00	NVDA	Stock	0.2656	0.2668	0.264	0.2648	64217280.0
2010-09-20 12:00:00	NVDA	Stock	0.2648	0.2658	0.2638	0.2653	30235520.0
2010-09-20 13:00:00	NVDA	Stock	0.2652	0.2663	0.2648	0.266	39417920.0
2010-09-20 14:00:00	NVDA	Stock	0.266	0.2683	0.2652	0.2681	50023080.0
2010-09-20 15:00:00	NVDA	Stock	0.268	0.2688	0.2675	0.2678	95606760.0
2010-09-20 16:00:00	NVDA	Stock	0.2672	0.268	0.2658	0.268	2744920.0
2010-09-20 17:00:00	NVDA	Stock	0.267	0.2675	0.2663	0.2675	632600.0
2010-09-20 18:00:00	NVDA	Stock	0.268	0.268	0.268	0.268	40000.0
2010-09-20 19:00:00	NVDA	Stock	0.2668	0.2668	0.2668	0.2668	13800.0
2010-09-20 05:00:00	AMZN	Stock	7.417	7.4175	7.417	7.4175	4000.0
2010-09-20 08:00:00	AMZN	Stock	7.42	7.43	7.4155	7.4155	44000.0
2010-09-20 09:00:00	AMZN	Stock	7.415	7.4422	7.3695	7.3725	12247140.0
2010-09-20 10:00:00	AMZN	Stock	7.373	7.5245	7.3675	7.5115	25916600.0
2010-09-20 11:00:00	AMZN	Stock	7.515	7.5445	7.49	7.497	15685700.0
2010-09-20 12:00:00	AMZN	Stock	7.4985	7.5	7.4445	7.4595	15392960.0
2010-09-20 13:00:00	AMZN	Stock	7.4587	7.5225	7.4415	7.4678	10562520.0
2010-09-20 14:00:00	AMZN	Stock	7.468	7.5205	7.4615	7.5065	13734360.0
2010-09-20 15:00:00	AMZN	Stock	7.507	7.5975	7.5	7.566	31396340.0
2010-09-20 16:00:00	AMZN	Stock	7.566	7.575	7.4876	7.57	925780.0

> showing 50 of 46,156 rows — these rows as CSV

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