PREVIEW / stock_30min / 2006-01-11

all stock 30-min files

  file:    by_date/stock_30min/2006/2006-01-11.parquet
  size:    897 KB
  rows:    48,020
  symbols: 2,169

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
2006-01-11 04:30:00	AAPL	Stock	2.9089	2.9107	2.9089	2.9107	78400.0
2006-01-11 05:00:00	AAPL	Stock	2.9143	2.9161	2.9143	2.9143	120400.0
2006-01-11 05:30:00	AAPL	Stock	2.9143	2.9143	2.9143	2.9143	3696.0
2006-01-11 06:00:00	AAPL	Stock	2.9161	2.9161	2.9111	2.9111	86800.0
2006-01-11 06:30:00	AAPL	Stock	2.9232	2.9232	2.9232	2.9232	8400.0
2006-01-11 07:00:00	AAPL	Stock	2.9232	2.9364	2.9232	2.9268	641200.0
2006-01-11 07:30:00	AAPL	Stock	2.9286	2.9339	2.925	2.925	306236.0
2006-01-11 08:00:00	AAPL	Stock	2.9286	3.0018	2.9271	3.0007	37868292.0
2006-01-11 08:30:00	AAPL	Stock	3.0011	3.0057	2.9736	2.9804	21250404.0
2006-01-11 09:00:00	AAPL	Stock	2.9796	3.0	2.9721	2.9946	18682188.0
2006-01-11 09:30:00	AAPL	Stock	2.9946	2.9971	2.9596	2.9857	316878212.0
2006-01-11 10:00:00	AAPL	Stock	2.9857	2.9893	2.9689	2.9732	151980164.0
2006-01-11 10:30:00	AAPL	Stock	2.9732	2.9786	2.9496	2.9639	148143716.0
2006-01-11 11:00:00	AAPL	Stock	2.9636	2.9804	2.9575	2.9743	84877912.0
2006-01-11 11:30:00	AAPL	Stock	2.975	2.9864	2.9736	2.9775	66129280.0
2006-01-11 12:00:00	AAPL	Stock	2.9775	2.9993	2.9729	2.9939	74543644.0
2006-01-11 12:30:00	AAPL	Stock	2.9939	3.0061	2.9875	3.0057	68563712.0
2006-01-11 13:00:00	AAPL	Stock	3.0054	3.0064	2.9939	2.9943	84563192.0
2006-01-11 13:30:00	AAPL	Stock	2.9946	3.0029	2.9829	2.9864	52692780.0
2006-01-11 14:00:00	AAPL	Stock	2.9868	3.0093	2.9864	3.0064	64180676.0
2006-01-11 14:30:00	AAPL	Stock	3.0068	3.0286	2.9964	3.0193	104803804.0
2006-01-11 15:00:00	AAPL	Stock	3.0193	3.0193	3.0039	3.0068	72387420.0
2006-01-11 15:30:00	AAPL	Stock	3.0068	3.0161	2.9943	2.9971	103694360.0
2006-01-11 16:00:00	AAPL	Stock	2.9982	3.0	2.9921	2.9929	3547936.0
2006-01-11 16:30:00	AAPL	Stock	2.9929	2.9986	2.9893	2.9893	1491364.0
2006-01-11 17:00:00	AAPL	Stock	2.9879	3.0068	2.9821	2.9932	589820.0
2006-01-11 17:30:00	AAPL	Stock	2.9929	2.9964	2.9893	2.9939	1529892.0
2006-01-11 18:00:00	AAPL	Stock	2.9929	2.9939	2.9921	2.9921	335076.0
2006-01-11 07:00:00	MSFT	Stock	27.0	27.0	27.0	27.0	300.0
2006-01-11 08:00:00	MSFT	Stock	26.95	27.03	26.95	27.0	3568.0
2006-01-11 08:30:00	MSFT	Stock	27.02	27.02	27.0	27.0	1919.0
2006-01-11 09:00:00	MSFT	Stock	27.02	27.05	26.99	27.02	48887.0
2006-01-11 09:30:00	MSFT	Stock	27.01	27.03	26.9	27.03	5487129.0
2006-01-11 10:00:00	MSFT	Stock	27.03	27.18	26.99	27.17	5633939.0
2006-01-11 10:30:00	MSFT	Stock	27.17	27.19	27.03	27.08	4089336.0
2006-01-11 11:00:00	MSFT	Stock	27.07	27.22	27.06	27.18	4473707.0
2006-01-11 11:30:00	MSFT	Stock	27.18	27.25	27.165	27.2	4656563.0
2006-01-11 12:00:00	MSFT	Stock	27.2	27.24	27.12	27.22	4866830.0
2006-01-11 12:30:00	MSFT	Stock	27.21	27.26	27.18	27.24	3643010.0
2006-01-11 13:00:00	MSFT	Stock	27.24	27.27	27.18	27.2	3923501.0
2006-01-11 13:30:00	MSFT	Stock	27.21	27.26	27.16	27.2	4638747.0
2006-01-11 14:00:00	MSFT	Stock	27.2	27.3	27.18	27.272	4974687.0
2006-01-11 14:30:00	MSFT	Stock	27.27	27.39	27.27	27.35	5196467.0
2006-01-11 15:00:00	MSFT	Stock	27.35	27.37	27.3	27.35	4774847.0
2006-01-11 15:30:00	MSFT	Stock	27.35	27.38	27.19	27.28	11909896.0
2006-01-11 16:00:00	MSFT	Stock	27.29	27.43	27.26	27.28	461606.0
2006-01-11 16:30:00	MSFT	Stock	27.31	27.31	27.28	27.3	2277.0
2006-01-11 17:00:00	MSFT	Stock	27.29	27.3	27.29	27.3	847.0
2006-01-11 17:30:00	MSFT	Stock	27.29	27.29	27.29	27.29	100.0
2006-01-11 18:00:00	MSFT	Stock	27.29	27.29	27.25	27.29	2705.0

> showing 50 of 48,020 rows — these rows as CSV

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