PREVIEW / stock_1hour / 2010-07-28

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-07-28.parquet
  size:    882 KB
  rows:    42,387
  symbols: 3,445

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-07-28 05:00:00	AAPL	Stock	9.4489	9.4489	9.4489	9.4489	2800.0
2010-07-28 07:00:00	AAPL	Stock	9.4071	9.4464	9.3993	9.4461	253988.0
2010-07-28 08:00:00	AAPL	Stock	9.4457	9.4536	9.4	9.425	3930136.0
2010-07-28 09:00:00	AAPL	Stock	9.425	9.4916	9.4089	9.4896	96169948.0
2010-07-28 10:00:00	AAPL	Stock	9.4889	9.4996	9.4139	9.4282	95712736.0
2010-07-28 11:00:00	AAPL	Stock	9.4265	9.435	9.3786	9.3907	60010552.0
2010-07-28 12:00:00	AAPL	Stock	9.3907	9.4071	9.3604	9.3779	39190396.0
2010-07-28 13:00:00	AAPL	Stock	9.3796	9.3875	9.3	9.3179	69101872.0
2010-07-28 14:00:00	AAPL	Stock	9.3179	9.3463	9.3	9.317	64648612.0
2010-07-28 15:00:00	AAPL	Stock	9.3232	9.3421	9.2946	9.3207	70156940.0
2010-07-28 16:00:00	AAPL	Stock	9.3243	9.4349	9.2857	9.2975	14768040.0
2010-07-28 17:00:00	AAPL	Stock	9.426	9.426	9.2768	9.2893	858284.0
2010-07-28 18:00:00	AAPL	Stock	9.2929	9.32	9.2929	9.3036	393008.0
2010-07-28 19:00:00	AAPL	Stock	9.3064	9.3071	9.2861	9.2961	244860.0
2010-07-28 07:00:00	MSFT	Stock	26.1	26.1	26.1	26.1	300.0
2010-07-28 08:00:00	MSFT	Stock	26.21	26.26	26.0	26.03	41938.0
2010-07-28 09:00:00	MSFT	Stock	26.07	26.14	26.02	26.04	4141993.0
2010-07-28 10:00:00	MSFT	Stock	26.04	26.06	25.83	25.88	10773181.0
2010-07-28 11:00:00	MSFT	Stock	25.88	26.06	25.84	26.05	9481972.0
2010-07-28 12:00:00	MSFT	Stock	26.05	26.15	26.0	26.145	5328077.0
2010-07-28 13:00:00	MSFT	Stock	26.145	26.19	25.95	26.02	6413487.0
2010-07-28 14:00:00	MSFT	Stock	26.011	26.08	25.95	25.98	5660290.0
2010-07-28 15:00:00	MSFT	Stock	25.98	26.02	25.87	25.95	14330362.0
2010-07-28 16:00:00	MSFT	Stock	25.948	26.03	25.89	26.03	12973533.0
2010-07-28 17:00:00	MSFT	Stock	26.042	26.042	25.95	25.95	7463.0
2010-07-28 18:00:00	MSFT	Stock	25.97	25.97	25.95	25.97	11185.0
2010-07-28 19:00:00	MSFT	Stock	25.95	25.98	25.95	25.98	4454.0
2010-07-28 05:00:00	NVDA	Stock	0.259	0.259	0.2575	0.2575	21000.0
2010-07-28 07:00:00	NVDA	Stock	0.26	0.26	0.2568	0.2568	300000.0
2010-07-28 08:00:00	NVDA	Stock	0.262	0.262	0.2563	0.2565	10498120.0
2010-07-28 09:00:00	NVDA	Stock	0.2563	0.26	0.254	0.26	247148840.0
2010-07-28 10:00:00	NVDA	Stock	0.26	0.2618	0.2563	0.2594	234737120.0
2010-07-28 11:00:00	NVDA	Stock	0.2592	0.2598	0.2555	0.2564	121002760.0
2010-07-28 12:00:00	NVDA	Stock	0.2565	0.2572	0.255	0.257	115117320.0
2010-07-28 13:00:00	NVDA	Stock	0.257	0.257	0.2545	0.2547	54882120.0
2010-07-28 14:00:00	NVDA	Stock	0.2547	0.2558	0.2538	0.254	124710760.0
2010-07-28 15:00:00	NVDA	Stock	0.2539	0.2543	0.2525	0.253	231654040.0
2010-07-28 16:00:00	NVDA	Stock	0.2533	0.2561	0.2368	0.237	124387080.0
2010-07-28 17:00:00	NVDA	Stock	0.237	0.2382	0.2352	0.2358	31982080.0
2010-07-28 18:00:00	NVDA	Stock	0.2365	0.2375	0.2355	0.2362	4074800.0
2010-07-28 19:00:00	NVDA	Stock	0.2362	0.2368	0.2352	0.236	3950400.0
2010-07-28 08:00:00	AMZN	Stock	5.8455	5.88	5.8375	5.8445	491300.0
2010-07-28 09:00:00	AMZN	Stock	5.8365	5.91	5.825	5.903	17436100.0
2010-07-28 10:00:00	AMZN	Stock	5.902	5.902	5.84	5.8615	19548540.0
2010-07-28 11:00:00	AMZN	Stock	5.86	5.8635	5.835	5.8541	12473240.0
2010-07-28 12:00:00	AMZN	Stock	5.8542	5.889	5.843	5.8512	10469180.0
2010-07-28 13:00:00	AMZN	Stock	5.8515	5.8635	5.8355	5.848	11067780.0
2010-07-28 14:00:00	AMZN	Stock	5.849	5.8625	5.8325	5.839	11274880.0
2010-07-28 15:00:00	AMZN	Stock	5.838	5.869	5.82	5.859	22901880.0
2010-07-28 16:00:00	AMZN	Stock	5.8695	5.8765	5.8278	5.8475	688800.0

> showing 50 of 42,387 rows — these rows as CSV

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