PREVIEW / stock_1hour / 2007-07-24

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-07-24.parquet
  size:    775 KB
  rows:    37,554
  symbols: 3,086

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-24 09:00:00	AAPL	Stock	4.96	4.9811	4.8768	4.9379	321008324.0
2007-07-24 10:00:00	AAPL	Stock	4.9368	5.0179	4.9311	5.0129	245963956.0
2007-07-24 11:00:00	AAPL	Stock	5.0136	5.0246	4.9814	4.9957	170682904.0
2007-07-24 12:00:00	AAPL	Stock	4.995	5.0061	4.9789	4.9979	102379536.0
2007-07-24 13:00:00	AAPL	Stock	4.9979	5.0357	4.9718	4.9825	140055356.0
2007-07-24 14:00:00	AAPL	Stock	4.9825	4.9886	4.9271	4.9311	202438264.0
2007-07-24 15:00:00	AAPL	Stock	4.9311	4.9339	4.7911	4.8211	423435544.0
2007-07-24 16:00:00	AAPL	Stock	4.8214	4.8214	4.8143	4.8175	18862144.0
2007-07-24 09:00:00	MSFT	Stock	31.01	31.23	31.0	31.175	4816731.0
2007-07-24 10:00:00	MSFT	Stock	31.17	31.27	30.96	31.24	5829272.0
2007-07-24 11:00:00	MSFT	Stock	31.24	31.29	31.15	31.29	5312310.0
2007-07-24 12:00:00	MSFT	Stock	31.29	31.48	31.28	31.32	5292302.0
2007-07-24 13:00:00	MSFT	Stock	31.32	31.38	31.13	31.17	6829896.0
2007-07-24 14:00:00	MSFT	Stock	31.16	31.17	30.99	31.002	7374787.0
2007-07-24 15:00:00	MSFT	Stock	31.01	31.01	30.71	30.79	16255992.0
2007-07-24 16:00:00	MSFT	Stock	30.81	30.81	30.78	30.8	2527901.0
2007-07-24 08:00:00	NVDA	Stock	0.7575	0.7575	0.7492	0.7525	503400.0
2007-07-24 09:00:00	NVDA	Stock	0.7532	0.7603	0.749	0.757	41962560.0
2007-07-24 10:00:00	NVDA	Stock	0.7572	0.759	0.7497	0.757	64971600.0
2007-07-24 11:00:00	NVDA	Stock	0.7572	0.7577	0.7485	0.7555	53555820.0
2007-07-24 12:00:00	NVDA	Stock	0.7555	0.7625	0.7513	0.7577	43844220.0
2007-07-24 13:00:00	NVDA	Stock	0.7577	0.759	0.751	0.7513	41909520.0
2007-07-24 14:00:00	NVDA	Stock	0.7513	0.7528	0.743	0.7435	65460840.0
2007-07-24 15:00:00	NVDA	Stock	0.7435	0.7437	0.7345	0.7397	114882180.0
2007-07-24 16:00:00	NVDA	Stock	0.7388	0.7395	0.7382	0.7383	4802940.0
2007-07-24 17:00:00	NVDA	Stock	0.7382	0.7382	0.7382	0.7382	749160.0
2007-07-24 19:00:00	NVDA	Stock	0.74	0.74	0.74	0.74	69960.0
2007-07-24 05:00:00	AMZN	Stock	3.58	3.58	3.57	3.57	14000.0
2007-07-24 07:00:00	AMZN	Stock	3.5995	3.5995	3.5995	3.5995	2000.0
2007-07-24 08:00:00	AMZN	Stock	3.599	3.599	3.5545	3.56	241280.0
2007-07-24 09:00:00	AMZN	Stock	3.5575	3.5915	3.5355	3.5915	30320000.0
2007-07-24 10:00:00	AMZN	Stock	3.5915	3.608	3.569	3.5955	26553760.0
2007-07-24 11:00:00	AMZN	Stock	3.596	3.6	3.5855	3.5955	25524300.0
2007-07-24 12:00:00	AMZN	Stock	3.595	3.598	3.5755	3.589	18283600.0
2007-07-24 13:00:00	AMZN	Stock	3.5895	3.5965	3.5875	3.593	20995360.0
2007-07-24 14:00:00	AMZN	Stock	3.5925	3.5972	3.5365	3.54	43833160.0
2007-07-24 15:00:00	AMZN	Stock	3.5405	3.549	3.4425	3.46	97430920.0
2007-07-24 16:00:00	AMZN	Stock	3.46	3.949	3.4285	3.9165	158454880.0
2007-07-24 17:00:00	AMZN	Stock	3.914	4.145	3.463	4.0875	77875040.0
2007-07-24 18:00:00	AMZN	Stock	4.088	4.2125	4.0505	4.2125	17298900.0
2007-07-24 19:00:00	AMZN	Stock	4.212	4.22	4.175	4.2045	5672180.0
2007-07-24 09:00:00	TLT	Stock	86.01	86.11	85.99	86.04	97600.0
2007-07-24 10:00:00	TLT	Stock	86.03	86.06	85.86	85.91	463100.0
2007-07-24 11:00:00	TLT	Stock	85.93	85.98	85.88	85.89	32700.0
2007-07-24 12:00:00	TLT	Stock	85.88	85.92	85.82	85.89	68175.0
2007-07-24 13:00:00	TLT	Stock	85.9	85.98	85.72	85.81	52700.0
2007-07-24 14:00:00	TLT	Stock	85.8	85.94	85.8	85.92	235400.0
2007-07-24 15:00:00	TLT	Stock	85.92	86.16	85.92	86.13	376700.0
2007-07-24 16:00:00	TLT	Stock	86.13	86.14	86.12	86.14	19500.0
2007-07-24 09:00:00	CL	Stock	34.175	34.62	34.14	34.62	1060356.0

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

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