PREVIEW / stock_1hour / 2010-08-25

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-08-25.parquet
  size:    915 KB
  rows:    44,788
  symbols: 3,469

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-08-25 04:00:00	AAPL	Stock	8.6171	8.6296	8.5893	8.6296	21000.0
2010-08-25 05:00:00	AAPL	Stock	8.6071	8.6071	8.585	8.585	8400.0
2010-08-25 07:00:00	AAPL	Stock	8.5343	8.5764	8.5343	8.5536	215068.0
2010-08-25 08:00:00	AAPL	Stock	8.5546	8.5546	8.5	8.5018	3014256.0
2010-08-25 09:00:00	AAPL	Stock	8.5025	8.5796	8.4839	8.5161	100288524.0
2010-08-25 10:00:00	AAPL	Stock	8.5161	8.5454	8.4714	8.5343	121498692.0
2010-08-25 11:00:00	AAPL	Stock	8.5329	8.5829	8.5136	8.5525	76510420.0
2010-08-25 12:00:00	AAPL	Stock	8.5521	8.5775	8.515	8.5279	42392112.0
2010-08-25 13:00:00	AAPL	Stock	8.5291	8.5611	8.5214	8.5561	33156536.0
2010-08-25 14:00:00	AAPL	Stock	8.5561	8.6514	8.5529	8.65	91985208.0
2010-08-25 15:00:00	AAPL	Stock	8.6495	8.7139	8.6396	8.6746	112631596.0
2010-08-25 16:00:00	AAPL	Stock	8.6746	8.7103	8.5064	8.6811	10807076.0
2010-08-25 17:00:00	AAPL	Stock	8.6775	8.7079	8.6771	8.7054	1108044.0
2010-08-25 18:00:00	AAPL	Stock	8.7032	8.705	8.6746	8.7	448532.0
2010-08-25 19:00:00	AAPL	Stock	8.7	8.7082	8.7	8.7036	454636.0
2010-08-25 08:00:00	MSFT	Stock	24.03	24.04	23.95	23.95	19728.0
2010-08-25 09:00:00	MSFT	Stock	23.99	24.08	23.88	23.94	5820350.0
2010-08-25 10:00:00	MSFT	Stock	23.94	24.078	23.87	24.06	8612006.0
2010-08-25 11:00:00	MSFT	Stock	24.05	24.21	24.02	24.14	6822221.0
2010-08-25 12:00:00	MSFT	Stock	24.13	24.18	24.05	24.075	3795929.0
2010-08-25 13:00:00	MSFT	Stock	24.079	24.175	24.02	24.11	4272542.0
2010-08-25 14:00:00	MSFT	Stock	24.11	24.22	24.1	24.18	5430762.0
2010-08-25 15:00:00	MSFT	Stock	24.18	24.21	24.07	24.1	9566356.0
2010-08-25 16:00:00	MSFT	Stock	24.11	24.195	23.938	23.938	2407479.0
2010-08-25 17:00:00	MSFT	Stock	24.15	24.15	24.11	24.11	5062.0
2010-08-25 18:00:00	MSFT	Stock	24.1	24.12	24.1	24.12	37427.0
2010-08-25 19:00:00	MSFT	Stock	24.11	24.11	24.11	24.11	175.0
2010-08-25 20:00:00	MSFT	Stock	24.06	24.06	24.06	24.06	11240.0
2010-08-25 08:00:00	NVDA	Stock	0.239	0.2428	0.2388	0.2412	330000.0
2010-08-25 09:00:00	NVDA	Stock	0.2392	0.243	0.239	0.2415	67018240.0
2010-08-25 10:00:00	NVDA	Stock	0.2415	0.2422	0.239	0.2415	105783400.0
2010-08-25 11:00:00	NVDA	Stock	0.2412	0.2465	0.2412	0.2462	116220440.0
2010-08-25 12:00:00	NVDA	Stock	0.246	0.2462	0.2438	0.2445	47610760.0
2010-08-25 13:00:00	NVDA	Stock	0.2445	0.2468	0.2445	0.2458	44898360.0
2010-08-25 14:00:00	NVDA	Stock	0.2458	0.2499	0.245	0.2498	169518120.0
2010-08-25 15:00:00	NVDA	Stock	0.2495	0.25	0.2478	0.2482	164972720.0
2010-08-25 16:00:00	NVDA	Stock	0.248	0.2493	0.2452	0.2475	16492840.0
2010-08-25 17:00:00	NVDA	Stock	0.2478	0.2478	0.2475	0.2475	40000.0
2010-08-25 18:00:00	NVDA	Stock	0.2475	0.2475	0.2475	0.2475	44000.0
2010-08-25 19:00:00	NVDA	Stock	0.2465	0.2465	0.2465	0.2465	6000.0
2010-08-25 08:00:00	AMZN	Stock	6.22	6.22	6.1605	6.1605	129280.0
2010-08-25 09:00:00	AMZN	Stock	6.1665	6.26	6.163	6.247	12442620.0
2010-08-25 10:00:00	AMZN	Stock	6.247	6.291	6.2225	6.2745	22075980.0
2010-08-25 11:00:00	AMZN	Stock	6.2735	6.3048	6.257	6.2835	13368000.0
2010-08-25 12:00:00	AMZN	Stock	6.282	6.2945	6.262	6.2675	8425160.0
2010-08-25 13:00:00	AMZN	Stock	6.2665	6.304	6.2605	6.286	7122080.0
2010-08-25 14:00:00	AMZN	Stock	6.2872	6.3545	6.2815	6.3525	16763340.0
2010-08-25 15:00:00	AMZN	Stock	6.3525	6.3685	6.3275	6.342	21798700.0
2010-08-25 16:00:00	AMZN	Stock	6.3425	6.365	6.2835	6.354	771860.0
2010-08-25 17:00:00	AMZN	Stock	6.345	6.345	6.3425	6.3425	17000.0

> showing 50 of 44,788 rows — these rows as CSV

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