PREVIEW / stock_30min / 2010-03-16

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-03-16.parquet
  size:    1.4 MB
  rows:    73,257
  symbols: 3,476

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
2010-03-16 04:00:00	AAPL	Stock	7.98	7.98	7.98	7.98	3416.0
2010-03-16 05:30:00	AAPL	Stock	7.99	7.99	7.99	7.99	15120.0
2010-03-16 06:30:00	AAPL	Stock	8.0279	8.0304	8.0279	8.0304	54964.0
2010-03-16 07:00:00	AAPL	Stock	8.03	8.0321	8.0268	8.0321	128548.0
2010-03-16 07:30:00	AAPL	Stock	8.0336	8.0389	8.0314	8.0389	81200.0
2010-03-16 08:00:00	AAPL	Stock	8.0325	8.0357	7.9861	7.9936	1340556.0
2010-03-16 08:30:00	AAPL	Stock	7.9914	8.0061	7.9857	7.9929	615692.0
2010-03-16 09:00:00	AAPL	Stock	7.9929	8.0071	7.9886	8.0071	846412.0
2010-03-16 09:30:00	AAPL	Stock	8.0064	8.0171	7.9732	7.9874	50145788.0
2010-03-16 10:00:00	AAPL	Stock	7.9871	7.9961	7.9468	7.9746	41746292.0
2010-03-16 10:30:00	AAPL	Stock	7.9746	8.0118	7.9679	8.0114	26537308.0
2010-03-16 11:00:00	AAPL	Stock	8.0114	8.0307	7.9979	8.0279	26248600.0
2010-03-16 11:30:00	AAPL	Stock	8.0282	8.035	8.0154	8.02	51234568.0
2010-03-16 12:00:00	AAPL	Stock	8.0196	8.0271	8.0143	8.0229	10375092.0
2010-03-16 12:30:00	AAPL	Stock	8.0214	8.025	8.0036	8.0086	11533676.0
2010-03-16 13:00:00	AAPL	Stock	8.0084	8.0139	8.0018	8.0037	11201568.0
2010-03-16 13:30:00	AAPL	Stock	8.003	8.0046	7.9957	7.9993	10867864.0
2010-03-16 14:00:00	AAPL	Stock	7.9989	8.0286	7.9932	8.0196	34859748.0
2010-03-16 14:30:00	AAPL	Stock	8.0193	8.0211	7.9729	8.005	45909276.0
2010-03-16 15:00:00	AAPL	Stock	8.0054	8.0182	7.9911	8.0107	25576432.0
2010-03-16 15:30:00	AAPL	Stock	8.0107	8.0218	8.0061	8.0196	40686828.0
2010-03-16 16:00:00	AAPL	Stock	8.0196	8.0214	7.9892	8.0161	10542868.0
2010-03-16 16:30:00	AAPL	Stock	8.0124	8.0196	8.0111	8.0161	253764.0
2010-03-16 17:00:00	AAPL	Stock	7.9943	8.0161	7.9943	8.0036	86240.0
2010-03-16 17:30:00	AAPL	Stock	8.0143	8.0189	8.0143	8.0179	128604.0
2010-03-16 18:00:00	AAPL	Stock	8.0179	8.0179	8.0114	8.0143	56000.0
2010-03-16 18:30:00	AAPL	Stock	8.0175	8.0196	8.0175	8.0182	117376.0
2010-03-16 19:00:00	AAPL	Stock	8.0161	8.0161	8.0161	8.0161	12236.0
2010-03-16 19:30:00	AAPL	Stock	8.0155	8.0179	8.0093	8.0121	230776.0
2010-03-16 07:30:00	MSFT	Stock	29.35	29.35	29.35	29.35	500.0
2010-03-16 08:00:00	MSFT	Stock	29.35	29.35	29.32	29.32	595.0
2010-03-16 08:30:00	MSFT	Stock	29.35	29.4	29.35	29.39	12300.0
2010-03-16 09:00:00	MSFT	Stock	29.38	29.44	29.38	29.41	15900.0
2010-03-16 09:30:00	MSFT	Stock	29.41	29.49	29.29	29.315	3289750.0
2010-03-16 10:00:00	MSFT	Stock	29.32	29.36	29.25	29.31	2085523.0
2010-03-16 10:30:00	MSFT	Stock	29.31	29.42	29.27	29.395	3023334.0
2010-03-16 11:00:00	MSFT	Stock	29.4	29.48	29.36	29.42	3099985.0
2010-03-16 11:30:00	MSFT	Stock	29.415	29.444	29.27	29.28	2386346.0
2010-03-16 12:00:00	MSFT	Stock	29.281	29.32	29.26	29.302	1541638.0
2010-03-16 12:30:00	MSFT	Stock	29.31	29.34	29.25	29.275	1318915.0
2010-03-16 13:00:00	MSFT	Stock	29.28	29.3	29.27	29.29	1144679.0
2010-03-16 13:30:00	MSFT	Stock	29.285	29.3	29.22	29.255	1498403.0
2010-03-16 14:00:00	MSFT	Stock	29.26	29.45	29.2	29.38	3253632.0
2010-03-16 14:30:00	MSFT	Stock	29.38	29.4	29.23	29.34	3412566.0
2010-03-16 15:00:00	MSFT	Stock	29.33	29.37	29.229	29.31	2019955.0
2010-03-16 15:30:00	MSFT	Stock	29.305	29.43	29.29	29.37	5967187.0
2010-03-16 16:00:00	MSFT	Stock	29.37	29.42	29.277	29.37	1947678.0
2010-03-16 16:30:00	MSFT	Stock	29.338	29.41	29.338	29.37	106350.0
2010-03-16 17:30:00	MSFT	Stock	29.41	29.41	29.35	29.35	2800.0
2010-03-16 18:00:00	MSFT	Stock	29.35	29.35	29.35	29.35	2208.0

> showing 50 of 73,257 rows — these rows as CSV

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