PREVIEW / stock_1hour / 2009-09-09

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-09-09.parquet
  size:    874 KB
  rows:    41,598
  symbols: 3,366

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-09-09 05:00:00	AAPL	Stock	6.1946	6.1946	6.1946	6.1946	2800.0
2009-09-09 07:00:00	AAPL	Stock	6.1939	6.1943	6.1714	6.1718	61320.0
2009-09-09 08:00:00	AAPL	Stock	6.175	6.1775	6.155	6.1693	859852.0
2009-09-09 09:00:00	AAPL	Stock	6.1689	6.1829	6.1254	6.1657	57033844.0
2009-09-09 10:00:00	AAPL	Stock	6.1657	6.1839	6.1511	6.1586	45930444.0
2009-09-09 11:00:00	AAPL	Stock	6.1589	6.1964	6.1543	6.1914	54237708.0
2009-09-09 12:00:00	AAPL	Stock	6.1918	6.2311	6.1871	6.2257	88434920.0
2009-09-09 13:00:00	AAPL	Stock	6.2257	6.2275	6.1614	6.1746	163759876.0
2009-09-09 14:00:00	AAPL	Stock	6.176	6.2232	6.0607	6.0925	251107444.0
2009-09-09 15:00:00	AAPL	Stock	6.0932	6.135	6.0923	6.1086	137160100.0
2009-09-09 16:00:00	AAPL	Stock	6.1121	6.1214	6.1067	6.1107	10367840.0
2009-09-09 17:00:00	AAPL	Stock	6.1161	6.1179	6.1007	6.1061	600796.0
2009-09-09 18:00:00	AAPL	Stock	6.1121	6.1121	6.1054	6.1071	308392.0
2009-09-09 19:00:00	AAPL	Stock	6.11	6.11	6.1032	6.1032	171864.0
2009-09-09 20:00:00	AAPL	Stock	6.1939	6.1939	6.1939	6.1939	15232.0
2009-09-09 07:00:00	MSFT	Stock	24.9	24.9	24.77	24.77	1500.0
2009-09-09 08:00:00	MSFT	Stock	24.8	24.82	24.77	24.82	2450.0
2009-09-09 09:00:00	MSFT	Stock	24.8	24.92	24.7	24.81	4869420.0
2009-09-09 10:00:00	MSFT	Stock	24.81	24.88	24.77	24.8	5668947.0
2009-09-09 11:00:00	MSFT	Stock	24.8	24.95	24.79	24.941	9090899.0
2009-09-09 12:00:00	MSFT	Stock	24.95	24.95	24.82	24.89	5251175.0
2009-09-09 13:00:00	MSFT	Stock	24.892	24.91	24.81	24.84	6195446.0
2009-09-09 14:00:00	MSFT	Stock	24.84	24.86	24.665	24.72	6583513.0
2009-09-09 15:00:00	MSFT	Stock	24.72	24.84	24.7	24.79	9690109.0
2009-09-09 16:00:00	MSFT	Stock	24.79	24.83	24.768	24.78	1936967.0
2009-09-09 17:00:00	MSFT	Stock	24.8	24.8	24.625	24.75	63629.0
2009-09-09 18:00:00	MSFT	Stock	24.8	24.81	24.8	24.81	1000.0
2009-09-09 08:00:00	NVDA	Stock	0.3888	0.3888	0.3875	0.3875	18000.0
2009-09-09 09:00:00	NVDA	Stock	0.3875	0.392	0.382	0.3902	62531200.0
2009-09-09 10:00:00	NVDA	Stock	0.3902	0.3955	0.39	0.394	104448440.0
2009-09-09 11:00:00	NVDA	Stock	0.3942	0.3965	0.3922	0.3953	68772560.0
2009-09-09 12:00:00	NVDA	Stock	0.3953	0.3958	0.3928	0.394	39781160.0
2009-09-09 13:00:00	NVDA	Stock	0.3942	0.3958	0.3928	0.3948	44675400.0
2009-09-09 14:00:00	NVDA	Stock	0.3948	0.3955	0.3913	0.3945	86432120.0
2009-09-09 15:00:00	NVDA	Stock	0.3945	0.3998	0.3938	0.399	145096680.0
2009-09-09 16:00:00	NVDA	Stock	0.399	0.3998	0.3942	0.3968	7480800.0
2009-09-09 17:00:00	NVDA	Stock	0.399	0.399	0.399	0.399	30000.0
2009-09-09 18:00:00	NVDA	Stock	0.4	0.4048	0.399	0.4048	279600.0
2009-09-09 19:00:00	NVDA	Stock	0.4025	0.4025	0.4025	0.4025	4000.0
2009-09-09 04:00:00	AMZN	Stock	4.035	4.035	4.035	4.035	10000.0
2009-09-09 05:00:00	AMZN	Stock	4.04	4.04	4.04	4.04	5400.0
2009-09-09 07:00:00	AMZN	Stock	4.0545	4.0545	4.0545	4.0545	2000.0
2009-09-09 08:00:00	AMZN	Stock	4.0445	4.045	4.0345	4.04	132040.0
2009-09-09 09:00:00	AMZN	Stock	4.0385	4.071	4.025	4.0525	13248940.0
2009-09-09 10:00:00	AMZN	Stock	4.0525	4.0665	4.0375	4.038	16893000.0
2009-09-09 11:00:00	AMZN	Stock	4.0385	4.065	4.0345	4.06	19728240.0
2009-09-09 12:00:00	AMZN	Stock	4.0595	4.0935	4.0595	4.093	9116340.0
2009-09-09 13:00:00	AMZN	Stock	4.0935	4.129	4.089	4.109	24743200.0
2009-09-09 14:00:00	AMZN	Stock	4.109	4.1105	4.0875	4.1	18522500.0
2009-09-09 15:00:00	AMZN	Stock	4.1	4.1315	4.097	4.114	30432500.0

> showing 50 of 41,598 rows — these rows as CSV

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