PREVIEW / stock_1hour / 2009-06-18

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-06-18.parquet
  size:    827 KB
  rows:    40,588
  symbols: 3,341

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-18 07:00:00	AAPL	Stock	4.8454	4.8454	4.8368	4.8389	53200.0
2009-06-18 08:00:00	AAPL	Stock	4.8393	4.8661	4.8296	4.8661	631176.0
2009-06-18 09:00:00	AAPL	Stock	4.8639	4.9286	4.8425	4.9211	97519156.0
2009-06-18 10:00:00	AAPL	Stock	4.9211	4.9275	4.8829	4.9047	69960016.0
2009-06-18 11:00:00	AAPL	Stock	4.9061	4.9132	4.8868	4.9004	36906184.0
2009-06-18 12:00:00	AAPL	Stock	4.9004	4.9114	4.8886	4.9107	30707404.0
2009-06-18 13:00:00	AAPL	Stock	4.9114	4.9254	4.9054	4.9104	38988768.0
2009-06-18 14:00:00	AAPL	Stock	4.9107	4.9136	4.8936	4.9025	36035104.0
2009-06-18 15:00:00	AAPL	Stock	4.9025	4.905	4.8539	4.8539	80766644.0
2009-06-18 16:00:00	AAPL	Stock	4.8554	4.9111	4.8286	4.85	31506440.0
2009-06-18 17:00:00	AAPL	Stock	4.8496	4.8907	4.8393	4.8821	2144828.0
2009-06-18 18:00:00	AAPL	Stock	4.8839	4.8907	4.8529	4.8886	1220212.0
2009-06-18 19:00:00	AAPL	Stock	4.8886	4.8946	4.8861	4.8929	334180.0
2009-06-18 07:00:00	MSFT	Stock	23.71	23.73	23.55	23.73	650.0
2009-06-18 08:00:00	MSFT	Stock	23.68	23.7	23.6	23.67	18339.0
2009-06-18 09:00:00	MSFT	Stock	23.59	23.68	23.34	23.42	6684568.0
2009-06-18 10:00:00	MSFT	Stock	23.42	23.69	23.34	23.38	13879112.0
2009-06-18 11:00:00	MSFT	Stock	23.39	23.43	23.3	23.35	7354882.0
2009-06-18 12:00:00	MSFT	Stock	23.35	23.55	23.33	23.54	4095922.0
2009-06-18 13:00:00	MSFT	Stock	23.55	23.57	23.44	23.45	4166600.0
2009-06-18 14:00:00	MSFT	Stock	23.45	23.56	23.4	23.518	5447821.0
2009-06-18 15:00:00	MSFT	Stock	23.51	23.65	23.47	23.5	13526367.0
2009-06-18 16:00:00	MSFT	Stock	23.5	23.68	23.38	23.51	2201810.0
2009-06-18 17:00:00	MSFT	Stock	23.51	23.59	23.5	23.5	111059.0
2009-06-18 18:00:00	MSFT	Stock	23.57	23.62	23.57	23.62	2596.0
2009-06-18 19:00:00	MSFT	Stock	23.59	23.68	23.59	23.65	23803.0
2009-06-18 08:00:00	NVDA	Stock	0.2792	0.28	0.2792	0.28	40000.0
2009-06-18 09:00:00	NVDA	Stock	0.281	0.2855	0.2788	0.2852	82467720.0
2009-06-18 10:00:00	NVDA	Stock	0.2852	0.2862	0.2768	0.2788	113672880.0
2009-06-18 11:00:00	NVDA	Stock	0.2788	0.2811	0.2785	0.281	37513120.0
2009-06-18 12:00:00	NVDA	Stock	0.281	0.281	0.2785	0.2805	39771720.0
2009-06-18 13:00:00	NVDA	Stock	0.2808	0.2811	0.2775	0.2775	44891200.0
2009-06-18 14:00:00	NVDA	Stock	0.2775	0.2788	0.2734	0.2755	107463040.0
2009-06-18 15:00:00	NVDA	Stock	0.2758	0.2768	0.275	0.2765	122703400.0
2009-06-18 16:00:00	NVDA	Stock	0.2765	0.282	0.275	0.2752	15746120.0
2009-06-18 17:00:00	NVDA	Stock	0.2752	0.2765	0.2752	0.2765	44040.0
2009-06-18 18:00:00	NVDA	Stock	0.2763	0.2765	0.2763	0.2765	124000.0
2009-06-18 19:00:00	NVDA	Stock	0.2758	0.2758	0.2758	0.2758	40000.0
2009-06-18 08:00:00	AMZN	Stock	4.134	4.164	4.131	4.14	62100.0
2009-06-18 09:00:00	AMZN	Stock	4.145	4.1475	4.0795	4.1145	16554240.0
2009-06-18 10:00:00	AMZN	Stock	4.1155	4.1405	4.05	4.056	22393280.0
2009-06-18 11:00:00	AMZN	Stock	4.0555	4.0935	4.055	4.0802	13399480.0
2009-06-18 12:00:00	AMZN	Stock	4.081	4.12	4.078	4.117	6674100.0
2009-06-18 13:00:00	AMZN	Stock	4.1175	4.133	4.1045	4.1225	7332080.0
2009-06-18 14:00:00	AMZN	Stock	4.1225	4.129	4.088	4.1045	11906840.0
2009-06-18 15:00:00	AMZN	Stock	4.104	4.108	4.0705	4.08	23560680.0
2009-06-18 16:00:00	AMZN	Stock	4.0815	4.1325	4.06	4.0795	1846700.0
2009-06-18 17:00:00	AMZN	Stock	4.075	4.09	4.075	4.09	25420.0
2009-06-18 18:00:00	AMZN	Stock	4.095	4.095	4.0925	4.0925	22000.0
2009-06-18 08:00:00	TLT	Stock	91.5	91.6	91.1	91.21	19233.0

> showing 50 of 40,588 rows — these rows as CSV

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