PREVIEW / stock_30min / 2010-02-04

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-02-04.parquet
  size:    1.4 MB
  rows:    73,877
  symbols: 3,441

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-02-04 04:00:00	AAPL	Stock	7.1325	7.1325	7.1325	7.1325	3640.0
2010-02-04 05:00:00	AAPL	Stock	7.1089	7.1089	7.1089	7.1089	2800.0
2010-02-04 05:30:00	AAPL	Stock	7.1214	7.1214	7.0929	7.0929	38192.0
2010-02-04 06:00:00	AAPL	Stock	7.0929	7.0929	7.0896	7.0896	5600.0
2010-02-04 06:30:00	AAPL	Stock	7.0871	7.0875	7.0871	7.0875	9800.0
2010-02-04 07:00:00	AAPL	Stock	7.1143	7.1143	7.0643	7.0893	159040.0
2010-02-04 07:30:00	AAPL	Stock	7.0896	7.0896	7.0643	7.07	329084.0
2010-02-04 08:00:00	AAPL	Stock	7.0718	7.0821	7.0536	7.0661	1971956.0
2010-02-04 08:30:00	AAPL	Stock	7.0657	7.0657	7.0293	7.0443	2386496.0
2010-02-04 09:00:00	AAPL	Stock	7.0439	7.0443	7.0157	7.0282	2878904.0
2010-02-04 09:30:00	AAPL	Stock	7.0279	7.0846	6.9714	6.9839	107393916.0
2010-02-04 10:00:00	AAPL	Stock	6.9839	7.0046	6.9643	6.975	69367312.0
2010-02-04 10:30:00	AAPL	Stock	6.9754	6.9896	6.9429	6.9525	51496648.0
2010-02-04 11:00:00	AAPL	Stock	6.9504	6.9729	6.9364	6.9557	41499808.0
2010-02-04 11:30:00	AAPL	Stock	6.9546	6.9571	6.8721	6.8939	62176632.0
2010-02-04 12:00:00	AAPL	Stock	6.8932	6.9164	6.8764	6.9071	37269484.0
2010-02-04 12:30:00	AAPL	Stock	6.9075	6.9246	6.8893	6.9121	42911680.0
2010-02-04 13:00:00	AAPL	Stock	6.9121	6.9286	6.9075	6.9286	22704528.0
2010-02-04 13:30:00	AAPL	Stock	6.9286	6.9389	6.8986	6.9061	32778144.0
2010-02-04 14:00:00	AAPL	Stock	6.9061	6.9271	6.8879	6.9218	40094208.0
2010-02-04 14:30:00	AAPL	Stock	6.9222	6.9321	6.9082	6.9167	33654572.0
2010-02-04 15:00:00	AAPL	Stock	6.9171	6.9207	6.8607	6.8686	75693044.0
2010-02-04 15:30:00	AAPL	Stock	6.8686	6.8711	6.8418	6.8571	107579052.0
2010-02-04 16:00:00	AAPL	Stock	6.8571	6.9342	6.8543	6.8575	11123784.0
2010-02-04 16:30:00	AAPL	Stock	6.8575	6.8607	6.8536	6.8586	1727684.0
2010-02-04 17:00:00	AAPL	Stock	6.8586	6.8593	6.8543	6.8589	291676.0
2010-02-04 17:30:00	AAPL	Stock	6.8607	6.8607	6.8493	6.8529	601972.0
2010-02-04 18:00:00	AAPL	Stock	6.8568	6.86	6.8536	6.8536	295092.0
2010-02-04 18:30:00	AAPL	Stock	6.8536	6.8589	6.8532	6.8536	255808.0
2010-02-04 19:00:00	AAPL	Stock	6.8521	6.8554	6.8482	6.8489	214788.0
2010-02-04 19:30:00	AAPL	Stock	6.85	6.8557	6.85	6.8532	334432.0
2010-02-04 04:00:00	MSFT	Stock	28.65	28.65	28.65	28.65	100.0
2010-02-04 07:00:00	MSFT	Stock	28.61	28.61	28.55	28.55	3000.0
2010-02-04 07:30:00	MSFT	Stock	28.55	28.55	28.55	28.55	1500.0
2010-02-04 08:00:00	MSFT	Stock	28.55	28.55	28.5	28.54	6850.0
2010-02-04 08:30:00	MSFT	Stock	28.53	28.55	28.45	28.47	10070.0
2010-02-04 09:00:00	MSFT	Stock	28.47	28.54	28.37	28.37	47679.0
2010-02-04 09:30:00	MSFT	Stock	28.37	28.5	28.12	28.149	7109224.0
2010-02-04 10:00:00	MSFT	Stock	28.14	28.26	28.05	28.12	5686618.0
2010-02-04 10:30:00	MSFT	Stock	28.121	28.13	27.9	27.902	9052516.0
2010-02-04 11:00:00	MSFT	Stock	27.9	28.15	27.86	28.03	5975531.0
2010-02-04 11:30:00	MSFT	Stock	28.03	28.07	27.91	28.013	3262499.0
2010-02-04 12:00:00	MSFT	Stock	28.01	28.08	27.94	27.98	3127747.0
2010-02-04 12:30:00	MSFT	Stock	27.975	28.044	27.88	28.01	3613911.0
2010-02-04 13:00:00	MSFT	Stock	28.0	28.1	27.965	28.09	2845217.0
2010-02-04 13:30:00	MSFT	Stock	28.09	28.14	28.0	28.05	3282814.0
2010-02-04 14:00:00	MSFT	Stock	28.05	28.11	27.98	28.05	3705331.0
2010-02-04 14:30:00	MSFT	Stock	28.05	28.11	28.02	28.04	3130923.0
2010-02-04 15:00:00	MSFT	Stock	28.04	28.06	27.84	27.88	8119538.0
2010-02-04 15:30:00	MSFT	Stock	27.88	27.98	27.81	27.81	12247278.0

> showing 50 of 73,877 rows — these rows as CSV

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