PREVIEW / stock_30min / 2008-08-11

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-08-11.parquet
  size:    1.3 MB
  rows:    69,059
  symbols: 3,324

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-08-11 06:30:00	AAPL	Stock	6.0721	6.0721	6.0721	6.0721	8400.0
2008-08-11 07:00:00	AAPL	Stock	6.1011	6.1011	6.0857	6.0857	72800.0
2008-08-11 07:30:00	AAPL	Stock	6.0857	6.0911	6.0714	6.0907	147840.0
2008-08-11 08:00:00	AAPL	Stock	6.0911	6.1161	6.0679	6.0914	2373392.0
2008-08-11 08:30:00	AAPL	Stock	6.0914	6.0982	6.0714	6.0946	1359792.0
2008-08-11 09:00:00	AAPL	Stock	6.0943	6.1071	6.0721	6.0764	1559404.0
2008-08-11 09:30:00	AAPL	Stock	6.0757	6.1246	6.0596	6.0939	119308168.0
2008-08-11 10:00:00	AAPL	Stock	6.0929	6.1407	6.0811	6.1357	71386588.0
2008-08-11 10:30:00	AAPL	Stock	6.1364	6.1739	6.1171	6.1679	65185484.0
2008-08-11 11:00:00	AAPL	Stock	6.1679	6.2314	6.1643	6.2271	89209232.0
2008-08-11 11:30:00	AAPL	Stock	6.2271	6.2346	6.1964	6.2029	56128128.0
2008-08-11 12:00:00	AAPL	Stock	6.2029	6.2321	6.1982	6.2307	33510624.0
2008-08-11 12:30:00	AAPL	Stock	6.2304	6.2457	6.2207	6.2393	39571056.0
2008-08-11 13:00:00	AAPL	Stock	6.2389	6.2664	6.2268	6.2661	46360412.0
2008-08-11 13:30:00	AAPL	Stock	6.2652	6.3029	6.2646	6.2818	65219476.0
2008-08-11 14:00:00	AAPL	Stock	6.2818	6.3036	6.2446	6.2529	64798356.0
2008-08-11 14:30:00	AAPL	Stock	6.2525	6.2564	6.1786	6.2011	69559308.0
2008-08-11 15:00:00	AAPL	Stock	6.2004	6.2293	6.1707	6.1768	57999788.0
2008-08-11 15:30:00	AAPL	Stock	6.1771	6.2029	6.135	6.1982	90352948.0
2008-08-11 16:00:00	AAPL	Stock	6.1976	6.2607	6.1894	6.1911	8415204.0
2008-08-11 16:30:00	AAPL	Stock	6.1907	6.2415	6.19	6.1907	168476.0
2008-08-11 17:00:00	AAPL	Stock	6.1904	6.1946	6.1904	6.1946	72296.0
2008-08-11 17:30:00	AAPL	Stock	6.1929	6.1943	6.1893	6.1893	193368.0
2008-08-11 18:00:00	AAPL	Stock	6.1946	6.1986	6.1861	6.1986	160972.0
2008-08-11 18:30:00	AAPL	Stock	6.1954	6.2032	6.1954	6.2032	144032.0
2008-08-11 19:00:00	AAPL	Stock	6.1943	6.1964	6.1911	6.1911	66360.0
2008-08-11 19:30:00	AAPL	Stock	6.1929	6.1946	6.1864	6.1868	124040.0
2008-08-11 08:00:00	MSFT	Stock	28.13	28.13	28.08	28.13	2228.0
2008-08-11 08:30:00	MSFT	Stock	28.08	28.15	28.07	28.15	2900.0
2008-08-11 09:00:00	MSFT	Stock	28.12	28.12	27.87	27.88	22160.0
2008-08-11 09:30:00	MSFT	Stock	27.87	28.07	27.7	28.03	5633584.0
2008-08-11 10:00:00	MSFT	Stock	28.02	28.34	28.0	28.3	5358642.0
2008-08-11 10:30:00	MSFT	Stock	28.305	28.33	28.12	28.21	5767425.0
2008-08-11 11:00:00	MSFT	Stock	28.21	28.21	28.07	28.15	4968731.0
2008-08-11 11:30:00	MSFT	Stock	28.14	28.3	28.105	28.29	3452507.0
2008-08-11 12:00:00	MSFT	Stock	28.3	28.38	28.23	28.37	3230528.0
2008-08-11 12:30:00	MSFT	Stock	28.37	28.4	28.25	28.305	2872682.0
2008-08-11 13:00:00	MSFT	Stock	28.3	28.34	28.26	28.3	3023428.0
2008-08-11 13:30:00	MSFT	Stock	28.3	28.33	28.2	28.21	5566930.0
2008-08-11 14:00:00	MSFT	Stock	28.22	28.24	27.96	28.03	4942232.0
2008-08-11 14:30:00	MSFT	Stock	28.04	28.06	27.79	27.82	6046259.0
2008-08-11 15:00:00	MSFT	Stock	27.81	27.88	27.71	27.75	6676487.0
2008-08-11 15:30:00	MSFT	Stock	27.74	27.9	27.66	27.9	6211885.0
2008-08-11 16:00:00	MSFT	Stock	27.89	28.077	27.59	27.77	2167399.0
2008-08-11 16:30:00	MSFT	Stock	27.87	28.058	27.6	27.8	118739.0
2008-08-11 17:00:00	MSFT	Stock	27.72	27.72	27.72	27.72	600.0
2008-08-11 17:30:00	MSFT	Stock	27.75	27.81	27.75	27.81	547.0
2008-08-11 18:00:00	MSFT	Stock	27.79	27.9	27.76	27.9	13902.0
2008-08-11 18:30:00	MSFT	Stock	27.75	27.75	27.71	27.71	2911.0
2008-08-11 19:00:00	MSFT	Stock	27.75	27.77	27.75	27.77	200.0

> showing 50 of 69,059 rows — these rows as CSV

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