PREVIEW / stock_1hour / 2007-07-25

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-07-25.parquet
  size:    775 KB
  rows:    37,654
  symbols: 3,090

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-07-25 09:00:00	AAPL	Stock	4.9054	4.9084	4.8214	4.8746	185702188.0
2007-07-25 10:00:00	AAPL	Stock	4.8746	4.9196	4.8571	4.8746	196420588.0
2007-07-25 11:00:00	AAPL	Stock	4.8736	4.8836	4.86	4.8725	112473312.0
2007-07-25 12:00:00	AAPL	Stock	4.8725	4.925	4.8714	4.9021	104801676.0
2007-07-25 13:00:00	AAPL	Stock	4.9021	4.9082	4.8675	4.8718	92608404.0
2007-07-25 14:00:00	AAPL	Stock	4.8714	4.9214	4.8604	4.8996	124861156.0
2007-07-25 15:00:00	AAPL	Stock	4.8993	4.9414	4.8839	4.9011	241708992.0
2007-07-25 16:00:00	AAPL	Stock	4.8971	4.9021	4.8936	4.9021	7030996.0
2007-07-25 09:00:00	MSFT	Stock	30.99	31.3	30.85	30.89	3898059.0
2007-07-25 10:00:00	MSFT	Stock	30.88	30.88	30.51	30.7	10205965.0
2007-07-25 11:00:00	MSFT	Stock	30.7	30.8	30.59	30.73	6294643.0
2007-07-25 12:00:00	MSFT	Stock	30.73	30.76	30.55	30.61	4408704.0
2007-07-25 13:00:00	MSFT	Stock	30.61	30.67	30.43	30.45	7650979.0
2007-07-25 14:00:00	MSFT	Stock	30.458	30.641	30.37	30.461	8646822.0
2007-07-25 15:00:00	MSFT	Stock	30.46	30.76	30.46	30.69	9599420.0
2007-07-25 16:00:00	MSFT	Stock	30.69	30.71	30.69	30.71	1264578.0
2007-07-25 08:00:00	NVDA	Stock	0.7433	0.744	0.7433	0.744	137760.0
2007-07-25 09:00:00	NVDA	Stock	0.744	0.7498	0.7393	0.7468	29493360.0
2007-07-25 10:00:00	NVDA	Stock	0.7465	0.7475	0.7187	0.7293	135436680.0
2007-07-25 11:00:00	NVDA	Stock	0.7292	0.7358	0.7273	0.732	46599240.0
2007-07-25 12:00:00	NVDA	Stock	0.7318	0.7365	0.729	0.7358	34442220.0
2007-07-25 13:00:00	NVDA	Stock	0.736	0.7365	0.7268	0.727	55457940.0
2007-07-25 14:00:00	NVDA	Stock	0.727	0.733	0.7263	0.7312	47212200.0
2007-07-25 15:00:00	NVDA	Stock	0.731	0.7467	0.7307	0.735	72024780.0
2007-07-25 16:00:00	NVDA	Stock	0.7357	0.7357	0.7338	0.7338	11815980.0
2007-07-25 17:00:00	NVDA	Stock	0.7352	0.7357	0.735	0.7357	214200.0
2007-07-25 18:00:00	NVDA	Stock	0.7357	0.7367	0.7357	0.736	448680.0
2007-07-25 19:00:00	NVDA	Stock	0.736	0.7375	0.736	0.7375	18840.0
2007-07-25 05:00:00	AMZN	Stock	4.1985	4.2	4.1985	4.2	131620.0
2007-07-25 06:00:00	AMZN	Stock	4.2	4.2765	4.17	4.25	580580.0
2007-07-25 07:00:00	AMZN	Stock	4.2675	4.417	4.2505	4.295	17354100.0
2007-07-25 08:00:00	AMZN	Stock	4.296	4.3445	4.215	4.275	59048020.0
2007-07-25 09:00:00	AMZN	Stock	4.277	4.44	4.1825	4.3692	329813240.0
2007-07-25 10:00:00	AMZN	Stock	4.3694	4.4375	4.2315	4.271	309442500.0
2007-07-25 11:00:00	AMZN	Stock	4.2854	4.334	4.245	4.293	122070820.0
2007-07-25 12:00:00	AMZN	Stock	4.292	4.38	4.285	4.357	85585900.0
2007-07-25 13:00:00	AMZN	Stock	4.358	4.364	4.297	4.313	67969960.0
2007-07-25 14:00:00	AMZN	Stock	4.3125	4.3555	4.28	4.306	89885880.0
2007-07-25 15:00:00	AMZN	Stock	4.3055	4.3255	4.2755	4.307	109912920.0
2007-07-25 16:00:00	AMZN	Stock	4.307	4.31	4.285	4.291	10558420.0
2007-07-25 17:00:00	AMZN	Stock	4.2925	4.37	4.292	4.3475	1434640.0
2007-07-25 18:00:00	AMZN	Stock	4.345	4.3645	4.331	4.345	539480.0
2007-07-25 19:00:00	AMZN	Stock	4.34	4.3635	4.335	4.3635	172720.0
2007-07-25 09:00:00	TLT	Stock	86.07	86.16	86.05	86.13	80700.0
2007-07-25 10:00:00	TLT	Stock	86.15	86.38	86.0	86.21	265500.0
2007-07-25 11:00:00	TLT	Stock	86.23	86.36	86.17	86.26	256868.0
2007-07-25 12:00:00	TLT	Stock	86.26	86.32	86.22	86.24	104000.0
2007-07-25 13:00:00	TLT	Stock	86.24	86.39	86.24	86.29	73000.0
2007-07-25 14:00:00	TLT	Stock	86.29	86.34	86.16	86.3	27400.0
2007-07-25 15:00:00	TLT	Stock	86.28	86.31	86.2	86.3	64300.0

> showing 50 of 37,654 rows — these rows as CSV

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