PREVIEW / stock_1hour / 2009-06-03

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-06-03.parquet
  size:    852 KB
  rows:    41,590
  symbols: 3,347

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-06-03 04:00:00	AAPL	Stock	4.9818	4.9996	4.9818	4.9925	30800.0
2009-06-03 05:00:00	AAPL	Stock	4.9818	4.9818	4.9818	4.9818	25200.0
2009-06-03 07:00:00	AAPL	Stock	4.9836	5.0089	4.9743	5.0036	877576.0
2009-06-03 08:00:00	AAPL	Stock	5.0036	5.0129	4.9818	4.9971	3099964.0
2009-06-03 09:00:00	AAPL	Stock	4.9971	5.0354	4.9929	5.0171	96024740.0
2009-06-03 10:00:00	AAPL	Stock	5.0168	5.0182	4.9668	5.0154	102707024.0
2009-06-03 11:00:00	AAPL	Stock	5.0154	5.0264	4.9904	5.0228	64367212.0
2009-06-03 12:00:00	AAPL	Stock	5.0225	5.0271	4.9907	4.9946	45439128.0
2009-06-03 13:00:00	AAPL	Stock	4.9946	5.0118	4.9918	5.0089	49924896.0
2009-06-03 14:00:00	AAPL	Stock	5.0089	5.0196	4.9929	5.0075	69014008.0
2009-06-03 15:00:00	AAPL	Stock	5.0075	5.0396	4.9932	5.0368	102469136.0
2009-06-03 16:00:00	AAPL	Stock	5.0361	5.0414	5.0087	5.0396	21657692.0
2009-06-03 17:00:00	AAPL	Stock	5.0364	5.0396	5.0321	5.0393	283136.0
2009-06-03 18:00:00	AAPL	Stock	5.0339	5.0414	5.0339	5.0343	2352840.0
2009-06-03 19:00:00	AAPL	Stock	5.0357	5.0357	5.0318	5.0357	217168.0
2009-06-03 06:00:00	MSFT	Stock	21.4	21.4	21.4	21.4	100.0
2009-06-03 08:00:00	MSFT	Stock	21.4	21.4	21.24	21.25	182240.0
2009-06-03 09:00:00	MSFT	Stock	21.25	21.65	21.25	21.48	5787773.0
2009-06-03 10:00:00	MSFT	Stock	21.48	21.675	21.42	21.67	7276780.0
2009-06-03 11:00:00	MSFT	Stock	21.67	21.69	21.58	21.61	4878187.0
2009-06-03 12:00:00	MSFT	Stock	21.61	21.61	21.43	21.45	3673311.0
2009-06-03 13:00:00	MSFT	Stock	21.46	21.46	21.29	21.44	5260356.0
2009-06-03 14:00:00	MSFT	Stock	21.44	21.57	21.38	21.54	5227201.0
2009-06-03 15:00:00	MSFT	Stock	21.55	21.76	21.47	21.74	11931871.0
2009-06-03 16:00:00	MSFT	Stock	21.74	21.77	21.538	21.75	10557278.0
2009-06-03 17:00:00	MSFT	Stock	21.75	21.85	21.74	21.85	139941.0
2009-06-03 18:00:00	MSFT	Stock	21.73	21.82	21.73	21.82	84338.0
2009-06-03 19:00:00	MSFT	Stock	21.8	21.82	21.79	21.82	5915.0
2009-06-03 08:00:00	NVDA	Stock	0.268	0.268	0.268	0.268	40000.0
2009-06-03 09:00:00	NVDA	Stock	0.27	0.27	0.2563	0.26	120422160.0
2009-06-03 10:00:00	NVDA	Stock	0.2603	0.2603	0.2565	0.259	143948880.0
2009-06-03 11:00:00	NVDA	Stock	0.259	0.262	0.2588	0.2605	108703400.0
2009-06-03 12:00:00	NVDA	Stock	0.2605	0.2612	0.258	0.2583	67020560.0
2009-06-03 13:00:00	NVDA	Stock	0.258	0.2595	0.2575	0.2595	47868920.0
2009-06-03 14:00:00	NVDA	Stock	0.2595	0.2615	0.2583	0.2615	94756560.0
2009-06-03 15:00:00	NVDA	Stock	0.2612	0.2628	0.2598	0.2628	129190440.0
2009-06-03 16:00:00	NVDA	Stock	0.2628	0.2628	0.2597	0.2628	12525760.0
2009-06-03 07:00:00	AMZN	Stock	4.246	4.2465	4.2155	4.2155	12000.0
2009-06-03 08:00:00	AMZN	Stock	4.2375	4.2375	4.2	4.21	83900.0
2009-06-03 09:00:00	AMZN	Stock	4.21	4.2377	4.1565	4.219	23875220.0
2009-06-03 10:00:00	AMZN	Stock	4.2155	4.248	4.197	4.2455	23879900.0
2009-06-03 11:00:00	AMZN	Stock	4.2455	4.2705	4.223	4.254	17199140.0
2009-06-03 12:00:00	AMZN	Stock	4.255	4.2685	4.2262	4.2282	11604640.0
2009-06-03 13:00:00	AMZN	Stock	4.227	4.2295	4.1845	4.206	16292400.0
2009-06-03 14:00:00	AMZN	Stock	4.2074	4.236	4.1889	4.2305	16304100.0
2009-06-03 15:00:00	AMZN	Stock	4.2305	4.2855	4.2205	4.285	32874460.0
2009-06-03 16:00:00	AMZN	Stock	4.2855	4.2975	4.2268	4.29	2472680.0
2009-06-03 17:00:00	AMZN	Stock	4.2865	4.291	4.285	4.285	38500.0
2009-06-03 18:00:00	AMZN	Stock	4.2865	4.2865	4.2755	4.2865	14500.0
2009-06-03 19:00:00	AMZN	Stock	4.2825	4.283	4.281	4.2825	18680.0

> showing 50 of 41,590 rows — these rows as CSV

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