PREVIEW / stock_30min / 2008-09-15

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-09-15.parquet
  size:    1.3 MB
  rows:    71,828
  symbols: 3,337

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-09-15 04:00:00	AAPL	Stock	5.25	5.25	5.1786	5.1786	12600.0
2008-09-15 04:30:00	AAPL	Stock	5.1429	5.1429	5.1429	5.1429	2800.0
2008-09-15 05:00:00	AAPL	Stock	5.1104	5.1104	5.1071	5.1071	44800.0
2008-09-15 05:30:00	AAPL	Stock	5.1107	5.1107	5.1107	5.1107	12880.0
2008-09-15 06:00:00	AAPL	Stock	5.1071	5.1071	5.1071	5.1071	2800.0
2008-09-15 06:30:00	AAPL	Stock	5.1071	5.1429	5.1071	5.125	102480.0
2008-09-15 07:00:00	AAPL	Stock	5.1075	5.1161	5.0982	5.0982	408884.0
2008-09-15 07:30:00	AAPL	Stock	5.0946	5.1071	5.0714	5.0929	1134532.0
2008-09-15 08:00:00	AAPL	Stock	5.0921	5.1036	5.0046	5.0714	4521832.0
2008-09-15 08:30:00	AAPL	Stock	5.0714	5.1186	5.0689	5.1004	1878268.0
2008-09-15 09:00:00	AAPL	Stock	5.1029	5.1032	5.0714	5.0732	3627428.0
2008-09-15 09:30:00	AAPL	Stock	5.0725	5.2225	5.0589	5.185	135325484.0
2008-09-15 10:00:00	AAPL	Stock	5.1846	5.2393	5.1729	5.2264	70379036.0
2008-09-15 10:30:00	AAPL	Stock	5.2268	5.2746	5.2007	5.2464	66928036.0
2008-09-15 11:00:00	AAPL	Stock	5.2461	5.2589	5.1904	5.1957	41408556.0
2008-09-15 11:30:00	AAPL	Stock	5.1961	5.2304	5.1714	5.1754	39808104.0
2008-09-15 12:00:00	AAPL	Stock	5.1757	5.2525	5.1743	5.2111	37781632.0
2008-09-15 12:30:00	AAPL	Stock	5.2114	5.2357	5.1896	5.2071	24806264.0
2008-09-15 13:00:00	AAPL	Stock	5.2071	5.2396	5.1307	5.1529	63967540.0
2008-09-15 13:30:00	AAPL	Stock	5.1525	5.1561	5.0636	5.1054	69514928.0
2008-09-15 14:00:00	AAPL	Stock	5.1043	5.1304	5.0821	5.1171	50660008.0
2008-09-15 14:30:00	AAPL	Stock	5.1174	5.1357	5.0607	5.11	47921412.0
2008-09-15 15:00:00	AAPL	Stock	5.11	5.1107	5.0307	5.0793	92707440.0
2008-09-15 15:30:00	AAPL	Stock	5.0796	5.1532	5.0182	5.0214	112089908.0
2008-09-15 16:00:00	AAPL	Stock	5.0254	5.1449	5.0129	5.0271	28908040.0
2008-09-15 16:30:00	AAPL	Stock	5.0321	5.0421	5.0129	5.025	1674596.0
2008-09-15 17:00:00	AAPL	Stock	5.0129	5.0268	5.0039	5.0136	1739080.0
2008-09-15 17:30:00	AAPL	Stock	5.0089	5.0143	4.9904	4.9929	420616.0
2008-09-15 18:00:00	AAPL	Stock	4.9929	5.0	4.9929	5.0	201320.0
2008-09-15 18:30:00	AAPL	Stock	5.0	5.0064	4.9964	4.9964	132076.0
2008-09-15 19:00:00	AAPL	Stock	4.9964	4.9986	4.9668	4.9686	376740.0
2008-09-15 19:30:00	AAPL	Stock	4.9736	4.9868	4.9707	4.9779	331072.0
2008-09-15 06:00:00	MSFT	Stock	26.85	26.85	26.85	26.85	100.0
2008-09-15 07:00:00	MSFT	Stock	28.79	29.74	26.51	26.6	2229.0
2008-09-15 07:30:00	MSFT	Stock	26.55	26.69	26.51	26.67	1900.0
2008-09-15 08:00:00	MSFT	Stock	26.56	26.9	26.55	26.9	21045.0
2008-09-15 08:30:00	MSFT	Stock	26.9	27.3	26.8	26.8	27439.0
2008-09-15 09:00:00	MSFT	Stock	26.8	26.95	26.75	26.92	37960.0
2008-09-15 09:30:00	MSFT	Stock	26.92	27.49	26.85	27.26	8784137.0
2008-09-15 10:00:00	MSFT	Stock	27.267	27.342	27.1	27.21	6309993.0
2008-09-15 10:30:00	MSFT	Stock	27.21	27.45	27.14	27.33	6085752.0
2008-09-15 11:00:00	MSFT	Stock	27.32	27.35	27.2	27.228	3484244.0
2008-09-15 11:30:00	MSFT	Stock	27.22	27.37	27.2	27.24	4402861.0
2008-09-15 12:00:00	MSFT	Stock	27.23	27.4	27.2	27.27	4286486.0
2008-09-15 12:30:00	MSFT	Stock	27.27	27.365	27.19	27.33	3805876.0
2008-09-15 13:00:00	MSFT	Stock	27.34	27.41	27.143	27.21	3965564.0
2008-09-15 13:30:00	MSFT	Stock	27.21	27.27	27.1	27.22	4893309.0
2008-09-15 14:00:00	MSFT	Stock	27.22	27.34	27.16	27.2	3034870.0
2008-09-15 14:30:00	MSFT	Stock	27.19	27.25	27.11	27.12	5335187.0
2008-09-15 15:00:00	MSFT	Stock	27.12	27.19	27.05	27.17	7599206.0

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

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