PREVIEW / stock_30min / 2010-12-17

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-12-17.parquet
  size:    1.6 MB
  rows:    81,270
  symbols: 3,536

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-12-17 06:00:00	AAPL	Stock	11.4736	11.4736	11.4736	11.4736	2800.0
2010-12-17 06:30:00	AAPL	Stock	11.4736	11.4736	11.4736	11.4736	2800.0
2010-12-17 07:00:00	AAPL	Stock	11.4725	11.4786	11.4679	11.4679	35448.0
2010-12-17 07:30:00	AAPL	Stock	11.4775	11.5071	11.4775	11.4893	84000.0
2010-12-17 08:00:00	AAPL	Stock	11.4821	11.51	11.4804	11.4989	1208424.0
2010-12-17 08:30:00	AAPL	Stock	11.4946	11.5036	11.4893	11.4929	443884.0
2010-12-17 09:00:00	AAPL	Stock	11.5007	11.5018	11.47	11.47	610568.0
2010-12-17 09:30:00	AAPL	Stock	11.475	11.4925	11.4571	11.4707	34779500.0
2010-12-17 10:00:00	AAPL	Stock	11.4707	11.474	11.4407	11.4721	23660308.0
2010-12-17 10:30:00	AAPL	Stock	11.4707	11.4729	11.4539	11.4639	12041792.0
2010-12-17 11:00:00	AAPL	Stock	11.4646	11.4743	11.4614	11.4725	11714612.0
2010-12-17 11:30:00	AAPL	Stock	11.4711	11.4814	11.4657	11.4711	12329016.0
2010-12-17 12:00:00	AAPL	Stock	11.4714	11.4775	11.4597	11.4661	12743360.0
2010-12-17 12:30:00	AAPL	Stock	11.4654	11.4743	11.4625	11.4686	7530544.0
2010-12-17 13:00:00	AAPL	Stock	11.4696	11.4786	11.4689	11.4746	8275764.0
2010-12-17 13:30:00	AAPL	Stock	11.4746	11.4771	11.4625	11.4689	8538656.0
2010-12-17 14:00:00	AAPL	Stock	11.4693	11.4711	11.4571	11.4637	10560620.0
2010-12-17 14:30:00	AAPL	Stock	11.463	11.4646	11.4504	11.4618	17569188.0
2010-12-17 15:00:00	AAPL	Stock	11.4611	11.4636	11.4504	11.4543	20226836.0
2010-12-17 15:30:00	AAPL	Stock	11.4546	11.4586	11.4368	11.4521	48674724.0
2010-12-17 16:00:00	AAPL	Stock	11.4521	11.4759	11.4446	11.4504	37137688.0
2010-12-17 16:30:00	AAPL	Stock	11.4464	11.4676	11.4321	11.4414	6298712.0
2010-12-17 17:00:00	AAPL	Stock	11.4414	11.4503	11.4321	11.4404	752276.0
2010-12-17 17:30:00	AAPL	Stock	11.4386	11.4526	11.4379	11.4393	438984.0
2010-12-17 18:00:00	AAPL	Stock	11.4382	11.4507	11.4357	11.4411	239120.0
2010-12-17 18:30:00	AAPL	Stock	11.4429	11.4429	11.4375	11.4393	28280.0
2010-12-17 19:00:00	AAPL	Stock	11.4443	11.4443	11.4411	11.4411	28000.0
2010-12-17 19:30:00	AAPL	Stock	11.4429	11.445	11.4418	11.4418	48860.0
2010-12-17 07:00:00	MSFT	Stock	27.9	27.9	27.9	27.9	500.0
2010-12-17 08:00:00	MSFT	Stock	27.94	27.95	27.94	27.95	18662.0
2010-12-17 08:30:00	MSFT	Stock	27.94	27.96	27.94	27.95	9281.0
2010-12-17 09:00:00	MSFT	Stock	27.95	27.99	27.88	27.92	346698.0
2010-12-17 09:30:00	MSFT	Stock	27.93	28.03	27.83	27.89	11126343.0
2010-12-17 10:00:00	MSFT	Stock	27.89	27.948	27.82	27.92	3624681.0
2010-12-17 10:30:00	MSFT	Stock	27.922	27.99	27.91	27.952	3274642.0
2010-12-17 11:00:00	MSFT	Stock	27.958	28.0	27.94	27.979	1893843.0
2010-12-17 11:30:00	MSFT	Stock	27.97	27.99	27.94	27.97	2204218.0
2010-12-17 12:00:00	MSFT	Stock	27.975	27.98	27.87	27.915	2233572.0
2010-12-17 12:30:00	MSFT	Stock	27.92	28.05	27.91	28.02	2667356.0
2010-12-17 13:00:00	MSFT	Stock	28.028	28.09	28.01	28.04	3565262.0
2010-12-17 13:30:00	MSFT	Stock	28.04	28.09	28.0	28.0	3195942.0
2010-12-17 14:00:00	MSFT	Stock	28.01	28.04	27.99	28.031	2009922.0
2010-12-17 14:30:00	MSFT	Stock	28.035	28.04	27.93	27.958	2719939.0
2010-12-17 15:00:00	MSFT	Stock	27.96	28.01	27.94	28.0	2668985.0
2010-12-17 15:30:00	MSFT	Stock	27.99	28.002	27.75	27.75	9993856.0
2010-12-17 16:00:00	MSFT	Stock	27.8	27.99	27.75	27.79	16331848.0
2010-12-17 16:30:00	MSFT	Stock	27.92	27.92	27.784	27.908	2689392.0
2010-12-17 17:00:00	MSFT	Stock	27.93	27.95	27.796	27.796	143236.0
2010-12-17 17:30:00	MSFT	Stock	27.796	27.91	27.79	27.792	123259.0
2010-12-17 18:00:00	MSFT	Stock	27.9	27.9	27.783	27.9	17824.0

> showing 50 of 81,270 rows — these rows as CSV

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