PREVIEW / stock_30min / 2010-06-25

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-06-25.parquet
  size:    1.5 MB
  rows:    79,818
  symbols: 3,446

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-06-25 05:00:00	AAPL	Stock	9.6111	9.6111	9.5989	9.5989	5600.0
2010-06-25 05:30:00	AAPL	Stock	9.5896	9.5896	9.5896	9.5896	2800.0
2010-06-25 06:00:00	AAPL	Stock	9.5825	9.5825	9.5711	9.5711	46788.0
2010-06-25 06:30:00	AAPL	Stock	9.6004	9.6004	9.6004	9.6004	2800.0
2010-06-25 07:00:00	AAPL	Stock	9.635	9.6429	9.6168	9.6343	147420.0
2010-06-25 07:30:00	AAPL	Stock	9.6429	9.6711	9.6429	9.6521	211036.0
2010-06-25 08:00:00	AAPL	Stock	9.6625	9.6629	9.625	9.625	1152480.0
2010-06-25 08:30:00	AAPL	Stock	9.6307	9.6607	9.6004	9.6468	2451372.0
2010-06-25 09:00:00	AAPL	Stock	9.6479	9.6589	9.6264	9.6464	1065736.0
2010-06-25 09:30:00	AAPL	Stock	9.6468	9.6525	9.5321	9.5975	92485848.0
2010-06-25 10:00:00	AAPL	Stock	9.6	9.6336	9.5275	9.5568	65506280.0
2010-06-25 10:30:00	AAPL	Stock	9.5568	9.5639	9.5011	9.5093	49701540.0
2010-06-25 11:00:00	AAPL	Stock	9.5125	9.5411	9.4932	9.5333	32946760.0
2010-06-25 11:30:00	AAPL	Stock	9.5354	9.5571	9.5171	9.5357	25990748.0
2010-06-25 12:00:00	AAPL	Stock	9.5359	9.5625	9.5239	9.5528	20887104.0
2010-06-25 12:30:00	AAPL	Stock	9.5532	9.5754	9.5318	9.5389	22261148.0
2010-06-25 13:00:00	AAPL	Stock	9.54	9.5807	9.5346	9.575	24567368.0
2010-06-25 13:30:00	AAPL	Stock	9.5761	9.6032	9.5568	9.5607	32925284.0
2010-06-25 14:00:00	AAPL	Stock	9.5605	9.5894	9.5375	9.5768	24384808.0
2010-06-25 14:30:00	AAPL	Stock	9.577	9.5812	9.5429	9.5536	18301920.0
2010-06-25 15:00:00	AAPL	Stock	9.5539	9.5629	9.515	9.536	27776784.0
2010-06-25 15:30:00	AAPL	Stock	9.5361	9.5757	9.5	9.5004	59535952.0
2010-06-25 16:00:00	AAPL	Stock	9.5	9.5587	9.4825	9.5139	26868100.0
2010-06-25 16:30:00	AAPL	Stock	9.4989	9.5427	9.4964	9.5014	11042948.0
2010-06-25 17:00:00	AAPL	Stock	9.5175	9.5207	9.4946	9.5154	1228584.0
2010-06-25 17:30:00	AAPL	Stock	9.5175	9.5571	9.5129	9.5168	591388.0
2010-06-25 18:00:00	AAPL	Stock	9.5161	9.525	9.4989	9.5196	298816.0
2010-06-25 18:30:00	AAPL	Stock	9.5211	9.5214	9.5189	9.5214	89516.0
2010-06-25 19:00:00	AAPL	Stock	9.5214	9.5221	9.5186	9.52	142576.0
2010-06-25 19:30:00	AAPL	Stock	9.5154	9.5214	9.5154	9.5196	131600.0
2010-06-25 05:30:00	MSFT	Stock	24.86	24.86	24.86	24.86	1000.0
2010-06-25 06:30:00	MSFT	Stock	24.92	24.93	24.92	24.93	1118.0
2010-06-25 07:00:00	MSFT	Stock	25.0	25.0	25.0	25.0	1500.0
2010-06-25 07:30:00	MSFT	Stock	25.08	25.18	25.08	25.16	37765.0
2010-06-25 08:00:00	MSFT	Stock	25.16	25.17	25.1	25.14	65158.0
2010-06-25 08:30:00	MSFT	Stock	25.11	25.12	25.05	25.07	9600.0
2010-06-25 09:00:00	MSFT	Stock	25.08	25.14	25.02	25.03	56720.0
2010-06-25 09:30:00	MSFT	Stock	25.04	25.11	24.74	24.76	8800931.0
2010-06-25 10:00:00	MSFT	Stock	24.75	25.1	24.75	24.86	6255570.0
2010-06-25 10:30:00	MSFT	Stock	24.855	24.87	24.67	24.7	5132044.0
2010-06-25 11:00:00	MSFT	Stock	24.7	24.89	24.695	24.88	4267401.0
2010-06-25 11:30:00	MSFT	Stock	24.89	24.92	24.79	24.81	2674540.0
2010-06-25 12:00:00	MSFT	Stock	24.81	24.89	24.78	24.84	3347306.0
2010-06-25 12:30:00	MSFT	Stock	24.85	24.87	24.72	24.745	3181782.0
2010-06-25 13:00:00	MSFT	Stock	24.745	25.0	24.73	24.99	3632540.0
2010-06-25 13:30:00	MSFT	Stock	24.989	25.09	24.97	24.995	5525812.0
2010-06-25 14:00:00	MSFT	Stock	24.995	25.0	24.77	24.8	5012471.0
2010-06-25 14:30:00	MSFT	Stock	24.795	24.85	24.68	24.73	4821332.0
2010-06-25 15:00:00	MSFT	Stock	24.73	24.74	24.67	24.68	5938269.0
2010-06-25 15:30:00	MSFT	Stock	24.68	24.8	24.37	24.38	17821029.0

> showing 50 of 79,818 rows — these rows as CSV

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