PREVIEW / stock_30min / 2008-10-17

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-10-17.parquet
  size:    1.2 MB
  rows:    69,365
  symbols: 3,329

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-10-17 05:30:00	AAPL	Stock	3.6268	3.6268	3.6268	3.6268	40600.0
2008-10-17 07:00:00	AAPL	Stock	3.6175	3.6675	3.6175	3.6675	184800.0
2008-10-17 07:30:00	AAPL	Stock	3.6668	3.6789	3.6464	3.6721	225372.0
2008-10-17 08:00:00	AAPL	Stock	3.6879	3.7268	3.6386	3.6625	2660224.0
2008-10-17 08:30:00	AAPL	Stock	3.6579	3.66	3.5846	3.6071	3994200.0
2008-10-17 09:00:00	AAPL	Stock	3.6043	3.6043	3.5357	3.5571	6711124.0
2008-10-17 09:30:00	AAPL	Stock	3.5571	3.5786	3.5059	3.5686	284927496.0
2008-10-17 10:00:00	AAPL	Stock	3.5693	3.5886	3.48	3.5237	154807184.0
2008-10-17 10:30:00	AAPL	Stock	3.5236	3.5714	3.4821	3.5589	135485084.0
2008-10-17 11:00:00	AAPL	Stock	3.5589	3.59	3.5146	3.52	107946636.0
2008-10-17 11:30:00	AAPL	Stock	3.5196	3.5357	3.5	3.5079	69923924.0
2008-10-17 12:00:00	AAPL	Stock	3.5079	3.5471	3.5036	3.5382	64532636.0
2008-10-17 12:30:00	AAPL	Stock	3.5382	3.5707	3.5125	3.5593	82358612.0
2008-10-17 13:00:00	AAPL	Stock	3.5589	3.5975	3.5414	3.5796	124560828.0
2008-10-17 13:30:00	AAPL	Stock	3.58	3.6443	3.5679	3.585	143652908.0
2008-10-17 14:00:00	AAPL	Stock	3.5839	3.6157	3.5271	3.5386	107229528.0
2008-10-17 14:30:00	AAPL	Stock	3.5379	3.5711	3.5	3.5318	113106980.0
2008-10-17 15:00:00	AAPL	Stock	3.5321	3.5707	3.4818	3.5114	149062480.0
2008-10-17 15:30:00	AAPL	Stock	3.5125	3.5411	3.4646	3.4768	171895136.0
2008-10-17 16:00:00	AAPL	Stock	3.4764	3.5417	3.4661	3.4679	18282208.0
2008-10-17 16:30:00	AAPL	Stock	3.4679	3.4786	3.0664	3.4714	2213904.0
2008-10-17 17:00:00	AAPL	Stock	3.4714	3.4786	3.4714	3.475	205912.0
2008-10-17 17:30:00	AAPL	Stock	3.4736	3.4875	3.4732	3.475	458108.0
2008-10-17 18:00:00	AAPL	Stock	3.4786	3.4857	3.475	3.4786	1014944.0
2008-10-17 18:30:00	AAPL	Stock	3.4782	3.4786	3.4679	3.4786	305452.0
2008-10-17 19:00:00	AAPL	Stock	3.4689	3.4768	3.4689	3.4696	62832.0
2008-10-17 19:30:00	AAPL	Stock	3.4714	3.4754	3.4464	3.4714	357364.0
2008-10-17 04:00:00	MSFT	Stock	24.1	24.1	24.1	24.1	100.0
2008-10-17 07:30:00	MSFT	Stock	23.9	23.9	23.9	23.9	4628.0
2008-10-17 08:00:00	MSFT	Stock	23.57	23.96	23.57	23.81	17680.0
2008-10-17 08:30:00	MSFT	Stock	23.77	23.81	23.6	23.62	9445.0
2008-10-17 09:00:00	MSFT	Stock	23.65	23.76	23.4	23.52	148203.0
2008-10-17 09:30:00	MSFT	Stock	23.52	24.0	23.31	23.93	20831665.0
2008-10-17 10:00:00	MSFT	Stock	23.93	23.99	23.66	23.93	10036170.0
2008-10-17 10:30:00	MSFT	Stock	23.93	24.45	23.67	24.13	8630882.0
2008-10-17 11:00:00	MSFT	Stock	24.14	24.4	24.13	24.179	7680451.0
2008-10-17 11:30:00	MSFT	Stock	24.16	24.2	23.99	24.095	5204938.0
2008-10-17 12:00:00	MSFT	Stock	24.09	24.25	24.04	24.24	4278943.0
2008-10-17 12:30:00	MSFT	Stock	24.24	24.75	24.15	24.65	6509319.0
2008-10-17 13:00:00	MSFT	Stock	24.65	24.89	24.6	24.73	7965592.0
2008-10-17 13:30:00	MSFT	Stock	24.74	25.11	24.71	24.92	9752078.0
2008-10-17 14:00:00	MSFT	Stock	24.91	25.0	24.52	24.63	6998439.0
2008-10-17 14:30:00	MSFT	Stock	24.63	24.79	24.32	24.56	8725832.0
2008-10-17 15:00:00	MSFT	Stock	24.56	24.76	23.94	24.14	13606498.0
2008-10-17 15:30:00	MSFT	Stock	24.13	24.17	23.86	23.9	15826331.0
2008-10-17 16:00:00	MSFT	Stock	23.91	24.279	23.85	23.9	5554394.0
2008-10-17 16:30:00	MSFT	Stock	23.93	23.99	23.87	23.99	355142.0
2008-10-17 17:00:00	MSFT	Stock	23.99	23.99	23.96	23.96	1300.0
2008-10-17 17:30:00	MSFT	Stock	23.96	23.96	23.96	23.96	4696.0
2008-10-17 18:00:00	MSFT	Stock	23.93	24.0	23.93	23.99	17750.0

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

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