PREVIEW / stock_30min / 2008-03-24

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-03-24.parquet
  size:    1.2 MB
  rows:    70,039
  symbols: 3,298

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-03-24 07:00:00	AAPL	Stock	4.7686	4.7857	4.7686	4.7854	100800.0
2008-03-24 07:30:00	AAPL	Stock	4.7857	4.7946	4.7779	4.7786	96852.0
2008-03-24 08:00:00	AAPL	Stock	4.7771	4.7875	4.7679	4.7857	1256864.0
2008-03-24 08:30:00	AAPL	Stock	4.7796	4.7857	4.7789	4.7857	824432.0
2008-03-24 09:00:00	AAPL	Stock	4.7857	4.7943	4.7821	4.7864	2163840.0
2008-03-24 09:30:00	AAPL	Stock	4.7861	4.8193	4.7729	4.8104	116865812.0
2008-03-24 10:00:00	AAPL	Stock	4.81	4.9164	4.805	4.9079	111731396.0
2008-03-24 10:30:00	AAPL	Stock	4.9089	4.9529	4.9046	4.9214	87437560.0
2008-03-24 11:00:00	AAPL	Stock	4.9214	4.9696	4.9182	4.9654	72334388.0
2008-03-24 11:30:00	AAPL	Stock	4.9654	4.9989	4.9596	4.995	76859916.0
2008-03-24 12:00:00	AAPL	Stock	4.995	5.0239	4.9793	5.0204	81054960.0
2008-03-24 12:30:00	AAPL	Stock	5.0204	5.0304	5.0054	5.0064	71094324.0
2008-03-24 13:00:00	AAPL	Stock	5.0064	5.0164	4.9896	5.0011	43392860.0
2008-03-24 13:30:00	AAPL	Stock	5.0011	5.01	4.9843	5.0061	42722176.0
2008-03-24 14:00:00	AAPL	Stock	5.005	5.0064	4.9643	4.9814	57302980.0
2008-03-24 14:30:00	AAPL	Stock	4.9814	5.0007	4.9557	4.9621	64754648.0
2008-03-24 15:00:00	AAPL	Stock	4.9614	5.0068	4.9589	4.9756	79815792.0
2008-03-24 15:30:00	AAPL	Stock	4.975	4.9986	4.9518	4.9879	108804976.0
2008-03-24 16:00:00	AAPL	Stock	4.9879	4.9964	4.9441	4.9857	19472068.0
2008-03-24 16:30:00	AAPL	Stock	4.9879	4.9879	4.975	4.9804	343616.0
2008-03-24 17:00:00	AAPL	Stock	4.975	4.9821	4.9579	4.9821	293944.0
2008-03-24 17:30:00	AAPL	Stock	4.9821	4.9893	4.9441	4.9846	1236200.0
2008-03-24 18:00:00	AAPL	Stock	4.9725	4.9907	4.9725	4.9864	403760.0
2008-03-24 18:30:00	AAPL	Stock	4.9875	4.9889	4.9857	4.9879	129136.0
2008-03-24 19:00:00	AAPL	Stock	4.9879	4.99	4.9879	4.9893	29512.0
2008-03-24 19:30:00	AAPL	Stock	4.9893	4.9911	4.9861	4.9911	154364.0
2008-03-24 08:00:00	MSFT	Stock	29.25	29.3	29.07	29.18	16668.0
2008-03-24 08:30:00	MSFT	Stock	29.19	29.3	29.19	29.3	41959.0
2008-03-24 09:00:00	MSFT	Stock	29.27	29.35	29.27	29.31	34449.0
2008-03-24 09:30:00	MSFT	Stock	29.31	29.36	29.2	29.27	4664872.0
2008-03-24 10:00:00	MSFT	Stock	29.28	29.39	29.11	29.14	6155543.0
2008-03-24 10:30:00	MSFT	Stock	29.14	29.23	29.09	29.12	3989099.0
2008-03-24 11:00:00	MSFT	Stock	29.11	29.21	29.09	29.2	2580265.0
2008-03-24 11:30:00	MSFT	Stock	29.19	29.2	29.1	29.19	2480587.0
2008-03-24 12:00:00	MSFT	Stock	29.18	29.25	29.14	29.22	2176135.0
2008-03-24 12:30:00	MSFT	Stock	29.22	29.35	29.18	29.3	2714219.0
2008-03-24 13:00:00	MSFT	Stock	29.3	29.35	29.26	29.33	2299810.0
2008-03-24 13:30:00	MSFT	Stock	29.33	29.37	29.26	29.37	2110434.0
2008-03-24 14:00:00	MSFT	Stock	29.37	29.37	29.26	29.37	1928564.0
2008-03-24 14:30:00	MSFT	Stock	29.37	29.4	29.25	29.26	2670207.0
2008-03-24 15:00:00	MSFT	Stock	29.25	29.28	29.15	29.15	3699098.0
2008-03-24 15:30:00	MSFT	Stock	29.15	29.21	29.06	29.2	6672322.0
2008-03-24 16:00:00	MSFT	Stock	29.2	29.231	29.111	29.23	2701087.0
2008-03-24 16:30:00	MSFT	Stock	29.23	29.23	29.2	29.2	2156.0
2008-03-24 17:00:00	MSFT	Stock	29.2	29.23	29.2	29.23	7359.0
2008-03-24 17:30:00	MSFT	Stock	29.19	29.19	29.19	29.19	200.0
2008-03-24 18:00:00	MSFT	Stock	29.21	29.3	29.17	29.3	430650.0
2008-03-24 18:30:00	MSFT	Stock	29.18	29.18	29.18	29.18	100.0
2008-03-24 19:30:00	MSFT	Stock	29.18	29.2	29.1	29.2	2300.0
2008-03-24 08:00:00	NVDA	Stock	0.4695	0.474	0.467	0.4678	1383080.0

> showing 50 of 70,039 rows — these rows as CSV

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