PREVIEW / stock_1hour / 2007-05-09

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-05-09.parquet
  size:    713 KB
  rows:    34,287
  symbols: 2,734

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
2007-05-09 09:00:00	AAPL	Stock	3.7468	3.7779	3.7461	3.7714	98092848.0
2007-05-09 10:00:00	AAPL	Stock	3.7714	3.7943	3.7696	3.78	120584100.0
2007-05-09 11:00:00	AAPL	Stock	3.78	3.7857	3.7614	3.7621	65509584.0
2007-05-09 12:00:00	AAPL	Stock	3.7621	3.7779	3.7604	3.7732	44523192.0
2007-05-09 13:00:00	AAPL	Stock	3.7732	3.7762	3.7661	3.7668	31043432.0
2007-05-09 14:00:00	AAPL	Stock	3.7668	3.8025	3.7607	3.7975	125779052.0
2007-05-09 15:00:00	AAPL	Stock	3.7978	3.8196	3.7804	3.8196	170119432.0
2007-05-09 16:00:00	AAPL	Stock	3.82	3.82	3.8171	3.8171	2452044.0
2007-05-09 09:00:00	MSFT	Stock	30.7	30.93	30.57	30.7	4194451.0
2007-05-09 10:00:00	MSFT	Stock	30.7	30.84	30.7	30.71	5516615.0
2007-05-09 11:00:00	MSFT	Stock	30.71	30.83	30.7	30.77	5102814.0
2007-05-09 12:00:00	MSFT	Stock	30.78	30.83	30.72	30.8	3952984.0
2007-05-09 13:00:00	MSFT	Stock	30.8	30.82	30.73	30.75	4455752.0
2007-05-09 14:00:00	MSFT	Stock	30.75	30.92	30.7	30.9	11497693.0
2007-05-09 15:00:00	MSFT	Stock	30.91	30.93	30.77	30.77	11633043.0
2007-05-09 16:00:00	MSFT	Stock	30.78	30.79	30.78	30.78	621112.0
2007-05-09 08:00:00	NVDA	Stock	0.5483	0.5483	0.5483	0.5483	6000.0
2007-05-09 09:00:00	NVDA	Stock	0.5495	0.5515	0.5445	0.5487	48683640.0
2007-05-09 10:00:00	NVDA	Stock	0.5487	0.5542	0.5472	0.549	61775280.0
2007-05-09 11:00:00	NVDA	Stock	0.549	0.5537	0.5482	0.5508	54242220.0
2007-05-09 12:00:00	NVDA	Stock	0.5507	0.557	0.5507	0.556	30375480.0
2007-05-09 13:00:00	NVDA	Stock	0.556	0.5567	0.5527	0.5545	22953480.0
2007-05-09 14:00:00	NVDA	Stock	0.5547	0.56	0.5508	0.5588	68169300.0
2007-05-09 15:00:00	NVDA	Stock	0.5588	0.5605	0.5573	0.5578	107465580.0
2007-05-09 16:00:00	NVDA	Stock	0.5573	0.5647	0.5573	0.5607	7959180.0
2007-05-09 17:00:00	NVDA	Stock	0.56	0.5627	0.56	0.5608	300000.0
2007-05-09 18:00:00	NVDA	Stock	0.5623	0.5625	0.5608	0.561	512340.0
2007-05-09 19:00:00	NVDA	Stock	0.5617	0.5617	0.561	0.561	193800.0
2007-05-09 05:00:00	AMZN	Stock	3.0755	3.0845	3.0755	3.0845	6000.0
2007-05-09 06:00:00	AMZN	Stock	3.0915	3.1	3.0915	3.093	31540.0
2007-05-09 07:00:00	AMZN	Stock	3.1165	3.125	3.106	3.1115	176000.0
2007-05-09 08:00:00	AMZN	Stock	3.1055	3.1095	3.09	3.0975	1086560.0
2007-05-09 09:00:00	AMZN	Stock	3.099	3.108	3.065	3.0705	20253300.0
2007-05-09 10:00:00	AMZN	Stock	3.071	3.0945	3.07	3.084	28968660.0
2007-05-09 11:00:00	AMZN	Stock	3.0845	3.099	3.0835	3.091	14478460.0
2007-05-09 12:00:00	AMZN	Stock	3.091	3.1165	3.0885	3.1065	15749540.0
2007-05-09 13:00:00	AMZN	Stock	3.1065	3.114	3.0925	3.0955	11185400.0
2007-05-09 14:00:00	AMZN	Stock	3.0965	3.1225	3.081	3.1185	34907360.0
2007-05-09 15:00:00	AMZN	Stock	3.118	3.1475	3.1135	3.1425	46528720.0
2007-05-09 16:00:00	AMZN	Stock	3.143	3.1475	3.142	3.146	2964360.0
2007-05-09 17:00:00	AMZN	Stock	3.145	3.1475	3.143	3.1475	212340.0
2007-05-09 18:00:00	AMZN	Stock	3.1475	3.1495	3.1425	3.1475	55000.0
2007-05-09 19:00:00	AMZN	Stock	3.145	3.1475	3.145	3.147	59000.0
2007-05-09 09:00:00	TLT	Stock	88.65	88.66	88.59	88.59	17900.0
2007-05-09 10:00:00	TLT	Stock	88.61	88.61	88.54	88.61	58400.0
2007-05-09 11:00:00	TLT	Stock	88.6	88.61	88.56	88.57	54500.0
2007-05-09 12:00:00	TLT	Stock	88.57	88.62	88.57	88.61	15300.0
2007-05-09 13:00:00	TLT	Stock	88.6	88.64	88.6	88.61	57500.0
2007-05-09 14:00:00	TLT	Stock	88.6	88.61	88.26	88.3	284100.0
2007-05-09 15:00:00	TLT	Stock	88.32	88.37	88.29	88.34	137900.0

> showing 50 of 34,287 rows — these rows as CSV

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