PREVIEW / stock_30min / 2009-06-11

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-06-11.parquet
  size:    1.3 MB
  rows:    71,660
  symbols: 3,368

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-11 07:00:00	AAPL	Stock	5.0221	5.0286	5.0089	5.0089	23800.0
2009-06-11 07:30:00	AAPL	Stock	4.9996	5.0182	4.9996	5.0089	126672.0
2009-06-11 08:00:00	AAPL	Stock	5.0136	5.0343	5.0075	5.0111	582260.0
2009-06-11 08:30:00	AAPL	Stock	5.0146	5.0396	4.975	4.9796	948192.0
2009-06-11 09:00:00	AAPL	Stock	4.9804	5.0	4.9779	4.9875	793380.0
2009-06-11 09:30:00	AAPL	Stock	4.9861	5.0337	4.9482	5.0146	89921384.0
2009-06-11 10:00:00	AAPL	Stock	5.0146	5.0557	4.9932	5.0436	59374504.0
2009-06-11 10:30:00	AAPL	Stock	5.0439	5.0482	5.0136	5.0239	30214268.0
2009-06-11 11:00:00	AAPL	Stock	5.0243	5.0518	5.0179	5.0461	26330724.0
2009-06-11 11:30:00	AAPL	Stock	5.0467	5.0479	5.0243	5.0289	25557560.0
2009-06-11 12:00:00	AAPL	Stock	5.0289	5.0293	4.9911	5.0014	38568180.0
2009-06-11 12:30:00	AAPL	Stock	5.0011	5.0304	5.0004	5.0275	24148292.0
2009-06-11 13:00:00	AAPL	Stock	5.0271	5.0429	5.0179	5.037	29344644.0
2009-06-11 13:30:00	AAPL	Stock	5.0364	5.0393	5.0136	5.0193	24939740.0
2009-06-11 14:00:00	AAPL	Stock	5.0193	5.0261	4.9943	5.0214	35628628.0
2009-06-11 14:30:00	AAPL	Stock	5.0214	5.0261	5.0018	5.0154	26529244.0
2009-06-11 15:00:00	AAPL	Stock	5.015	5.0339	5.0054	5.0068	31393264.0
2009-06-11 15:30:00	AAPL	Stock	5.0057	5.0139	4.9871	4.9921	58468284.0
2009-06-11 16:00:00	AAPL	Stock	4.9982	5.0158	4.9825	4.9864	10562440.0
2009-06-11 16:30:00	AAPL	Stock	4.9864	5.0164	4.9857	5.0164	194180.0
2009-06-11 17:00:00	AAPL	Stock	4.9914	4.9914	4.9875	4.9875	57120.0
2009-06-11 17:30:00	AAPL	Stock	4.9893	4.9929	4.9893	4.9929	12040.0
2009-06-11 18:00:00	AAPL	Stock	4.9982	4.9982	4.9864	4.9875	212828.0
2009-06-11 18:30:00	AAPL	Stock	4.9889	4.9936	4.9875	4.9925	50428.0
2009-06-11 19:00:00	AAPL	Stock	4.9882	4.99	4.9836	4.9857	112224.0
2009-06-11 19:30:00	AAPL	Stock	4.9846	4.9882	4.9821	4.9821	307580.0
2009-06-11 08:00:00	MSFT	Stock	22.59	22.59	22.49	22.49	4300.0
2009-06-11 08:30:00	MSFT	Stock	22.53	22.55	22.47	22.47	19210.0
2009-06-11 09:00:00	MSFT	Stock	22.47	22.64	22.45	22.59	30319.0
2009-06-11 09:30:00	MSFT	Stock	22.59	23.0	22.57	22.94	6877760.0
2009-06-11 10:00:00	MSFT	Stock	22.94	22.95	22.83	22.86	5913763.0
2009-06-11 10:30:00	MSFT	Stock	22.85	22.89	22.77	22.81	3237105.0
2009-06-11 11:00:00	MSFT	Stock	22.8	22.92	22.78	22.91	2159595.0
2009-06-11 11:30:00	MSFT	Stock	22.91	22.91	22.81	22.82	2238910.0
2009-06-11 12:00:00	MSFT	Stock	22.82	22.84	22.73	22.8	2446512.0
2009-06-11 12:30:00	MSFT	Stock	22.81	22.92	22.77	22.91	2617486.0
2009-06-11 13:00:00	MSFT	Stock	22.91	23.25	22.91	23.25	7804139.0
2009-06-11 13:30:00	MSFT	Stock	23.26	23.26	23.18	23.18	4806136.0
2009-06-11 14:00:00	MSFT	Stock	23.18	23.2	23.1	23.18	3387233.0
2009-06-11 14:30:00	MSFT	Stock	23.17	23.2	23.05	23.122	3672186.0
2009-06-11 15:00:00	MSFT	Stock	23.12	23.12	22.91	22.91	4718923.0
2009-06-11 15:30:00	MSFT	Stock	22.92	22.97	22.76	22.82	9593468.0
2009-06-11 16:00:00	MSFT	Stock	22.82	22.981	22.74	22.78	2934613.0
2009-06-11 16:30:00	MSFT	Stock	22.83	22.953	22.79	22.934	17386.0
2009-06-11 17:00:00	MSFT	Stock	22.84	22.84	22.83	22.84	1544.0
2009-06-11 17:30:00	MSFT	Stock	22.83	22.84	22.83	22.83	650.0
2009-06-11 18:00:00	MSFT	Stock	22.82	22.83	22.82	22.82	4510.0
2009-06-11 18:30:00	MSFT	Stock	22.82	22.82	22.82	22.82	300.0
2009-06-11 08:00:00	NVDA	Stock	0.2908	0.2935	0.2908	0.2925	24000.0
2009-06-11 08:30:00	NVDA	Stock	0.2948	0.2948	0.2948	0.2948	4000.0

> showing 50 of 71,660 rows — these rows as CSV

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