PREVIEW / stock_30min / 2010-11-18

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-11-18.parquet
  size:    1.4 MB
  rows:    76,469
  symbols: 3,495

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-11-18 04:00:00	AAPL	Stock	10.8836	10.8893	10.8836	10.8893	19600.0
2010-11-18 04:30:00	AAPL	Stock	10.8704	10.8704	10.8643	10.8643	11200.0
2010-11-18 05:00:00	AAPL	Stock	10.8661	10.8661	10.8571	10.8571	5600.0
2010-11-18 05:30:00	AAPL	Stock	10.8596	10.8596	10.8596	10.8596	18620.0
2010-11-18 06:00:00	AAPL	Stock	10.8654	10.8654	10.8654	10.8654	16800.0
2010-11-18 06:30:00	AAPL	Stock	10.875	10.875	10.8686	10.8743	64400.0
2010-11-18 07:00:00	AAPL	Stock	10.8729	10.8854	10.8571	10.8646	558180.0
2010-11-18 07:30:00	AAPL	Stock	10.8639	10.8704	10.85	10.86	193956.0
2010-11-18 08:00:00	AAPL	Stock	10.8582	10.8932	10.8521	10.8804	2589244.0
2010-11-18 08:30:00	AAPL	Stock	10.8771	10.8911	10.8711	10.8761	1233316.0
2010-11-18 09:00:00	AAPL	Stock	10.875	10.8964	10.8714	10.8964	1594320.0
2010-11-18 09:30:00	AAPL	Stock	10.8921	10.9464	10.8818	10.9411	85140272.0
2010-11-18 10:00:00	AAPL	Stock	10.9411	11.0139	10.9389	11.0096	74456396.0
2010-11-18 10:30:00	AAPL	Stock	11.0104	11.0268	10.9964	11.0157	41105960.0
2010-11-18 11:00:00	AAPL	Stock	11.0161	11.0314	11.0	11.0141	25311944.0
2010-11-18 11:30:00	AAPL	Stock	11.0143	11.0354	11.0121	11.0318	24939684.0
2010-11-18 12:00:00	AAPL	Stock	11.0318	11.0596	11.0318	11.0482	29845200.0
2010-11-18 12:30:00	AAPL	Stock	11.0479	11.048	11.0268	11.0336	22645952.0
2010-11-18 13:00:00	AAPL	Stock	11.035	11.0357	11.0218	11.0311	13111196.0
2010-11-18 13:30:00	AAPL	Stock	11.0312	11.0429	11.0254	11.0282	14666848.0
2010-11-18 14:00:00	AAPL	Stock	11.0286	11.0375	10.9964	11.0071	23684416.0
2010-11-18 14:30:00	AAPL	Stock	11.0056	11.0461	11.0056	11.035	23481808.0
2010-11-18 15:00:00	AAPL	Stock	11.035	11.0496	11.0196	11.0329	22671544.0
2010-11-18 15:30:00	AAPL	Stock	11.0329	11.0343	11.0011	11.0204	55290032.0
2010-11-18 16:00:00	AAPL	Stock	11.0089	11.0518	10.7321	11.0511	17789268.0
2010-11-18 16:30:00	AAPL	Stock	11.0511	11.0532	11.0124	11.045	2970772.0
2010-11-18 17:00:00	AAPL	Stock	11.0475	11.0482	11.02	11.0464	781172.0
2010-11-18 17:30:00	AAPL	Stock	11.0482	11.05	11.0464	11.05	170660.0
2010-11-18 18:00:00	AAPL	Stock	11.05	11.0532	11.0154	11.045	645428.0
2010-11-18 18:30:00	AAPL	Stock	11.0414	11.0454	11.0389	11.0421	292488.0
2010-11-18 19:00:00	AAPL	Stock	11.0446	11.0536	11.0411	11.0411	94668.0
2010-11-18 19:30:00	AAPL	Stock	11.0382	11.0386	11.0204	11.0246	757232.0
2010-11-18 06:30:00	MSFT	Stock	25.85	25.85	25.85	25.85	1000.0
2010-11-18 07:00:00	MSFT	Stock	25.82	25.82	25.76	25.81	1590.0
2010-11-18 07:30:00	MSFT	Stock	25.82	25.82	25.78	25.82	3850.0
2010-11-18 08:00:00	MSFT	Stock	25.82	25.82	25.72	25.79	21884.0
2010-11-18 08:30:00	MSFT	Stock	25.79	25.79	25.76	25.77	19751.0
2010-11-18 09:00:00	MSFT	Stock	25.77	25.8	25.66	25.66	67918.0
2010-11-18 09:30:00	MSFT	Stock	25.66	25.82	25.61	25.63	6233247.0
2010-11-18 10:00:00	MSFT	Stock	25.64	26.02	25.635	26.01	9862506.0
2010-11-18 10:30:00	MSFT	Stock	26.01	26.04	25.9	25.97	4472568.0
2010-11-18 11:00:00	MSFT	Stock	25.96	25.99	25.86	25.975	3893713.0
2010-11-18 11:30:00	MSFT	Stock	25.972	26.07	25.96	26.06	4004249.0
2010-11-18 12:00:00	MSFT	Stock	26.06	26.08	25.925	25.965	3486364.0
2010-11-18 12:30:00	MSFT	Stock	25.97	25.995	25.92	25.92	2166988.0
2010-11-18 13:00:00	MSFT	Stock	25.93	25.955	25.91	25.93	1251644.0
2010-11-18 13:30:00	MSFT	Stock	25.93	25.94	25.89	25.91	1514278.0
2010-11-18 14:00:00	MSFT	Stock	25.91	25.94	25.85	25.861	1779708.0
2010-11-18 14:30:00	MSFT	Stock	25.87	25.95	25.86	25.88	2610183.0
2010-11-18 15:00:00	MSFT	Stock	25.881	25.9	25.85	25.87	3156224.0

> showing 50 of 76,469 rows — these rows as CSV

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