PREVIEW / stock_30min / 2010-08-25

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-08-25.parquet
  size:    1.4 MB
  rows:    75,239
  symbols: 3,469

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-08-25 04:30:00	AAPL	Stock	8.6171	8.6296	8.5893	8.6296	21000.0
2010-08-25 05:00:00	AAPL	Stock	8.6071	8.6071	8.5975	8.5975	5600.0
2010-08-25 05:30:00	AAPL	Stock	8.585	8.585	8.585	8.585	2800.0
2010-08-25 07:00:00	AAPL	Stock	8.5343	8.5764	8.5343	8.5632	97468.0
2010-08-25 07:30:00	AAPL	Stock	8.5639	8.5639	8.5532	8.5536	117600.0
2010-08-25 08:00:00	AAPL	Stock	8.5546	8.5546	8.5314	8.5454	833392.0
2010-08-25 08:30:00	AAPL	Stock	8.5457	8.5536	8.5	8.5018	2180864.0
2010-08-25 09:00:00	AAPL	Stock	8.5025	8.5171	8.4968	8.5029	2125368.0
2010-08-25 09:30:00	AAPL	Stock	8.5014	8.5796	8.4839	8.5161	98163156.0
2010-08-25 10:00:00	AAPL	Stock	8.5161	8.5454	8.4789	8.5179	64651776.0
2010-08-25 10:30:00	AAPL	Stock	8.5175	8.5357	8.4714	8.5343	56846916.0
2010-08-25 11:00:00	AAPL	Stock	8.5329	8.5829	8.5136	8.574	52933356.0
2010-08-25 11:30:00	AAPL	Stock	8.5725	8.5786	8.5464	8.5525	23577064.0
2010-08-25 12:00:00	AAPL	Stock	8.5521	8.5775	8.5325	8.5375	22828876.0
2010-08-25 12:30:00	AAPL	Stock	8.5382	8.5446	8.515	8.5279	19563236.0
2010-08-25 13:00:00	AAPL	Stock	8.5291	8.5446	8.5214	8.5279	15636432.0
2010-08-25 13:30:00	AAPL	Stock	8.5273	8.5611	8.5214	8.5561	17520104.0
2010-08-25 14:00:00	AAPL	Stock	8.5561	8.5982	8.5529	8.5866	41228768.0
2010-08-25 14:30:00	AAPL	Stock	8.5875	8.6514	8.5825	8.65	50756440.0
2010-08-25 15:00:00	AAPL	Stock	8.6495	8.6743	8.6396	8.6479	44623264.0
2010-08-25 15:30:00	AAPL	Stock	8.6475	8.7139	8.6475	8.6746	68008332.0
2010-08-25 16:00:00	AAPL	Stock	8.6746	8.6839	8.5715	8.6839	9353988.0
2010-08-25 16:30:00	AAPL	Stock	8.6857	8.7103	8.5064	8.6811	1453088.0
2010-08-25 17:00:00	AAPL	Stock	8.6775	8.7079	8.6771	8.7007	910000.0
2010-08-25 17:30:00	AAPL	Stock	8.7025	8.7057	8.6989	8.7054	198044.0
2010-08-25 18:00:00	AAPL	Stock	8.7032	8.705	8.6746	8.6982	367444.0
2010-08-25 18:30:00	AAPL	Stock	8.7021	8.7046	8.6986	8.7	81088.0
2010-08-25 19:00:00	AAPL	Stock	8.7	8.7046	8.7	8.7046	87584.0
2010-08-25 19:30:00	AAPL	Stock	8.7046	8.7082	8.7018	8.7036	367052.0
2010-08-25 08:00:00	MSFT	Stock	24.03	24.04	24.0	24.01	1875.0
2010-08-25 08:30:00	MSFT	Stock	24.01	24.01	23.95	23.95	17853.0
2010-08-25 09:00:00	MSFT	Stock	23.99	24.05	23.95	23.96	46659.0
2010-08-25 09:30:00	MSFT	Stock	23.95	24.08	23.88	23.94	5773691.0
2010-08-25 10:00:00	MSFT	Stock	23.94	24.05	23.87	23.92	5670597.0
2010-08-25 10:30:00	MSFT	Stock	23.91	24.078	23.88	24.06	2941409.0
2010-08-25 11:00:00	MSFT	Stock	24.05	24.21	24.02	24.176	4559893.0
2010-08-25 11:30:00	MSFT	Stock	24.179	24.18	24.09	24.14	2262328.0
2010-08-25 12:00:00	MSFT	Stock	24.13	24.18	24.08	24.085	2297109.0
2010-08-25 12:30:00	MSFT	Stock	24.09	24.13	24.05	24.075	1498820.0
2010-08-25 13:00:00	MSFT	Stock	24.079	24.1	24.02	24.05	1827960.0
2010-08-25 13:30:00	MSFT	Stock	24.05	24.175	24.05	24.11	2444582.0
2010-08-25 14:00:00	MSFT	Stock	24.11	24.16	24.1	24.14	2553906.0
2010-08-25 14:30:00	MSFT	Stock	24.14	24.22	24.1	24.18	2876856.0
2010-08-25 15:00:00	MSFT	Stock	24.18	24.19	24.07	24.11	3477250.0
2010-08-25 15:30:00	MSFT	Stock	24.11	24.21	24.08	24.1	6089106.0
2010-08-25 16:00:00	MSFT	Stock	24.11	24.16	24.03	24.105	2223510.0
2010-08-25 16:30:00	MSFT	Stock	24.1	24.195	23.938	23.938	183969.0
2010-08-25 17:00:00	MSFT	Stock	24.15	24.15	24.15	24.15	1000.0
2010-08-25 17:30:00	MSFT	Stock	24.11	24.11	24.11	24.11	4062.0
2010-08-25 18:00:00	MSFT	Stock	24.1	24.1	24.1	24.1	36727.0

> showing 50 of 75,239 rows — these rows as CSV

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