PREVIEW / stock_30min / 2010-06-11

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-06-11.parquet
  size:    1.3 MB
  rows:    71,267
  symbols: 3,457

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-11 05:30:00	AAPL	Stock	8.9911	8.9911	8.9911	8.9911	2800.0
2010-06-11 06:00:00	AAPL	Stock	8.9821	8.9821	8.9821	8.9821	2800.0
2010-06-11 07:00:00	AAPL	Stock	8.9732	8.9732	8.94	8.94	58436.0
2010-06-11 07:30:00	AAPL	Stock	8.9525	8.9525	8.9396	8.9429	51800.0
2010-06-11 08:00:00	AAPL	Stock	8.9504	8.9618	8.9432	8.9546	413756.0
2010-06-11 08:30:00	AAPL	Stock	8.9482	8.9482	8.8564	8.8589	4456592.0
2010-06-11 09:00:00	AAPL	Stock	8.86	8.8671	8.8454	8.8632	2353372.0
2010-06-11 09:30:00	AAPL	Stock	8.8652	8.9107	8.8346	8.9046	83891584.0
2010-06-11 10:00:00	AAPL	Stock	8.9018	8.98	8.8896	8.96	63682220.0
2010-06-11 10:30:00	AAPL	Stock	8.96	8.9711	8.8968	8.9033	38848264.0
2010-06-11 11:00:00	AAPL	Stock	8.9057	8.9132	8.85	8.8693	40641076.0
2010-06-11 11:30:00	AAPL	Stock	8.8679	8.9264	8.8679	8.9218	30859724.0
2010-06-11 12:00:00	AAPL	Stock	8.9225	8.9314	8.8886	8.8989	18907700.0
2010-06-11 12:30:00	AAPL	Stock	8.8989	8.9314	8.8818	8.9214	19159644.0
2010-06-11 13:00:00	AAPL	Stock	8.9211	8.9729	8.9193	8.9464	27744024.0
2010-06-11 13:30:00	AAPL	Stock	8.9464	8.9511	8.9093	8.9275	25849404.0
2010-06-11 14:00:00	AAPL	Stock	8.9289	8.94	8.8946	8.9134	20465396.0
2010-06-11 14:30:00	AAPL	Stock	8.915	8.9643	8.9079	8.9472	26121872.0
2010-06-11 15:00:00	AAPL	Stock	8.9479	8.9896	8.9407	8.975	34015156.0
2010-06-11 15:30:00	AAPL	Stock	8.9766	9.0664	8.9714	9.0539	90652044.0
2010-06-11 16:00:00	AAPL	Stock	9.0539	9.0882	8.9337	9.0554	7681716.0
2010-06-11 16:30:00	AAPL	Stock	9.0539	9.0607	8.8703	9.0575	997976.0
2010-06-11 17:00:00	AAPL	Stock	8.9168	9.0586	8.9168	9.0536	2508604.0
2010-06-11 17:30:00	AAPL	Stock	9.0539	9.0582	9.0539	9.0564	54880.0
2010-06-11 18:00:00	AAPL	Stock	9.0582	9.0625	9.0539	9.0618	154168.0
2010-06-11 18:30:00	AAPL	Stock	9.0593	9.0621	9.0564	9.0564	67928.0
2010-06-11 19:00:00	AAPL	Stock	9.0571	9.0596	9.0539	9.0546	166040.0
2010-06-11 19:30:00	AAPL	Stock	9.0539	9.0632	9.0493	9.0543	677012.0
2010-06-11 05:30:00	MSFT	Stock	25.05	25.09	25.05	25.09	1500.0
2010-06-11 06:30:00	MSFT	Stock	25.07	25.07	25.07	25.07	100.0
2010-06-11 07:00:00	MSFT	Stock	25.07	25.1	25.05	25.05	2200.0
2010-06-11 07:30:00	MSFT	Stock	25.05	25.11	25.0	25.05	43200.0
2010-06-11 08:00:00	MSFT	Stock	25.05	25.05	25.01	25.04	4900.0
2010-06-11 08:30:00	MSFT	Stock	25.0	25.0	24.84	24.88	82723.0
2010-06-11 09:00:00	MSFT	Stock	24.88	25.04	24.88	25.04	66614.0
2010-06-11 09:30:00	MSFT	Stock	25.04	25.17	24.77	25.16	7572800.0
2010-06-11 10:00:00	MSFT	Stock	25.152	25.5	25.14	25.43	7695868.0
2010-06-11 10:30:00	MSFT	Stock	25.43	25.52	25.36	25.39	5052340.0
2010-06-11 11:00:00	MSFT	Stock	25.39	25.44	25.29	25.38	3527884.0
2010-06-11 11:30:00	MSFT	Stock	25.38	25.57	25.33	25.5	3801990.0
2010-06-11 12:00:00	MSFT	Stock	25.5	25.52	25.44	25.48	1969670.0
2010-06-11 12:30:00	MSFT	Stock	25.49	25.5	25.39	25.4	2330675.0
2010-06-11 13:00:00	MSFT	Stock	25.408	25.47	25.34	25.368	2499547.0
2010-06-11 13:30:00	MSFT	Stock	25.37	25.37	25.23	25.34	2365827.0
2010-06-11 14:00:00	MSFT	Stock	25.34	25.43	25.31	25.37	3173369.0
2010-06-11 14:30:00	MSFT	Stock	25.36	25.49	25.36	25.425	2228649.0
2010-06-11 15:00:00	MSFT	Stock	25.42	25.54	25.37	25.51	4610396.0
2010-06-11 15:30:00	MSFT	Stock	25.505	25.72	25.5	25.67	13962063.0
2010-06-11 16:00:00	MSFT	Stock	25.68	25.71	24.99	25.66	5800853.0
2010-06-11 16:30:00	MSFT	Stock	25.65	25.66	25.517	25.58	139425.0

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

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