PREVIEW / stock_30min / 2008-06-16

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-06-16.parquet
  size:    1.2 MB
  rows:    67,924
  symbols: 3,305

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
2008-06-16 04:00:00	AAPL	Stock	6.1786	6.1786	6.1786	6.1786	2800.0
2008-06-16 05:00:00	AAPL	Stock	6.1711	6.1711	6.1429	6.1429	11200.0
2008-06-16 06:00:00	AAPL	Stock	6.1786	6.1786	6.1786	6.1786	2800.0
2008-06-16 07:00:00	AAPL	Stock	6.1893	6.2036	6.1821	6.1907	151200.0
2008-06-16 07:30:00	AAPL	Stock	6.1857	6.1893	6.175	6.1782	394100.0
2008-06-16 08:00:00	AAPL	Stock	6.1782	6.1943	6.1436	6.1511	2245320.0
2008-06-16 08:30:00	AAPL	Stock	6.15	6.1675	6.1193	6.1429	2119992.0
2008-06-16 09:00:00	AAPL	Stock	6.1389	6.1475	6.1125	6.1171	1099196.0
2008-06-16 09:30:00	AAPL	Stock	6.1196	6.1871	6.0664	6.105	134152676.0
2008-06-16 10:00:00	AAPL	Stock	6.1054	6.1346	6.0382	6.0589	97347012.0
2008-06-16 10:30:00	AAPL	Stock	6.0582	6.1779	6.0464	6.1168	89329856.0
2008-06-16 11:00:00	AAPL	Stock	6.1175	6.1707	6.1	6.1211	66084032.0
2008-06-16 11:30:00	AAPL	Stock	6.1214	6.1964	6.1207	6.1779	83675816.0
2008-06-16 12:00:00	AAPL	Stock	6.1779	6.2196	6.1539	6.2196	52925264.0
2008-06-16 12:30:00	AAPL	Stock	6.22	6.2496	6.2171	6.2286	51741872.0
2008-06-16 13:00:00	AAPL	Stock	6.2296	6.2736	6.2107	6.272	53108076.0
2008-06-16 13:30:00	AAPL	Stock	6.2693	6.3536	6.2668	6.335	99629544.0
2008-06-16 14:00:00	AAPL	Stock	6.3361	6.3411	6.2946	6.3043	62792800.0
2008-06-16 14:30:00	AAPL	Stock	6.3032	6.3482	6.2957	6.3457	55125084.0
2008-06-16 15:00:00	AAPL	Stock	6.3454	6.3464	6.3086	6.3203	58669912.0
2008-06-16 15:30:00	AAPL	Stock	6.3194	6.3289	6.2861	6.3139	79342704.0
2008-06-16 16:00:00	AAPL	Stock	6.3157	6.318	6.2046	6.3154	12563096.0
2008-06-16 16:30:00	AAPL	Stock	6.315	6.3179	6.204	6.3139	413168.0
2008-06-16 17:00:00	AAPL	Stock	6.3114	6.3189	6.3107	6.3179	621908.0
2008-06-16 17:30:00	AAPL	Stock	6.3179	6.3186	6.3143	6.3186	86128.0
2008-06-16 18:00:00	AAPL	Stock	6.3182	6.3186	6.3182	6.3182	76328.0
2008-06-16 18:30:00	AAPL	Stock	6.3171	6.3193	6.315	6.315	133084.0
2008-06-16 19:00:00	AAPL	Stock	6.3189	6.3211	6.3157	6.3196	58296.0
2008-06-16 19:30:00	AAPL	Stock	6.3214	6.3239	6.3179	6.3204	157416.0
2008-06-16 20:00:00	AAPL	Stock	6.155	6.155	6.155	6.155	164640.0
2008-06-16 07:30:00	MSFT	Stock	28.9	28.9	28.9	28.9	10130.0
2008-06-16 08:00:00	MSFT	Stock	29.05	29.1	29.05	29.06	44345.0
2008-06-16 08:30:00	MSFT	Stock	29.04	29.13	28.98	29.07	83796.0
2008-06-16 09:00:00	MSFT	Stock	29.03	29.09	28.94	29.03	245191.0
2008-06-16 09:30:00	MSFT	Stock	29.05	29.05	28.64	28.87	8414689.0
2008-06-16 10:00:00	MSFT	Stock	28.86	29.01	28.76	28.92	5759558.0
2008-06-16 10:30:00	MSFT	Stock	28.93	29.11	28.78	29.01	6348730.0
2008-06-16 11:00:00	MSFT	Stock	29.0	29.11	28.86	28.9	5283513.0
2008-06-16 11:30:00	MSFT	Stock	28.9	28.94	28.83	28.9	5097468.0
2008-06-16 12:00:00	MSFT	Stock	28.9	28.91	28.79	28.798	2808772.0
2008-06-16 12:30:00	MSFT	Stock	28.8	28.87	28.77	28.811	2542317.0
2008-06-16 13:00:00	MSFT	Stock	28.815	28.99	28.79	28.98	3440004.0
2008-06-16 13:30:00	MSFT	Stock	28.971	29.05	28.92	28.97	3487710.0
2008-06-16 14:00:00	MSFT	Stock	28.96	28.97	28.83	28.87	3157398.0
2008-06-16 14:30:00	MSFT	Stock	28.861	28.88	28.83	28.842	3608098.0
2008-06-16 15:00:00	MSFT	Stock	28.85	28.85	28.78	28.82	5021095.0
2008-06-16 15:30:00	MSFT	Stock	28.82	29.05	28.81	28.91	9754671.0
2008-06-16 16:00:00	MSFT	Stock	28.91	28.94	28.8	28.85	3080735.0
2008-06-16 16:30:00	MSFT	Stock	28.87	29.01	28.81	28.84	2630620.0
2008-06-16 17:00:00	MSFT	Stock	28.93	28.93	28.85	28.88	13554.0

> showing 50 of 67,924 rows — these rows as CSV

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